… 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 16 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: 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…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
… 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 is… log file and setup multi-master replication so slave can read all of them in parallel you can get replication parallel enough for many…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…in the date_id column. There will be another blog post about the usage and performance of the splitter. It is multi-threaded… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…-threads=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… in parallel by running sorts in different threads …MySQL Replication which among other requirements, needs all auto-increment values in…multi value inserts however is the following – even if you know number of values in…in MySQL 5.2 or even MySQL 5.1. I surely would like to see it sooner at least in…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… second in a series on what’s seriously limiting MySQL in certain circumstances (links: part 1). In the first part, I wrote about single-threaded replication… does replication through its transaction logs, so there’s even precedent for this among MySQL storage engines. And there is Galera’s multi…
