…data corruption. MySQL provides the handy RESET SLAVE command. But as we’ll see, its behavior has changed along with the MySQL …Connect_Retry: 60 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…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
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… STATUS’ on this slave. This is relay relay log corruption and you can check details in the MySQL Error log file. The error message describes few…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can… ‘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…’s or slave’s MySQL code. If you want to check the master’s binary log or slave’s relay log, you will be…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… Innodb log and binary log are synchronized. In MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is… most vulnerable. master.info corruption – If slave happens to crash you can also have relay logs corruption and master.info being corrupted. Not to mention…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…overwrite_relay_log_info was renamed to innodb_recovery_update_relay_log. (Yasufumi Kinoshita) Old system variable innodb_pass_corrupt_table was renamed to innodb_corrupt…7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL bugs have been fixed in Percona Server. (…
Post: Percona Server 5.5.17-22.1 released
November 18, 2011 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.5.17, including all the bug fixes in it… have SHOW SLAVE STATUS give incorrect output due to a corrupted relay log. Bug Fixed: #860910 (Alexey Kopytov).
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…MySQL. Yet another way is using DRBD to get a standby MySQL server or at least synchronously replicated master binary logs…relay logs before re-pointing it. Interesting enough Google has solution for us again which comes as “log… may have master or relay binary log corruption. Master or Slave running …
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… of services which should be helpful to MySQL Community and which are not offered by MySQL, Oracle and other companies I know… Alexa 100 companies contacting us with recovery request because neither MySQL nor Oracle could help them to recover the date so… log, corrupted binary log and dig into MyISAM tables. You would ask who would ever need such recovery services – should not people just relay…
