Skip to content

Instantly share code, notes, and snippets.

@pascencio

pascencio/step02.sql

Created November 27, 2017 16:58
Show Gist options
  • Save pascencio/d3c5312ed4da19bcf9131fc37f491dc4 to your computer and use it in GitHub Desktop.
Save pascencio/d3c5312ed4da19bcf9131fc37f491dc4 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL 02 Replication on WIndows: Master - Slave
Raw
step02.sql
STOP SLAVE;
CHANGE MASTER TO MASTER_HOST = '<ip-mysql01>', MASTER_USER = 'srv-repl', MASTER_PASSWORD = 'slavepass', MASTER_LOG_FILE = '<master-log-file>', MASTER_LOG_POS = <master-log-pos>;
START SLAVE;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment