Differences

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

--- mysql:recoveringsynchronization [2017/11/11 13:33] – rlunaro
+++ mysql:recoveringsynchronization [2022/12/02 22:02] (current) – external edit 127.0.0.1
@@ Line 15: / Line 15: @@
 <code>
 mysql> stop slave;
+-- disable the slow query log is necessary because
+-- in the event of a full restore, the logging tables
+-- are dropped
+mysql> SET GLOBAL slow_query_log=0;
+mysql> set global general_log=0;
 </code>
@@ Line 96: / Line 101: @@
 </code>
-Annotate these "File" and "position": it will be neede futher.
+Annotate these "File" and "position": it will be needed futher.
 ==== Fourth step: make a full backup of your database ====
@@ Line 129: / Line 134: @@
 For the replication it is a common place to have a user for this task. In my case is the ''repl'' user. Because I've changed the password in the first steps, I have to set the original password back now.
+<WRAP left round info 20%>
+Do this in the slave
+</WRAP>
 <WRAP left round important 20%>
-Do this in the master
+Do this in the slave
 </WRAP>
 <code>
 update mysql.user set password = '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' where user = 'repl';
@@ Line 154: / Line 161: @@
 master_port = 3306,
 master_log_file = 'you have to guess the log file name that goes here from the slave',
-master_log_pos = 4;  -- everybody put 4 here, I don't know why
+master_log_pos = ENTER THE POSITION YOU ANNOTATE IN THE LAST COMMAND;
+</code>
+And start the slave:
+<WRAP left round info 20%>
+Do this in the slave
+</WRAP>
+<code>
+start slave;
+mysql> SET GLOBAL slow_query_log=1;
+mysql> set global general_log=1;
 </code>