mysql:recoveringsynchronization
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
mysql:recoveringsynchronization [2017/11/11 15:57] – [Sixth step: issue a change master to command in the slave] rlunaro | mysql:recoveringsynchronization [2022/12/02 21:02] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
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; | + | master_log_pos = ENTER THE POSITION YOU ANNOTATE IN THE LAST COMMAND; |
+ | </ | ||
+ | |||
+ | And start the slave: | ||
+ | |||
+ | <WRAP left round info 20%> | ||
+ | Do this in the slave | ||
+ | </ | ||
+ | < | ||
+ | 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.1510415879.txt.gz · Last modified: 2022/12/02 21:02 (external edit)