12
12
mysqlreplicate - establish replication with a master
15
--version show program's version number and exit
17
--master=MASTER connection information for master server in the form:
18
<user>:<password>@<host>:<port>:<socket>
19
--slave=SLAVE connection information for slave server in the form:
20
<user>:<password>@<host>:<port>:<socket>
21
--rpl-user=RPL_USER the user and password for the replication user
22
requirement - e.g. rpl:passwd - default = rpl:rpl
23
-p, --pedantic Fail if storage engines differ among master and slave.
24
--test-db=TEST_DB database name to use in testing replication setup
26
-v, --verbose Control how much information is displayed. e.g., -v =
27
verbose, -vv = more verbose, -vvv = debug
28
-q, --quiet Turn off all messages for quiet execution.
15
--version show program's version number and exit
17
--master=MASTER connection information for master server in the form:
18
<user>:<password>@<host>:<port>:<socket>
19
--slave=SLAVE connection information for slave server in the form:
20
<user>:<password>@<host>:<port>:<socket>
21
--rpl-user=RPL_USER the user and password for the replication user
22
requirement - e.g. rpl:passwd - default = rpl:rpl
23
-p, --pedantic Fail if storage engines differ among master and slave.
24
--test-db=TEST_DB database name to use in testing replication setup
26
--master-log-file=MASTER_LOG_FILE
27
Use this master log file to initiate the slave.
28
--master-log-pos=MASTER_LOG_POS
29
Use this position in the master log file to initiate
31
-b, --start-from-beginning
32
Start replication from the first event recorded in the
33
binary logging of the master.Not valid with --master-
34
log-file or --master-log-pos.
35
-v, --verbose Control how much information is displayed. e.g., -v =
36
verbose, -vv = more verbose, -vvv = debug
37
-q, --quiet Turn off all messages for quiet execution.
29
38
Test case 3 - use the verbose feature
30
39
# master on localhost: ... connected.
31
40
# slave on localhost: ... connected.
36
45
# Checking for binary logging on master...
37
46
# Setting up replication...
38
47
# Connecting slave to master...
40
# Unlocking tables on master...
48
# Starting slave from master's last position...
50
Test case 4 - use the start-from-beginning feature
51
# master on localhost: ... connected.
52
# slave on localhost: ... connected.
53
# Checking for binary logging on master...
54
# Setting up replication...