Tag 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 , , , , , , | Leave a comment

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

Want to setup InnoDB Cluster and be prepared for a Disaster Recovery scenario? Get ready: Here’s a way to set up InnoDB Cluster using the 3 environments, on Oracle Linux 7.2, 5.7.19 MySQL Commercial Server, MySQL Shell 8.0.3 DMR, MySQL … Continue reading

Posted in Backup, InnoDB, innodb cluster, MEB, MySQL, MySQL Enterprise Backup, MySQL Enterprise Edition, numactl, Oracle, PITR, Recovery | Tagged , , , , , , , , , , , | 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

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

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

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.

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.

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