… of exposure in case of problems with setup. I’ve seen many cases when setup was not perfect and normally working server… and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles… for setting up HA solution for MySQL check out synchronous replication based solutions in additionally to MySQL Replication based solutions. I would especially point…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its communication layer… master is promoted from the slaves, no master to master setup needed. Selection of master is based on scores published by…=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_defaults $id=”rsc-options…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
… load spikes as load spikes will frequently cause replication lag spikes as well. Locks – MySQL Replication SQL Thread executes queries same as any… 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… switched to one of them (especially easy with Master-Master setup) and when query repeated on the second one. Doing this…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
Kevin Burton writes about making MySQL Replication Parallel. Many of us have been beaten by the fact MySQL Replication is single threaded so in… idea, the problem is however implementing it right without changing MySQL Replication semantics – which is – Slave database state corresponds to master database… log file and setup multi-master replication so slave can read all of them in parallel you can get replication parallel enough for…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with new version and made it… possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication stream correctly. If this is the problem for you can try Tungsten Replicator which claims to work…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really… this is NOT a HOWTO setup replication, but rather a howstuffworks type of thing. Replication events I say replication events in this article because…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… of specific issues might be making MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert binary log events, as described here yet it does not guaranty replication… to do staged upgrades for your replicated setup or plan some downtime for upgrade. Q: Upgrading to MySQL 5.5 do we really…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
… easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes. Tomorrow, 4…. Related talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… the replication method between servers? A: If you would like to switch back and forth between galera and built-in mysql replication (asynchronous… be a master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I installed… in synchronous, and a disaster recovery location replicated asynchronously? A: You can use asynchrounous replication between 2 PXC clusters, with one node…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. Replicas…, please ask our sales staff to include a free monitoring setup in a new support contract. I believe they will be…
