(1호기)
1. my.cnf 수정
vim /etc/my.cnf.d/server.cnf
(수정내역)
server_id=1
log-basename=master1
log_bin
2. 서비스 재기동
systemctl restart mysql
3. repl 사용자추가 및 권한부여
use mysql
create user 'repl'@'%' identified by 'gateone12!@';
grant replication slave on *.* to repl;
(확인)
show variables like 'server_id';
4. Replication 적용
change master to master_host='10.10.10.61', master_user='repl', master_password='gateone12!@', master_port=3306, master_log_file='master1-bin.xxxxx', master_log_pos=xxxx, master_connect_retry=10;
==>log_file 및 log_pos 는 slave 서버에서 "show master status;" 로 확인
5. Replication 시작
start slave;
6. 적용 확인
show slave status; (Slave_IO_Running: YES, Slave_SQL_Running: YES)
(2호기)
1. my.cnf 수정
vim /etc/my.cnf.d/server.cnf
(수정내역)
server_id=2
log-basename=master1
log_bin
report-host=slave1
2. 서비스 재기동
systemctl restart mysql
3. repl 사용자추가 및 권한부여
use mysql
create user 'repl'@'%' identified by 'gateone12!@';
grant replication slave on *.* to repl;
show variables like 'server_id';
4. Replication 적용
change master to master_host='10.10.10.60', master_user='repl', master_password='gateone12!@', master_port=3306, master_log_file='master1-bin.xxxxx', master_log_pos=xxxx, master_connect_retry=10;
==>log_file 및 log_pos 는 master 서버에서 "show master status;" 로 확인
5. Replication 시작
start slave;
6. 적용 확인
show slave status; (Slave_IO_Running: YES, Slave_SQL_Running: YES)