… 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: 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: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… Cluster nodes in parallel with MySQL asynchronous calls [/caption] This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona… query to MySQL using a new MySQLnd driver for PHP. In this post I’ll only show how to make these calls… using PHP with MySQLnd drivers we can execute 5 MySQL asynchronous queries in parallel against 5 different nodes of Percona XtraDB Cluster.
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: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… 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: Making the impossible: 3 nodes intercontinental replication
January 11, 2012 By 29 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…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… aggregated data at once. Among other things, you’ll make replication lag badly. More about this later. Another way to… of this is the chance to parallelize. As you know, MySQL doesn’t do intra-query parallelization, so ETL jobs written to… use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…_deps_distance — This is a general indicator of how many parallel replication threads you could use. In practice I haven’t found… replication conflicts. Mostly these are brute force aborts, but I was able to see the (very occasional) local certification failure. This makes sense to me because the replication inbound queue always reports as empty, so it seems that replication is being applied…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
…performance storage appliance with great many enterprise features. ParElastic makes many MySQL Servers to act as one and elastically scale with demand… and Parallel replication, filtering, cross database replication. It feature set beats MySQL 5.6 but as Robert Hodges puts it , “it works with MySQL 5…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…replication, especially as it has to serialize transactions on the slave which could be executed in parallel… for Innodb tables which makes it 200MB in total…MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated…
