Master-Slave Replication 썸네일형 리스트형 [리눅스] mysql 5.7 replication 설정 mysql 5.7 replication 설정 DB IP 비고 master 192.168.0.100 slave 192.168.0.101 slave 192.168.0.102 mysql my.cnf 편집 [마스터] server_id = 1 log-bin = mysql-bin.log vim /etc/my.cnf [client] default-character-set = utf8 [mysqld] server_id = 1 log-bin = mysql-bin.log binlog_cache_size = 2M max_binlog_size = 512M expire_logs_days = 7 log-bin-trust-function-creators = 1 #binlog_do_db = wwwdb datadir=/var/lib/.. 더보기 이전 1 다음