User Tools

Site Tools


mysql:recoveringsynchronization

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
mysql:recoveringsynchronization [2017/11/11 16:54] – [Third step: take note of the last position of the master database] rlunaromysql:recoveringsynchronization [2017/11/11 17:03] – [Sixth step: issue a change master to command in the slave] rlunaro
Line 161: Line 161:
 master_port = 3306, master_port = 3306,
 master_log_file = 'you have to guess the log file name that goes here from the slave', 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 slow_query_log=1; 
 mysql> set global general_log=1; mysql> set global general_log=1;
mysql/recoveringsynchronization.txt · Last modified: 2022/12/02 22:02 by 127.0.0.1