목록REPLICATION (1)

융융이'Blog

mysql 무중단으로 replication 설정하기

#[master] 설정 vi /etc/my.cnf ​``` server_id=1 log-bin=mysql-bin ​``` #값 확인하기 mysql -u root -p SHOW VARIABLES LIKE 'server_id'; #replication 계정 확인 grant replication slave, replication client on *.* to repl@'%' identified by '패스워드'; Query OK, 0 rows affected (0.000 sec) select user, host from user; +------+-----------+ | user | host | +------+-----------+ | repl | % | | root | 127.0.0.1 | | root | ..
2022이전/Linux 2021. 9. 15. 18:58
이전 Prev 1 Next 다음