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
mysql:recoveringsynchronization [2017/11/11 16:58] – [Sixth step: issue a change master to command in the slave] rlunaromysql:recoveringsynchronization [2022/12/02 22:02] (current) – external edit 127.0.0.1
Line 162: Line 162:
 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 = ENTER THE POSITION YOU ANNOTATE IN THE LAST COMMAND;   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.1510415901.txt.gz · Last modified: 2022/12/02 22:02 (external edit)