… if you don’t want to break replication or corrupt your data. Scenario #2: One of the slaves is …The master has crashed before sending all writes If the binary logs of the master are no longer readable, you will … work for every use case, and until this is fixed, it is good to be aware of the current …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream bug #49169 by avoiding the malloc… with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… restart at the beginning of the first available binary log, which is very likely to corrupt your data by reexecuting some queries. Here…. However, I don’t like the error message, specifically the ‘fix in config file’ part. What happens if we specify the…, replication will start at the beginning of the first available binary log file, with all the nasty consequences we can imagine. Even…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream bug #49169 by avoiding the malloc… with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you can… do you fix the problem first ? The important question you need to have answered – are logs corrupted on the master ? If logs on the…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you can… that something went wrong. It’s also much easier to fix the problem right now (either manually or with pt-table…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or RAID…running in a different timezone. We have a fix here. Details on how we dump schemas: loop…. With mysqlbinlog 5.6, you can now pull binary logs in real time to another server using “mysqlbinlog …
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… example for so they can be fixed. Corruption usually happens in secondary index, so simple ALTER TABLE fixes it This also seems to be the case. In my experience probably 80-90% of Innodb corruptions are fixed this… even week old backup and running roll forward recovery using binary log can be a lot faster.
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… with binary log and also if you’re looking for maximal data consistency (as SAN users often are) you better have binary log flushed on commit too. MySQL also has broken group commit (which we have partial fix for) meaning concurrent… the Firmware may have a glitch causing failure and data corruption (and this is not just a speculation, some clients really…
Post: Small things are better
October 8, 2006 By 15 Comments
… bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the table fixes it. Sometimes table needs to… need to reimport whole database – if corruption is happens to be in undo tablespace or log files. So do not forget to… restore, especially if you do point in time recovery using binary log to get to actual database state. The good practice to…
