… operation DDL statements as RENAME TABLE – these are most vulnerable. master.info corruption – If slave happens to crash you can also have relay… table or any other statement – it is table open which is important. There are other problems which you may experience related to MySQL Crash…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… MySQL Replication for upgrade. Once you have setup slave with new version and made it to caught up you can use mk-table… however it is not possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret… upgrades in time a bit so if something happens (like MySQL crashes) you have only one/few shard to deal with. P…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… if you’re only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely… getting Crash Safe replication with MySQL is not impossible but surely more complicated and has much higher performance overhead – you can run slave…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… the randgen workload was having an effect on the test tables between crash/recovery/validate cycles. To examine this for yourself during… the comparisons of master-slave checksums after the master has crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5.5 –test-debug…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… the reasons when SLAVE will not restart normally – power goes down MySQL crashes etc. If you however are using MEMORY table in replication and…; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run SLAVE START; Remove skip-slave-start from…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on… to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK… need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server to continue, which…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… available in MySQL 5.6 …- Multi-Threaded Slave – Global Transaction Identifiers – Crash Safe Slave and Binlog …Tables – - INNODB_METRICS – - Meta Data Information Tables – - Buffer Pool Information Tables – Improved PERFORMANCE_SCHEMA – - Reduced Overhead – - Simplified Configuration – - Table…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… actually need DOS prevention this variable strives to provide as MySQL is typically protected by Firewall to begin with. open_files… be badly out of sync if slave is to crash. The recommendation to use master_info_repository=table is a good one though…
Post: Announcement of Percona XtraDB Cluster 5.5.24
June 7, 2012 By 4 Comments
… includes an important bug fix: table with no PK but still having UK, can cause crash in slave using PA Binaries are available…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…crash on concurrent ALTER TABLE and SHOW ENGINE INNODB STATUS. Bug fixed #1017192 (Sergei Glushchenko). The server could crash…option innodb_changed_pages_limit. MySQL option handling would then …table and the slave needs to have at least one of those tables specified in the replicate-ignore-table…
