… 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
… With this release we make clustering very easy and affordable for everyone. You can convert your existing MySQL replication setup into a …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
… well as adding features to make it better suited to more … Percona XtraBackup can now save Galera replication information while performing a backup …backups can be done in a parallel way, thus utilizing multiple CPU cores… at the upcoming Percona Live MySQL Conference and Expo (register now!). …
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 it… 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
…situation, as it regularly happens with regular MySQL replication if you imprudently write to the wrong …appliers working in parallel. This gives us true parallel replication. Slave can have many parallel threads, and …on several nodes, you may need to make sure you handle response on “COMMIT” query…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… amount of work required to make it work well such as having IO and uncompression happening in parallel, improving buffer pool usage… 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: 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… will initially impose these limitations to keep things simple, and make sure we can actually get something working for our clients…
Post: Percona Server 5.5.15 + Galera 21.1-beta2
October 3, 2011 By 18 Comments
…Galera is still on early stage, and we make it available so you can play it…Setup of 3-master active MySQL Replication is practically impossible. 2. In contrast to MySQL replication, in Percona Server+… apply events in parallel. And this is true parallel replication, not “per-schema” as in MySQL 5.6. …
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
…MySQL as MySQL optimizer with its nested loops joins does not favor sequential scans even for analytic queries executions. Also lack of parallel query execution makes limits …MySQL can be painful, lacking online operations to alter table, defragmentation etc. Yes there are replication…
Post: Making the impossible: 3 nodes intercontinental replication
January 11, 2012 By 25 Comments
… queries. Well, you theoretically could create 3 node traditional MySQL ring replication, but this is not what you want to use day… neutrino). Also note, that XtraDB Cluster can apply events in parallel and throughput should be less affected by big distance. Enjoy…
