MySQL Replication: Difference between revisions
From DWIKI
mNo edit summary |
mNo edit summary |
||
| Line 7: | Line 7: | ||
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html | http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html | ||
http://www.howtoforge.com/how-to-repair-mysql-replication | |||
=Useful commands= | =Useful commands= | ||
| Line 19: | Line 19: | ||
==Waiting for master to send event== | ==Waiting for master to send event== | ||
http://dev.mysql.com/doc/refman/5.0/en/slave-io-thread-states.html | http://dev.mysql.com/doc/refman/5.0/en/slave-io-thread-states.html | ||
Revision as of 15:15, 16 July 2008
- Advanced MySQL Replication Techniques
- http://dev.mysql.com/doc/refman/5.0/en/replication-howto-repuser.html
Clues
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html http://www.howtoforge.com/how-to-repair-mysql-replication
Useful commands
SHOW SLAVE STATUS SHOW BINARY LOGS SHOW BINLOG EVENTS CHANGE MASTER TO
FAQ
Waiting for master to send event
http://dev.mysql.com/doc/refman/5.0/en/slave-io-thread-states.html
Continue broken reproduction
On master:
show master status
On slave:
slave stop change master to master_log_file="00000001.bin" change master to master_log_pos=2345 slave start
