… slave was running with its binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…, every event is still written to the binary log on the master, but the slave determines what to do with it. The… the slaves at the bottom of the replication topology. On the top-level master, you leave all filters disabled; on the relay… resulting in less binary log data being sent down to the lower-level slaves. You can also use the slave_compressed_protocol option…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running… Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… ‘mysqlbinlog’ on the binary log), the slave‘s relay log is corrupted (you can check this by running ‘mysqlbinlog’ on the relay log), a network problem… binary log or slave‘s relay log, you will be able to know their names by issuing ‘SHOW SLAVE STATUS’ on this slave. This is relay relay log corruption…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… Master_Log_File: db01-bin.003814 Read_Master_Log_Pos: 744615652 Relay_Log_File: mysqld-relay-bin.000953 Relay_Log_Pos: 744615788 Relay_Master_Log_File: db01-bin.003814 Slave_IO_Running: Yes Slave_SQL_Running…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… the slave, SHOW SLAVE STATUS now reports an error (many fields omitted): SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL… the slave relay log. Examining the output of SHOW SLAVE STATUS, we can see that the slave is currently executing at relay log file: mysql_sandbox25162-relay-bin…
Comment: Review of MySQL 5.6 Defaults Changes
October 9, 2012 By 10 Comments
…_index_stats.ibd innodb_table_stats.ibd slave_master_info.ibd slave_relay_log_info.ibd slave_worker_info.ibd I expect it will cause…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…)) > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] Last_Errno: 1594 Last_Error: Relay log read failure: Could not parse relay log event entry… ‘mysqlbinlog’ on the binary log), the slave‘s relay log is corrupted (you can check this by running ‘mysqlbinlog’ on the relay log), a network problem…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…relay_logblogpercona.commanual relay_log_indexblogpercona.commanual relay_log_info_fileblogpercona.commanual relay_log_purgeblogpercona.commanual relay_log_recoveryblogpercona.commanual relay_log…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… relay log. That’s all. Even though there’s only one thread reading binary log from the master and one writing relay log on the slave… last binary log written by a master) Read_Master_Log_Pos – binary log from master is copied over to the relay log on the slave up… process – SQL thread – reads events from a relay log stored locally on the replication slave (the file that was written by IO thread…
