Differences

This shows you the differences between two versions of the page.

--- mysql:changemasters [2015/06/24 16:59] – rlunaro
+++ mysql:changemasters [2022/12/02 21:02] (current) – external edit 127.0.0.1
@@ Line 111: / Line 111: @@
 grant replication slave, replication client on *.* to YOUR-REPLICATION-USERNAME identified by 'YOUR-REPLICATION-PASSWORD';
 </code>
+==== Check master status an take note of the master log file and master log position ====
+We have to issue a ''show master status'' command to get the file and log position of our new master:
+<code>
+mysql> show master status\G
+*************************** 1. row ***************************
+             File: YOUR-MASTER-LOG-FILE
+         Position: YOUR-MASTER-LOG-POS
+     Binlog_Do_DB:
+ Binlog_Ignore_DB:
+Executed_Gtid_Set:
+row in set (0.00 sec)
+</code>
+With this two values, YOUR-MASTER-LOG-FILE and YOUR-MASTER-LOG-POS, we can move to the
+slave and issue a change master to command.
 ==== Issue a change master command ====
@@ Line 122: / Line 140: @@
 master_port=3306,
 master_user='YOUR-REPLICATION-USERNAME',
-master_password='YOUR-REPLICATION-PASSWORD';
+master_password='YOUR-REPLICATION-PASSWORD',
+master_log_file = 'YOUR-MASTER-LOG-FILE',
+master_log_pos = YOUR-MASTER-LOG-POSITION;
+start slave;
 </code>
 And I've stopped and started the slave.
+===== Final check =====
+You can double check that your slave is working with the new configuration just by the method of looking
+one change made in the new master.