… 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
… only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is likely for relay… does crash recovery it would print position in master log files up to which replication was done: InnoDB: In a MySQL replication… this thing works. Until this issue is fixed getting Crash Safe replication with MySQL is not impossible but surely more complicated and has…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… not only problem as we’ll see. MySQL has angel process mysqld_safe which will restart MySQL Server in most cases. It is… to crash again – such crashes qucikly following one another are kind of worse because they explore many less tested code paths in MySQL…. There are other problems which you may experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… more likely it is to run on wide set of MySQL versions. Safe Approach So what if you actually care about your… both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL… upgrades in time a bit so if something happens (like MySQL crashes) you have only one/few shard to deal with. P…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… MySQL Cluster and innodb_flush_log_at_trx_commit=2 mode. The second difference of course the fact MongoDB is not crash safe – similar to MyISAM database will need to be repaired if it crashes. Still I find behavior somewhat similar – you’re not expected to run MySQL Cluster without replication, MongoDB…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… later mounted same as original file system Why snapshot based MySQL backups are great ? There are number of reasons: Almost Hot… time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on… and use it as snapshot while still having your data safe and secure. There are two types of snapshots – some of…
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… “crash point” as I wished. (I didn’t shut down the slave, I just stopped the replication processes. This is safe to… statement had been logged, I think we might have been safe using a stored procedure. However, since all the statements went…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… potentially be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full documentation… should trigger an assertion failure in fil_io() at crash recovery. The safe thing would be to write redo log about the… should trigger an assertion failure in fil_io() at crash recovery. The safe thing would be to write redo log about the…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…more recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5…. Bug Fixed: #737569 (Valentine Gostev) xtrabackup would crash if the –parallel option was specified with… Bug fixed: #860133(Lachlan Mulcahy) With the –safe-slave-backup option, innobackupex always correctly …
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…binary. (Vadim Tkachenko) Added option –safe-slave-backupto innobackupex. (Daniel Nichter) Added option –safe-slave-backup-timeout to innobackupex. (…printed instead of crashing. (Alexey Kopytov) Bug #688211 – Using the –password option with innobackupex to specify MySQL passwords containing …
