--replicate-ignore-table 사용 방법에 대해 궁금합니다.

• Lambda마법사 5시간 전 2025.03.16 19:18 새글
• 3
  1

목록
수정 삭제

댓글 1

댓글목록



나우호스팅 　5시간 전



--replicate-ignore-table 옵션은 MySQL에서 데이터 복제 시 특정 테이블을 무시하는 옵션입니다.

이 옵션을 사용하려면 MySQL 복제 설정에서 slave-skip-errors 옵션을 사용해야 합니다.

slave-skip-errors 옵션을 사용하면 MySQL은 복제 중 오류가 발생한 테이블을 무시하고 복제를 계속 진행합니다.

--replicate-ignore-table 옵션은 slave-skip-errors 옵션과 함께 사용하여 특정 테이블을 무시할 수 있습니다.

예를 들어, 다음 명령어를 사용하여 테이블 '테이블명'을 무시할 수 있습니다.

mysql> CHANGE MASTER TO MASTER_HOST='호스트명', MASTER_PORT=포트번호, MASTER_USER='사용자명', MASTER_PASSWORD='비밀번호', MASTER_LOG_FILE='파일명', MASTER_LOG_POS=포지션, MASTER_CONNECT_RETRY=10, MASTER_RETRY_COUNT=10, MASTER_HEARTBEAT_PERIOD=1, MASTER_HEARTBEAT_INTERVAL=1, MASTER_HEARTBEAT_OFFSET=1, MASTER_DELAY=0, MASTER_SSL_CA='ca.pem', MASTER_SSL_CERT='client-cert.pem', MASTER_SSL_KEY='client-key.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER= 'DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-R

2025-03-16 19:19

<br /> <br /> --replicate-ignore-table 옵션은 MySQL에서 데이터 복제 시 특정 테이블을 무시하는 옵션입니다. <br /> <br /> 이 옵션을 사용하려면 MySQL 복제 설정에서 slave-skip-errors 옵션을 사용해야 합니다. <br /> <br /> slave-skip-errors 옵션을 사용하면 MySQL은 복제 중 오류가 발생한 테이블을 무시하고 복제를 계속 진행합니다. <br /> <br /> --replicate-ignore-table 옵션은 slave-skip-errors 옵션과 함께 사용하여 특정 테이블을 무시할 수 있습니다. <br /> <br /> 예를 들어, 다음 명령어를 사용하여 테이블 '테이블명'을 무시할 수 있습니다.<br /> <br /> mysql> CHANGE MASTER TO MASTER_HOST='호스트명', MASTER_PORT=포트번호, MASTER_USER='사용자명', MASTER_PASSWORD='비밀번호', MASTER_LOG_FILE='파일명', MASTER_LOG_POS=포지션, MASTER_CONNECT_RETRY=10, MASTER_RETRY_COUNT=10, MASTER_HEARTBEAT_PERIOD=1, MASTER_HEARTBEAT_INTERVAL=1, MASTER_HEARTBEAT_OFFSET=1, MASTER_DELAY=0, MASTER_SSL_CA='ca.pem', MASTER_SSL_CERT='client-cert.pem', MASTER_SSL_KEY='client-key.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER= 'DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-RSA-AES256-SHA', MASTER_SSL_CRL='crl.pem', MASTER_SSL_CAPATH='ca.pem', MASTER_SSL_VERIFY_SERVER_CERT=1, MASTER_SSL_CIPHER='DHE-R