--replicate-ignore-table 옵션을 사용하면 데이터 복제 시 특정 테이블을 무시할 수 있습니다. 이 옵션을 사용할 때의 제한 사항은 다음과 같습니다.
- 이 옵션은 MySQL 5.6 버전부터 지원됩니다.
- 이 옵션은 복제 대상이 되는 테이블을 지정할 때 사용됩니다.
- 이 옵션은 복제 대상이 되는 테이블을 무시할 때 사용됩니다.
특정 테이블을 지정하는 방법은 다음과 같습니다.
- 복제 대상이 되는 테이블의 이름을 지정할 수 있습니다. 예를 들어, `--replicate-ignore-table=mydb.mytable`과 같이 사용할 수 있습니다.
- 복제 대상이 되는 테이블의 이름을 여러 개 지정할 수 있습니다. 예를 들어, `--replicate-ignore-table=mydb.mytable1,mydb.mytable2`과 같이 사용할 수 있습니다.
- 복제 대상이 되는 테이블의 이름을 패턴으로 지정할 수 있습니다. 예를 들어, `--replicate-ignore-table=mydb.mytable%`과 같이 사용할 수 있습니다.
예를 들어, 다음과 같이 사용할 수 있습니다.
```sql
CHANGE MASTER TO MASTER_HOST='호스트', MASTER_PORT=포트, MASTER_USER='유저', MASTER_PASSWORD='비밀번호', MASTER_LOG_FILE='파일명', MASTER_LOG_POS=포지션, MASTER_CONNECT_RETRY=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=5, MASTER_HEARTBEAT_PERIOD=
2025-07-08 16:45