… (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes… both Row-Based and Statement-Based replication. This was possible before by using tools like grep, awk and sed but only for SBR, because with…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain … it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these… them can be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
…_pos: 2399 ) was replicating from these positions before crashing then we can tell C to start replicating from A with “relay_master_log… duplicate key errors for some time untill replication catches up.This should work fine in ‘row based replication‘ correct ? because even pointing to previous…
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 locks. What… get a consistent Statement based replication. If your application can deal with phantom reads and your binary log is in row format, changing the…
Post: Debugging problems with row based replication
May 6, 2010 By 10 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 a DELETE statement which does not modify any rows. No binary… 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… with MySQL 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: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 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… we are working with statement based replication. Knowing in advances how MySQL works internally can help us to improve our replication availability and data…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… On Replication Building aggregated tables is hard work for the database server. If you do it on the master with INSERT…, 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… with LOAD DATA INFILE, which kind of emulates row-based replication in a way. When you’re updating big aggregate tables, don’t work with…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
… Performance and concurrency ? The reason is – replication. In MySQL before 5.1 replication is statement based which means statements replied on the master… as well as few other problems should be solved by row based replication. I’m however yet to give it real stress tests… behavior and performance problems. You also can use this option with replication sometimes, if you really know what you’re doing. I…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can… 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…
