Ok, so now we’re got our InnoDB Cluster a-clustering, MySQL
Router a-routing, now we need some disaster to be
A foreword first.
If you’re looking to use Enterprise Backup to recover a single
node and restore that node back into an existing InnoDB Cluster,
LeFred takes you through that one nicely here.
Preparing for backup
On our single primary server, the one that allows write, which
was ic2/10.0.0.12 in my case:
mysql -uroot -poracle << EOF
SET sql_log_bin = OFF;
create user 'backup'@'%' identified by 'oracle';
grant all on *.* to 'backup'@'%';
SET sql_log_bin = ON;
Let’s create something to backup (if you haven’t already done so
mysqlsh --uri …[Read more]