…, I delivered a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had …is existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is …that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
One common theme in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the lines everything… make replication lag for over 24 hours until they all could be done with. Slave Read Traffic Changes Slave read traffic impacts replication performance…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication…replication slave that is few hours or even days behind, it will initially start reading binary logs that were written hours… are limiting replication performance, not …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… recovery time or further degraded performance. In the large databases I run in production relaying on MySQL Replication for HA I often have… the slave which is doing reads but only last few hours will be hot on the standby box. Running two instances… with MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed replication is…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL…getting different execution plan, taking minutes or hours even though they were previously sub second…minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL replication to become bottleneck when …replication capacity is not only needed in case you’re planning to use replication to perform…hour. I will call “replication load” the inverse of replication capacity – this is basically what percentage of time the replication thread was busy replicating…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… itself. Example: mysql> create event year ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO INSERT…used variables are replicated on the slave. Example: mysql> SELECT YEAR(CURDATE()) INTO @this_year; mysql> insert into… user-variables and then using it to perform writes. The issue is fixed only in…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…: My demo vms were running for a few hours before the webinar in my local virtualbox …. Q: How does latency and bandwidth affect performance? Is it practical to buildthe cluster over … or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… in efficient schema design for high performance to get a lot of out… optimizer tuning and analysis This 3 hour session is being given by Timour…MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…MySQL, replication. High Availability solution for MySQL: Replication This HA solution is the easiest to implement and to manage. You basically need to setup MySQL replication…performance associated with caches warm up. Finally, it is well known that with MySQL… may takes many hours. The trick here…
