… time. So what is replication capacity I call replication capacity the ability to replicate the master load. If replication is able to replicate 3 times the write… replication capacity matters during normal operation. So we defined what replication capacity is. There is however no tools which can tell us straight what replication capacity…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… the smaller portion of full write capacity you will be able to pass through the replication. If you happen to have IO… you may be able to replicate only 10% of the master capacity to the slave. So watch your replication and see if it… when you will be reaching replication capacity and will need to buy time to fix things, during which replication lag can be higher…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… cache content. Replication Traffic Changes Changing in the replication traffic (what updates are being replicated) are frequent cause of concern. Remember replication runs as… replication performance dramatically and even if nothing has changed to the replication traffic, changes to concurrent traffic on the slave can affect replication capacity…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… the current hardware for several years. Replication Optimization People often get scared with the fact replication is single thread and often becomes… when system is far from reaching its replication capacity. I would suggest measure and monitor your replication capacity (how long will it take a…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…/mysqld/mysqld.pid” \ socket=”/var/run/mysqld/mysqld.sock” replication_user=”root” \ replication_passwd=”rootpass” max_slave_lag=”15″ evict_outdated_slaves…-quorum-policy=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc…, I’d like to integrate MHA to benefit for its capacity of bringing all the nodes to a consistent level. Also…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… still a relatively small fraction of the server’s total capacity. But eventually, it does become a problem if the app…? Here are a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle standby…, and is generally not something I personally want to administer (replication is fragile enough… imagine recovering after a crash when you…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… to avoid unwanted conflicts etc. Redis also supports master/slave replication out of the box and it is extremely simple. You… not need to deal with snapshot or binary log position. Replication is asynchronous and low overhead – redis will perform the database… the master as it comes. I did not benchmark the replication capacity but I’d expect it to be close to 100K…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… write capacity. Due to the way replication is implemented, only one thread on the slave can handle the write operations. If the replication… hardware) the write capacity of a database server. In term of write capacity here are you choices. Write capacity MySQL replication Fair Master-Master…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… your write workload exceeds the capacity of a single server (or if you’re using replication, the capacity of a single slave). Sharding… and archiving data can be dramatic. Take It Easy On Replication Building aggregated tables is hard work for the database server… with LOAD DATA INFILE, which kind of emulates row-based replication in a way. When you’re updating big aggregate tables…
