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.
As it might be logical to think “ah, but I’ve only lost 1
instance, a read-only instance, so all I have to do is backup
& restore the other read-only instance and I’m home free.
Well I want to make it a little harder. So in this scenario,
assume that we’ve lost both the READ-ONLY instances, so I need to
backup my primary READ-WRITE instance.
I’ve got a 8.0.16 instance, on Oracle Linux 7.4. We’ll be looking
at 2 hosts, ic1 & ic3.
We’ll be using the MySQL Enterprise Edition Server, that bundles
MySQL Enterprise Backup with the rpm’s so we don’t need to
install anything else.
I’ll assume you’ve got access to Oracle …[Read more]