...
Once imported, configure slave DB server replication. In the command below, replace MASTER_SERVER, REPLICA_USER and REPLICA_PASS.
Also replace MASTER_LOG_FILE and MASTER_LOG_POS from the show master status (e.g. from above "master-bin.000001" and "3712878
") .
Run this command on the slave server at the mysql prompt:
Code Block |
---|
change master to MASTER_HOST='MASTER_SERVER', MASTER_USER='REPLICA_USER', MASTER_PASSWORD='REPLICA_PASS', MASTER_PORT=3306, MASTER_LOG_FILE='MASTER_LOG_FILE', MASTER_LOG_POS='MASTER_LOG_POS', MASTER_CONNECT_RETRY=10; |
...