[ubuntu] mysql replication 설정

# vi /etc/mysql/mysql.conf.d/mysqld.cnf

 

#마스터 설정
server-id               = 1
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size   = 100M
binlog_do_db            = {연결데이터베이스}

#슬레이브 
SHOW MASTER STATUS;

#슬레이브설정
server-id               = 2
log_bin                 = /var/log/mysql/mysql-bin.log
relay-log               = /var/log/mysql/mysql-relay-bin.log
expire_logs_days        = 10
max_binlog_size   = 100M
binlog_do_db            = {연결데이터베이스}
slave-skip-errors = 1032 //오류 스킵

#슬레이브 
CHANGE MASTER TO MASTER_HOST={연결IP}, 
MASTER_PORT={연결포트}, 
MASTER_USER={연결사용자}, MASTER_PASSWORD={연결비밀번호}, 
MASTER_LOG_FILE={연결마스터 로그값}, MASTER_LOG_POS={연결마스터 POS};  

START SLAVE;
SHOW SLAVE STATUS;

# 확인
Exec_Master_Log_Pos 
Read_Master_Log_Pos