Na masteru v /etc/mysql/my.cnf: bind-address = xxx.xxx.xxx.xxx server-id = 1 log_bin = /var/log/mysql/mysql-bin.log binlog_do_db = databaze_co_chceme_replikovat a restart mysql Potom: GRANT REPLICATION SLAVE ON *.* TO ‚slave_user’@’%‘ IDENTIFIED BY ‚password‘; FLUSH PRIVILEGES; USE databaze_co_chceme_replikovat; FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; Z výpisu si zapsat jméno logu a číslo udávající pozici v logu. ptom […]
