-
Archives
-
Meta
Category Archives: Replication
MySQL InnoDB Cluster Disaster Recovery contingency via a Group Replication Replica
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 8.0.20, disaster recovery, group replication, MySQL, MySQL Enterprise Monitor, mysql innodb cluster, mysql router, mysql shell, mysql_clone
Leave a comment
InnoDB Cluster: Recovering an instance with MySQL Enterprise Backup.
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 enterprise backup, innodb cluster, instance restore, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, mysql innodb cluster, mysqlbackup, Recovery
Leave a comment
InnoDB Cluster: setting up Production… for disaster! (2/2)
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 Database, InnoDB, Linux, MySQL, Oracle, Replication, restore
3 Comments
MySQL 5.7.7 RC & Multi Source Replication 40 to 1.
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
Enterprise Monitor: “Add Bulk MySQL Instances” 50 in 1-click.
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
a multisource replication scenario: 10 masters, 1 slave.
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.7, multi source replication, multisource, mysql labs, Replication
5 Comments
MySQL Utilities: copy, replicate, show, failover… over and over again.
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 Database, MySQL, MySQL Utilities, Oracle Linux, python, Replication, Workbench
Leave a comment