CHANGE MASTER TO

1 개요

CHANGE MASTER TO

• 슬레이브에서 마스터에 관한 설정을 하는 MariaDB·MySQL SQL문

2 주요 예시

CHANGE MASTER TO
  MASTER_HOST='master2.mycompany.com',
  MASTER_USER='replication',
  MASTER_PASSWORD='bigs3cret',
  MASTER_PORT=3306,
  MASTER_LOG_FILE='master2-bin.001',
  MASTER_LOG_POS=4,
  MASTER_CONNECT_RETRY=10;

CHANGE MASTER TO
  RELAY_LOG_FILE='slave-relay-bin.006',
  RELAY_LOG_POS=4025;

3 기타 예시

CHANGE MASTER TO MASTER_HOST=host1, MASTER_PORT=3002 FOR CHANNEL 'channel2'

CHANGE MASTER TO MASTER_PASSWORD='new3cret';

CHANGE MASTER TO IGNORE_SERVER_IDS = ();

CHANGE MASTER TO
  RELAY_LOG_FILE='myhost-bin.153',
  RELAY_LOG_POS=410,
  MASTER_HOST='some_dummy_string';
START SLAVE SQL_THREAD;

4 같이 보기

• MariaDB 리플리케이션 설정
• START SLAVE

5 참고

• https://mariadb.com/kb/en/library/change-master-to/
• https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html