1. From slave if we run\u00a0mysql> mysql slave status<\/b>;
\nit will show last bin file slave reads from master
\nand all,so\u00a0start from that bin file to sink with master to slave.<\/p>\n
2. Set Master configuration on the Slave.
\nExecute the following command on a MySQL prompt to sink slave with master:<\/p>\n
mysql > CHANGE MASTER TO MASTER_HOST=\u201910.100.10.80\u2019, MASTER_USER=\u2019repl\u2019, MASTER_PASSWORD=\u2019slavepassword\u2019, MASTER_LOG_FILE=\u2019mysql-bin.000003\u2019, MASTER_LOG_POS=106;<\/b><\/p>\n
This is how you tell Slave how to connect to Master in order to replicate. Note the log coordinates. These are the coordinates you got from step 1 above.<\/p>\n
[
\nNow we need to tell the slave where the master is located, which binlog file to use, and which position to start. Issue this\u00a0CHANGE MASTER TO\u00a0<\/b>
\ncommand on the slave server(s): (don\u2019t forget to change the values to match your master server)<\/p>\n
\u00a0mysql> CHANGE MASTER TO<\/b>
\n\u00a0 \u00a0 -> \u00a0 MASTER_HOST=’master IP address’,<\/b>
\n\u00a0 \u00a0 -> \u00a0 MASTER_USER=’replication user’,<\/b>
\n\u00a0 \u00a0 -> \u00a0 MASTER_PASSWORD=’replication user password’,<\/b>
\n\u00a0 \u00a0 -> \u00a0 MASTER_PORT=3306,<\/b>
\n\u00a0 \u00a0 -> \u00a0 MASTER_LOG_FILE=’mysql-bin.000015′,<\/b>
\n\u00a0 \u00a0 -> \u00a0 MASTER_LOG_POS=540,<\/b>
\n\u00a0 \u00a0 -> \u00a0 MASTER_CONNECT_RETRY=10;<\/b><\/p>\n
mysql> show warnings\\G<\/b><\/p>\n
Two values to note in the slave status shows us that our CHANGE MASTER TO statement worked:
\n
\n<\/b>\u00a0 \u00a0 Master_Log_File: mysql-bin.000015<\/b>
\n\u00a0 \u00a0 Read_Master_Log_Pos: 540<\/b>
\n]<\/p>\n
3.\u00a0Stop MySQL<\/b><\/p>\n
4.\u00a0Start MySQL normally<\/b><\/p>\n
Checking out that everything is OK<\/p>\n
Having started the slave MySQL node, you can log in and issue some commands to make sure that Slave is running OK.<\/p>\n
On mysql prompt, give the following command:<\/p>\n
mysql> show processlist;<\/b>
\n
\n<\/b>You can see the SQL thread that gets data from Master (in the above output is the thread with Id 2) and the SQL thread that executes the statements on Slave\u00a0(in the output is the thread with Id 1).<\/p>\n
2.\u00a0mysql> show slave status;<\/b><\/p>\n
This will display the current status on slave. Pay attention to the\u00a0*_Errno<\/b>\u00a0and\u00a0*_Error columns<\/b>.\u00a0Normally, you shouldn\u2019t see anything that indicates existence of errors there.<\/p>\n
3. On mysql prompt, give the following command
\n
\n<\/b>mysql> show status like \u2018Slave%\u2019;<\/b>
\n
\n<\/b>You should see an output like the following:
\n+—————————-+——-+
\n| Variable_name \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| Value |
\n+—————————-+——-+
\n| Slave_open_temp_tables \u00a0 \u00a0 | 0 \u00a0 \u00a0 |
\n| Slave_retried_transactions | 0 \u00a0 \u00a0 |
\n| Slave_running \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0| ON \u00a0 \u00a0|
\n+—————————-+——-+<\/p>\n
Pay attention to Slave_running being with value\u00a0ON<\/b>.<\/p>\n
Important note on binary log time to live<\/p>\n
As we have said before, you can have Slave down and
\nre-synchronize as soon as you bring it up again.But do not put it out of service for quite long because, then it will be impossible to synchronize its content with Master.<\/p>\n
This is because the binary logs on Master do not leave forever.<\/p>\n
There is the variable with name\u00a0expire_logs_days<\/b>\u00a0that determines the number of days for automatic binary log file removal. Check this out.\u00a0This should be 10, meaning that if you ever have your Slave down for 10 days or more, it will not be able to do replication as soon as you bring it up,\u00a0and you will have to \u00a0everything from the beginning.<\/p>\n","protected":false},"excerpt":{"rendered":"
1. From slave if we run mysql> mysql slave status; it will show last bin file slave reads from master and all,so start from that bin file to sink with master to slave.<\/p>\n
2. Set Master configuration on the Slave. Execute the following command on a MySQL prompt to sink slave with master:<\/p>\n
mysql > […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2234"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2234"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2234\/revisions"}],"predecessor-version":[{"id":2235,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2234\/revisions\/2235"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}