MySQL Replication1 [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 = 1.. 2021. 6. 11. 이전 1 다음