Mysql> Show slave status;
Above command will show the status of replication. we see two column -- value for both should be 'Yes'.
a. SlaveIORunning -- 'Yes'
b.SlaveSQLRunning --'Yes'
Incase of replication failure value for the columns will be 'No'.
If value is 'No' look for the error. Note the logfile and logposition being read.
Stop slave. First Diagnose error and resync replication from the log position it broke.
Thursday, December 1, 2011
Trouble Shooting MySQL Replication.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment