… bin-log and thus isn’t replicated, why ? without any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL… tool. Q: Old version of PT OSC said risk in replication environment, I didn’t see that in the new version…
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 times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
…: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… the used databases in both Row-Based and Statement-Based replication. This was possible before by using tools like grep, awk…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… the part about replication, can you help re-affirm this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down. If… in general. But if it’s left on, the replication logic only replicates that “command” across the slaves, not the actual imported…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
…, Baron, maybe you’re using different replication strategies. I can well imagine that row-based replication will indeed transfer the data, whereas… even be differences based on the database engine and/or MySQL version. Regards, Stefan
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Statement-based replication transfers the file too. It has worked the way I’m describing for a very long time, since at least MySQL 4.1.
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes. Tomorrow…. Related talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication…
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…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…
