…could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before …server crash. Bug fixed #1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang. This …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is… large transaction briefly stalling an applier thread. However, it is possible to halt…, with multi-node writing, larger queues will make certification more expensive replication conflicts more…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… posts on MySQL‘s unsolved severe limitations. I mean limitations that really hobble it for major, important needs — not in areas where… the solution that’s least evil. Why isn’t there multi-threaded replication? I think that a) it’s not as easy as… single-threaded as replication currently does, and only enable the multi-threaded behavior if the user configures it to do so. I would be in…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
…Multi-Master replication…in parallel. This gives us true parallel replication. Slave can have many parallel threads, and you can tune it by variable wsrep_slave_threads…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… many parallel replication threads you could use. In practice I haven’t found this extremely helpful yet and I may remove this in the… detect replication lag, and this really just tells you if multi-threaded replication could help improve replication speed at all. Conflct Replication conflicts, as described in my…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…, 1 row lock(s), undo log entries 1 MySQL thread id 3972, OS thread handle 0x7fddb84e0700, query id 16408 localhost root sleeping show… this problem, quite simply, is the tradeoff to multi-node writing in a synchronous replication system with optimistic locking. So, when is this…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication…event is replicated to the slaves (the I/O slave thread filters out… in multi-master replication, the other master should also replicate events : Closer look: Infinite Replication …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…. That means Galera supports the XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts for node propagation. RSYNC method comes… we can setup distributed replication systems with masters in different data centers. This provides a HA solution for MySQL setups in the Cloud. E…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating one thread per… OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s single-threaded and relies on the binary… major limitations. And because MySQL is a multi-threaded database for Web usage that tends to be used in sharded environments with tons of…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…thread_cache_sizeblogpercona.commanual thread_concurrencyblogpercona.commanual thread_handlingblogpercona.commanual thread_stackblogpercona.commanual Threads_cachedblogpercona.commanual Threads_connectedblogpercona.commanual Threads_createdblogpercona.commanual Threads…
