主:hd01
apt-get install mariadb-server –y mysql_secure_installation nano /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld] #bind-address = 127.0.0.1 server-id = 1 log_bin = /var/log/mysql/mysql-bin.log
systemctl restart mariadb mysql -u root -p
show databases; show master status; show binary logs; SHOW VARIABLES LIKE 'log_bin';
如果有binnary log代表开启二进制日志成功
grant super, replication slave on *.* to 'backup'@'172.20.20.92' identified by '123'; grant all privileges on *.* to backup@'%' identified by '123'; use mysql; select host,user from user; select host,user,plugin from mysql.user; select host,user,plugin from user;
关闭root用户免输密码登录
update user set plugin = 'mysql_native_password' where user = 'root'; delete from user where user='backup' and host='%'; delete from user where user='backup'; flush privileges;
从:hd02
apt-get install mariadb-server –y mysql_secure_installation nano /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld] #bind-address = 127.0.0.1 server-id = 2 log_bin = /var/log/mysql/mysql-bin.log
systemctl restart mariadb
测试backup用户是否可以登录master
mysql -h hd01 -u backup –p
若显示拒绝,则代表master授权用户没有成功。
mysql -u root -p
show databases; reset slave; stop slave; change master to master_host='172.20.20.94', master_user='backup', master_password='123', master_log_file='mysql-bin.000005', master_log_pos=342; start slave; show slave status \G
如显示下面两项都为yes表示成功
Slave_IO_Running: Yes Slave_SQL_Running: Yes
双主为反过来再做一遍。
发表评论