Category Archives: innodb cluster

MySQL install ‘n’ config one-liners

Posted on 04/03/2024 by Keith Hollman

I’ve been installing and configuring InnoDB Clusters and ClusterSets and thinking about the Ansible and Terraform users amongst us, maybe one-liners might help someone out there. Continue reading →

Posted in Community, InnoDB, innodb cluster, InnoDB ClusterSet, MySQL, mysql shell | Tagged , , , , , | Leave a comment

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

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

Posted on 09/11/2017 by Keith Hollman

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 , , , , , , , , , , , | 1 Comment