…’d suggest reading over the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in… 5.6 if you’re not using GTID-based replication. If you are using GTID-based replication, it looks like you’ll need to… server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance … 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…. This is because before Galera can create writesets for the replicated events, binlog events must be generated for the transactions first…, it would be good if your async master can use ROW based binlog format as well to achieve better consistency, if you… jobs and getting them through the replication stream expect some replication lag. This is because because synchronous replication inside PXC has an additional…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…. This isn’t the case with row-based replication. Only actual changes are written to the database with row-based logs. Take as an example… statement based binary log. Since row-based logs only contain information about changed rows, a replication slave which does not find a row referenced in a row-based…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… not exist for row-based replication in MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on… statement-based replication without some risk of breaking slaves. At some point I may test how it works with row-based replication; I believe even row-based…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… the master. Even though replicate-*-table options also have some issues they are much safer than database based counterparts. In some cases… wrote pretty good tutorial on creation for setting up BLACKHOLE Based Replication Filtering so I will not go into much of details… Replication can work pretty well for you. P.S It is in my todo to see how well MySQL 5.1 row based replication…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
Statement based replication writes the queries that modify data in the Binary Log to replicate them on the slave or to use it…> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert into… are working with statement based replication. Knowing in advances how MySQL works internally can help us to improve our replication availability and data.
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
… ROW* based replication. When using the latter, MySQL will log separate statements for each row that is deleted – so if the first 100 rows was… eventually replicated. [revin@forge rsandbox_5_5_170]$ ./master/use test … master [localhost] {msandbox} (test) > SELECT @@binlog_format; +—————–+ | @@binlog_format | +—————–+ | ROW | +—————–+ 1 row…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… and archiving data can be dramatic. Take It Easy On Replication Building aggregated tables is hard work for the database server…, assuming you use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5… the master with LOAD DATA INFILE, which kind of emulates row-based replication in a way. When you’re updating big aggregate tables…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… of tasks, much like InnoDB. However, PBXT’s log-based architecture makes performance characteristics different to both MyISAM and InnoDB… not SERIALIZABLE. A result of this is that statement-based replication is not supported by the engine. Another hard decision was… engine. And, fortunately MySQL 5.1. supports row-based replication which makes it possible to do replication while using REPEATABLE READ. PBXT does use…
