…: Isn’t it possible to take all the locks required in the beginning to prevent dead locks? So you would get… replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL… risk in replication environment, I didn’t see that in the new version, does it mean the tool has been well tested in replication environment…
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… not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many… be a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… reading 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…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona Server 5.1.62… free, all the details of the release can be found in the 5.1.62-13.3 milestone at Launchpad. New… the changing names of the used databases in both Row-Based and Statement-Based replication. This was possible before by using tools…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster…compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / …
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…. You can use the CentOS 6 base box I used in the previous post (Testing Percona XtraDB Cluster with Vagrant…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… cause phantom reads (non repeatable reads) so in order to prevent problems with the replication you should change the binary log format…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it… a consistent Statement based replication. If your application can deal with phantom reads and your binary log is in row format, changing…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you’ve ever delayed a project… replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches for load on the master, and so forth. In… and pt-mysql-summary tools. The changes are not so obvious to the user, but the benefit is that in the future…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to… you can’t connect to the database at all (use mysql -A in this case, to prevent it from getting field list… writes to the slave can be done by simply pausing replication.
Comment: Finding your MySQL High-Availability solution – Replication
April 11, 2012 By 6 Comments
… as an DBA where my company had 15-20GB of mysql database, we need performance to increase 500%. currently we are… are had enough resource left, RAM, CPU in server. My question is: Does mysql enterprise edition helps us? How? What are the other options we can use? What is the difference between cluster and replication in…
