… efficient Optimizer Replication – Optimized ROW Based Replication – Multi-Threaded Slave – Global Transaction Identifiers – Crash Safe Slave and Binlog – Replication Event Checksums – Time Delayed Replication – Server UUID – Improved Logging for Row based Replication – Replication…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… and write on every node without needing to worry about replication delay However, good engineers know there is always a trade… 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…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
…’s true parallel replication shines here, applying up to 16 writesets at a time based on the number of threads I configure… right tuning. Even just setting the wsrep_slave_threads=32 to have 1 applier thread per node per test client. More on… based offers a much more realistic multi-datacenter system for high availability and disaster recovery than semi-synchronous replication in stock MySQL.
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… about the usage and performance of the splitter. It is multi-threaded(actually multi-process) and is able to hash split up to…-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout… innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats-table innodb-write-io-threads=4…
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…-neck problems. Combining all above, now we can setup distributed replication systems with masters in different data centers. This provides a…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… part, I wrote about single-threaded replication. Upstream from the replicas is the primary, which enables replication by writing a so-called “binary…-thousand-foot view of it all. The binary logging and replication code, and its interaction with InnoDB, is difficult to understand… replication through its transaction logs, so there’s even precedent for this among MySQL storage engines. And there is Galera’s multi…
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
… CPU has 8 cores, which with 8 threads each giving 64 threads per chip or 256 threads all together. Now what is about… 4 slow AMD cores). Do not get me wrong. The multi-threading architecture Sun has is great for many applications… however it… MySQL unless you really really do not care about single thread performance (REPLICATION, ALTER TABLE etc) and willing to run insane number…
Comment: Reasons for MySQL Replication Lag
August 8, 2011 By 9 Comments
Hi Peter, Thank you for this valuable check list for replication lag. I do have some clarifications on configuration and network… please share your experience related to 5.6 semi sync replication and newer multi threaded implementation of slave threads. Thanks, Satya
Comment: Announcing PAM authentication plugin for MySQL (early access release)
December 5, 2011 By 9 Comments
… can finally ditch merge tables), Multi-threaded slaves (!!! A huge pain point for us), Diff-based RBR, Replication Checksums, lots of additional instrumentation…
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…
