MySQL Replication: Difference between revisions
From DWIKI
mNo edit summary |
|||
| Line 15: | Line 15: | ||
SHOW BINLOG EVENTS | SHOW BINLOG EVENTS | ||
CHANGE MASTER TO | 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 | |||
Revision as of 12:02, 16 June 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
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
