… relay log files. This looks great, but does it ensure the replica is disconnected from its master? Let’s try: mysql> stop slave; Query… 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… of the first available binary log, which is very likely to corrupt your data by reexecuting some queries. Here’s a trick to…
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
… 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… in relay logs. Really this is only one of various error messages you could see if relay log corrupted. You could also see malformed queries (with…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… can break data integrity. One fairly common issue is binary log or relay log corruption. Will replication checksums help you in this case? Yes…_sql_verify_checksum=OFF; Query OK, 0 rows affected (0,00 sec) We’ll now simulate a relay log corruption by manually editing it…’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
… 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… scenarios. Cold Start – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…query_log_timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query_log…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…
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… query log, corrupted binary log and dig into MyISAM tables. You would ask who would ever need such recovery services – should not people just relay…
