…January I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to give…- Optimized ROW Based Replication – Multi-Threaded Slave – Global Transaction Identifiers – Crash Safe Slave and Binlog – Replication Event Checksums – Time Delayed Replication – Server…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… it: http://www.mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server…
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 …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…_cluster_address (alternatively, you can use wsrep_urls in [mysqld_safe] section), which should point to a node in the cluster…] Recovering after a crash using mysql-bin 120619 13:21:19 [Note] Starting crash recovery… 120619 13:21:19 [Note] Crash recovery finished. 120619… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
Post: Beware: key_buffer_size larger than 4G does not work
February 14, 2007 By 17 Comments
… days MySQL crashes. Why ? Because key_buffer_size over 4GB in size is not really supported (checked with latest and greatest MySQL Enterprise… complicated to figure out what the problem is as MySQL will be crashing on random statements associated to random tables. What I… but even maximum key_buffer_size was not restricted to safe limit. Former would be close to changing single line of…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… and performance overhead. MySQL has to do several fsync() calls per transaction commit to be on the safe side and still number… are not fully safe – you can for example get .frm out of sync with internal data dictionary if you crash at wrong… nasty “FLUSH TABLE WITH READLOCK” and hoping nobody is touching “mysql” database any more. Single Storage Engine server would be also…
Post: Monty unviels Maria and starts Blogging
January 29, 2008 By 4 Comments
…) crash safe, meaning you will not have to deal with partially executed statements or check and repair tables in case of crash which… in his announcement still do not work – it takes time MySQL to update documentation and make worklog entries publicly visible, but… not to be transactional storage engine of choice for future MySQL. Again, Congratulations Monty, these are both great news ! UPDATE: I…
