… mine about it: http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… you’re only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely…. Until this issue is fixed getting Crash Safe replication with MySQL is not impossible but surely more complicated and has much higher performance overhead…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed… the “crash point” as I wished. (I didn’t shut down the slave, I just stopped the replication processes. This is safe to… be rolled back). But bug or no, it is what it is. There’s one more angle to the email thread that…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…ll call “reckless” and “safe” with no negative meaning implied 
Reckless approach…result. The more exotic or complicated functionality is the more likely it … ensure both MySQL does not crash under your load as well …replication bug – in any case you need to take care about these if you’re to be safe…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… First I think MongoDB is best compared no to MySQL Server but MySQL Cluster, …is not crash safe – similar to MyISAM database will need to be repaired if it crashes. Still…replication log). It was just fixed last month I understood. At the same time many things, including replication are a lot more…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…standard MySQL crash recovery, and it can be reduced even further. More on this later. Free No extra …it as snapshot while still having your data safe and secure. There are two types of snapshots …_pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified process you can clone …
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… ie replication based. If you can’t use replication because it is async and your load loads CPU more than … crashes it leaves table in potentially corrupted state which you need to check and repair before you can safely… anyone is using this setup and there is no QA being run with it (at least was …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…safe bet. I set it to 12G on 16GB box. UPDATE: If you’re looking for more…or two in case of full OS crash than set this value. It can dramatic…0 and even more to come with MySQL 5.1 and row level replication. There are…battery backed up cache with no OS changes and have no changes done to application …
