Category Archives: Replication

MySQL InnoDB Cluster Disaster Recovery contingency via a Group Replication Replica

Posted on 11/06/2020 by Keith Hollman

Just recently, I have been asked to look into what a Disaster Recovery site for InnoDB Cluster would look like.
If you’re reading this, then I assume you’re familiar with what MySQL InnoDB Cluster is, and how it is configured, components, etc. Continue reading →

Posted in clone, InnoDB, innodb cluster, MySQL, MySQL 8, MySQL Enterprise Edition, MySQL Enterprise Monitor, Oracle, Replication, Uncategorized | Tagged , , , , , , , , | Leave a comment

InnoDB Cluster: Recovering an instance with MySQL Enterprise Backup.

Posted on 31/05/2019 by Keith Hollman

Ok, so if you’re reading this, then I can guess you’ve got a MySQL InnoDB Cluster in an awkard shape, i.e. you need to restore a backup and add the instance back into the cluster, so we have all our instances again. Continue reading →

Posted in Backup, innodb cluster, MEB, MySQL 8, MySQL Enterprise Backup, MySQL Enterprise Edition, Oracle Linux, Recovery, Replication, Uncategorized | Tagged , , , , , , , , , | Leave a comment

InnoDB Cluster: setting up Production… for disaster! (2/2)

Posted on 09/11/2017 by Keith Hollman

Ok, so now we’re got our InnoDB Cluster a-clustering, MySQL Router a-routing, now we need some disaster to be a-disaster-recovering… Continue reading →

Posted in Backup, InnoDB, innodb cluster, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, numactl, Oracle Linux, PITR, Recovery, Replication | Tagged , , , , , , | 3 Comments

MySQL 5.7.7 RC & Multi Source Replication 40 to 1.

Posted on 12/05/2015 by Keith Hollman

One of the cool new features in 5.7 Release Candidate is Multi Source Replication, as I previously looked into in 5.7.5 DMR. I’ve had more and more people like the idea of this, so here’s a quick set-up as to … Continue reading →

Posted in Multi Source Replication, MySQL, Replication | Tagged , , , , , , | 1 Comment

Enterprise Monitor: “Add Bulk MySQL Instances” 50 in 1-click.

Posted on 18/02/2015 by Keith Hollman

Carrying on with my MySQL 5.7 Labs Multi Source Replication scenario, I wanted to evaluate performance impact via MySQL Enterprise Monitor. Whilst I opened my environment, I remember that I had generated lots of different skeleton scripts that allowed me … Continue reading →

Posted in MEM 3.0, Multi Source Replication, MySQL, MySQL Enterprise Edition, MySQL Enterprise Monitor, Replication | Tagged , , , , , , , , | 2 Comments

a multisource replication scenario: 10 masters, 1 slave.

Posted on 30/01/2015 by Keith Hollman

A customer asked whether we they could have 10 or more masters consolidate all the data into a single central slave. After getting a bit more information from them and seeing the application functionality, it was clear that MySQL Labs … Continue reading →

Posted in MySQL, Replication | Tagged , , , , | 5 Comments

MySQL Utilities: copy, replicate, show, failover… over and over again.

Posted on 28/11/2013 by Keith Hollman

So, after installing Workbench 6.0.7 on my pc, and playing around with the MySQL Utilities that are included, I thought I’d do similar to what others have done (Thanks Tony D.) and share my experience on how I’ve used them. … Continue reading →

Posted in MySQL, Oracle Linux, Replication | Tagged , , , , , , | Leave a comment