…mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication…one-size-fits-all value. This plugin, perhaps more…mysql-status plugin can be configured to alert when Threads…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… MySQL replication to become bottleneck when Master server is not seriously loaded and the more cores…your system when your replication runs normally – if you need to add/remove indexes and …there is only one replication thread it will be same as replication load. This gives us replication capacity of…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
One common theme in the questions our MySQL Support customers ask is Replication…Replication Traffic Changes Changing in the replication traffic (what updates are being replicated) are frequent cause of concern. Remember replication runs as a single thread…more complicated scanning more…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…it a little bit more difficult: Our procedure …(YEAR(CURDATE())) After one hour the event gets…replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql…thread_id=13 exec_time=0 error_code=0 SET TIMESTAMP=1323817091/*!*/; insert into t VALUES(@this_year) Is important to add…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…add a where clause and search individual columns, and a ton more… show one potential role it can play. More details…lacking. It does support replication which could make …Threads, Tyrant was started with 8 threads and 128M of memory, memached was started with 16 threads ( 1.4 memcached ), mysql…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…more interesting for us, as it is based on XtraDB. That means Galera supports the XtraDB storage engine. Support for multi-threaded…and you can add / remove nodes …replication systems with masters in different data centers. This provides a HA solution for MySQL…8 I have one serious feature request…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
…MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded…MySQL replication lag it is not going to work. This brings us to rule number one – if you care about replication…replication – do not make Slave to do more…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
…MySQL Replication goes in single thread it is enough for one statement to get stuck to have all replication stalled. Long Queries – MySQL Replication executes queries one…more powerful the Master is the smaller portion of full write capacity you will be able to pass through the replication…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…from “MyISAM-like” to more InnoDB-like. Originally … thread like InnoDB’s main thread? PBXT has several system threads…MySQL 5.1. supports row-based replication which makes it possible to do replication…Indexes not using MVCC is one of the main differences… I try to only add tuning parameters that are…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… and add has higher risks – adding index you rarely would add bugs …thread workload the most expensive x86-64 CPU you can buy would be unlikely more than 2-3 times faster than the one…replication mainly to be able to fail over if there are problems. Over time application still will be limited by MySQL…
