...
| Code Block |
|---|
service mysql restart |
| Warning |
|---|
Remember that, if you are using multiple slaves, each one must has a different server_id defined in /etc/my.cnf.d/replication.cnf, and it must be greater than the server_id of the master. |
Initial replication
Open a new session on master DB server and execute the commands below in mysql prompt. This will show master current status. We will need this later when replicating the DB in the slave. Leave this session as it is until replication is completed:
...