… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… avoid phantom reads and to get a consistent Statement based replication. To accomplish that, row level locking databases also acquire gap… that table. This makes reads consistent and therefore makes the replication between servers consistent. If you execute SELECT * FROM id > 1000…? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… gridlock one way or another. If you’re just using Innodb tables and you’re not actively changing users, stored procedures… writes to the slave can be done by simply pausing replication.
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any… Benchmarking Galera replication overhead Percona Server 5.5.15 + Galera 21.1-beta2 State of the art: Galera – synchronous replication for InnoDB Happy…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… features over the coming weeks. Major features include: Multi sourced replication XtraBackup included IPv6 data type ZeroMQ plugin Log output to… Drizzle function HTTP JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7.0 (which was…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…. New since 1.6: Percona XtraBackup can now save Galera replication information while performing a backup when given the –galera-info… for compiling and running Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users. The new features…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
Kristian, This is different issue. In many versions Innodb would print wrong position for current binary log (especially if ….mysqlperformanceblog.com/2008/01/29/no-more-mysql-crash-safe-replication-in-50/ We have fixed it in Percona Server. Also…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… quick overview of the whole replication hierarchy and specific things about it, such as replication filters, versions, whether replication is running, how far… errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com… 3 InnoDB version 1.0.16-12.8 So that’s how you can quickly find out what’s in your replication…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…, create a temporary table with ENGINE=InnoDB, and the InnoDB transaction ID does not change in SHOW INNODB STATUS. The statements are all…: use `test`; create temporary table test.t(a int) engine=innodb *************************** 3. row *************************** Log_name: mysql-bin.000011 Pos: 211 Event… the binlog individually, there’s clearly an opportunity to break replication here. It looks like this doesn’t avoid the problem…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… I’m not using replication and have my binary log disabled ? If replication is not used you can enable innodb_locks_unsafe_for_binlog option, which will relax locks which Innodb sets on… name says it makes locks unsafe fore replication and point in time recovery, so use innodb_locks_unsafe_for_binlog option with…
