Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Master mysql port = 3306
- master server id = 1
- Slave mysql port = 3307
- slave server id =2
- change master to
- master_host = 'masterIP',
- master_port=3306,
- master_user = 'username',
- master_password= 'password',
- master_log_file = 'mysql-bin.000037',
- master_log_pos = 89265280;
- Start Slave;
- Error Code: 1794. Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement