Advertisements
Category Archives: Replication
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
Advertisements
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
Leave a comment
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
