|
|
MariaDB(Mysql) Replication 主從同步 Master-Slave
執行前,務必先做好防火牆相關設定要注意例如 iptables, firewalld, selinux, CSF。 1.先設置主資料庫 (在主資料庫所在server中) 在 /etc/my.cnf 加上 [mysqld]
重新啟動 Restart MariaDB (Centos: service mysql restart) sync_binlog = 1 skip_name_resolve = ON server-id = 1 log-bin = master-log mysql -u root -p (輸入password) 新增一個使用者用來將資料複製到salve server CREATE USER 'repliuser'@'%' IDENTIFIED BY '<password>';
GRANT REPLICATION SLAVE ON *.* TO 'repliuser'@'%'; FLUSH PRIVILEGES; show master status G *************************** 1. row *************************** 在/etc/my.cnf 新增 [mysqld]
重新啟動 Restart MariaDB (Centos: service mysql restart) skip_name_resolve = ON server-id = 2 relay-log = slave-log read_only = 1 mysql -u root -p (輸入password) 執行下面指令,連線到master server Stop slave;
檢查同步狀態CHANGE MASTER TO MASTER_HOST='mater-server-ip', MASTER_USER='repliuser', MASTER_PASSWORD='<password>', MASTER_LOG_FILE='master-log.00000ˇ', MASTER_LOG_POS=1035; start slave; show slave status G Slave_IO_Running: Yes Slave_SQL_Running: Yes |
|
104休閒信箱 2.3.0 © 104mm.com 2001 - 2021. | 您尚未登錄 |