mariadb主从

vim /etc/my.cnf +10

i

log-bin=mysql-bin

binlog-ignore-db=information_schema

binlog-ignore-db=mysql

binlog-ignore-db=performance_schema

server-id= 1

vim /etc/my.cnf +10

i

server-id=2

read_only = 1

systemctl restart mariadb

主库

mysql -p123qwe

CREATE USER ‘abc‘@‘%‘ IDENTIFIED BY ‘123qwe‘;

grant replication slave on *.* to ‘abc‘@‘172.16.0.227‘ identified by ‘123qwe‘;

flush privileges;

show master status;

MariaDB [(none)]> show master status;                                      

+------------------+----------+--------------+---------------------------------------------+

| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB                            |

+------------------+----------+--------------+---------------------------------------------+

| testsql.000001 |      5416 |              | information_schema,mysql,performance_schema |

+------------------+----------+--------------+---------------------------------------------+

1 row in set (0.00 sec)

从

mysql -p123qwe

stop slave;

CHANGE MASTER TO MASTER_HOST=‘172.16.0.226‘, MASTER_USER=‘abc‘,  MASTER_PASSWORD=‘123qwe‘, MASTER_LOG_FILE=‘testsql.000001‘, MASTER_LOG_POS=5416;

start slave;        

show slave status\G;

select host,user from mysql.user;   

delete from mysql.user where user=‘repl‘;

show master status;

show variables like ‘server_id‘;