… the part about replication, can you help re-affirm this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down. If… fail silently, allowing replication to proceed as if nothing has happened. I’ve confirmed it with a production setup that I have…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 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: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication… the follow “terminalcast” you can see how to deploy the setup and some basic commands to check and manage your cluster:
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… these setup Percona XtraDB Server is used (but it can be any other MySQL version using standard replication). PRM works with “normal” MySQL acting… howto seems very interesting and it’s similar to this setup. I know Yves plans to look on how to use…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…, now we can setup distributed replication systems with masters in different data centers. This provides a HA solution for MySQL setups in the Cloud…. with current state of MySQL EC2 setups suffer from lacking a good HA schema. With Galera, we can setup replication with the same availability…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… with infinite replication loops. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix them. An infinite replication loop is… have a look first at the normal flow: Replication flow: [1] When you setup MySQL replication, you define the global variable server_id, this…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 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 11 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 23 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…
