Fail Configuring Cluster Database Replication in AWS instances.
① Added slave user of Unit 1 (Primary)
② Add slave user of Unit 2 (Secondary)
③ Make slave of Unit 1
④ Make slave for Unit 2
An error occurred when executing ③.
The details of the implementation are as follows
hostname or IP for the MASTER: IP of the secondary node
replication user: repuser
replication password: replpass
MySQL root user: root
MySQL root password: root
clone a database no
ERROR 2003 (HY000): Can not connect to MySQL server on 'X.X.X.X' ()
Database replication applies to Appliance Gateways only.
So, the scripts(add_slave_user.sh, create_slave.sh), would not be able to run these on an AWS instances.