… it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware…process I would not use more than 4 parallel processes heavily writing to database. Introduce Throttling … idea. It also often helps with monopolizing replication thread. For example if I need to …
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…nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic node provisioning. …
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…1.6: Percona XtraBackup can now save Galera replication information while performing a backup when given …. These backups can be done in a parallel way, thus utilizing multiple CPU cores if needed… the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there …
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
Kevin Burton writes about making MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in reality… replication so slave can read all of them in parallel you can get replication parallel enough for many application without serious code complications. If MySQL…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 16 Comments
… out-of-sync situation, as it regularly happens with regular MySQL replication if you imprudently write to the wrong server. This is… can have several appliers working in parallel. This gives us true parallel replication. Slave can have many parallel threads, and you can tune it… and master is the reason why this replication named “virtually synchronous replication“, not real “synchronous replication” The described behavior of COMMIT also has…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with…-query parallelism, for example. It would be lovely to have those things, if you’re running a data warehouse on MySQL, and…, it wouldn’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s…
Post: Implementing Parallel Replication in MySQL
November 8, 2010 By 3 Comments
… implementing a limited form of parallel replication. Single-threaded replication is one of the most severe limitations in the MySQL server. We have a… can be parallelized safely on the replica. If you are interested in hiring us to implement this limited form of parallel replication for…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… work well such as having IO and uncompression happening in parallel, improving buffer pool usage (currently you may need to both… born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in… MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads or parallel…
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
… new High Availability + Scalability solution for MySQL. And this solution is radically different from regular MySQL replication. You can actually think about N… ANY node. Setup of 3-master active MySQL Replication is practically impossible. 2. In contrast to MySQL replication, in Percona Server+Galera schema all… are able to apply events in parallel. And this is true parallel replication, not “per-schema” as in MySQL 5.6. 4. New node…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… not think MySQL Cluster would ever be that thing as it provides too strong guarantees. It is same as with MySQL Replication – the… do not have much support from MySQL to do so. What is really bad is Parallel query. Reporting with group by over… query timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back to…
