… hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. Please help… of the crash. 130528 09:53:56 mysqld_safe Number of processes running now: 0 130528 09:53:56 mysqld_safe WSREP: not restarting wsrep node automatically 130528 09:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
….user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used when… and Debian installation. Bug fixed #1032139 (Alexey Bychko). The mysqld_safe script would fail to retrieve the Galera replication position on… Jaakola). If MySQL replication threads were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… after a crash, it has to get to disk. This has no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… applying application logic in between the statements that is not safe to retry after the database state changes. retry deadlocks Now…
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: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… after a crash. This feature was available even in previous release, but now I want to give some details. So, MySQL crashes from… 23:01:22 mysqld_safe Starting mysqld daemon with databases from /mnt/data/mysql 130129 23:01:22 mysqld_safe WSREP: Running position recovery with –log_error=/tmp/tmp.l1zf2BIDja 130129 23:01:45 mysqld_safe…
Post: MySQL Crash Recovery
July 30, 2006 By 30 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 24 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: Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
July 1, 2012 By 4 Comments
… completely crash safe in MySQL is the MySQL server manipulating FRM files. The only MySQL storage engine I’m aware of having fully crash safe DDL is MySQL Cluster (NDB). Proving that MEMORY is/isn’t crash safe around…
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…
