when faced with mysql replication failure problem,
"Please check the replication failure from Master Host"
do the following steps,
connect to the slave machine, open command prompt, it is cmd in windows or go to terminal in linux
connect to mysql as "mysql -u username -p", when prompt for password, enter the password
issue the command, "show slave status \G" and check for the errors. Check the parameter which tells how long the slave is behind the master.
Do then,
1. stop slave;
2. start slave;
3. show slave status \G. Again check for erros and no of seconds the slave is behind the master
Even if this doesn't work try restarting the mysql server in slave machine, in worst case try doing it in master and then repeat the above steps
If any of the mysql table is crashed, then execute the following command as
repair table db.tablename;
"Please check the replication failure from Master Host"
do the following steps,
connect to the slave machine, open command prompt, it is cmd in windows or go to terminal in linux
connect to mysql as "mysql -u username -p", when prompt for password, enter the password
issue the command, "show slave status \G" and check for the errors. Check the parameter which tells how long the slave is behind the master.
Do then,
1. stop slave;
2. start slave;
3. show slave status \G. Again check for erros and no of seconds the slave is behind the master
Even if this doesn't work try restarting the mysql server in slave machine, in worst case try doing it in master and then repeat the above steps
If any of the mysql table is crashed, then execute the following command as
repair table db.tablename;
No comments:
Post a Comment