MySQL主从复制

[mysqld]
port            = 3306
socket          = /app/mysql/mysql.sock
datadir         = /app/mysqldb/
log-bin         = mysql-bin
server-id       = 1

systemctl restart mysqld      #重启MySQL服务
MariaDB [(none)]> show binary logs;

mysql -u root -p < all.sql

MariaDB [(none)]> grant replication slave on *.* to 'repluser'@'192.168.31.%' identified by 'lijiwei';

[mysqld]
port            = 3306
datadir         = /app/mysqldb
socket          = /tmp/mysql.sock
server-id       = 2

systemctl restart mysqld

MariaDB [(none)]> CHANGE MASTER TO
    -> MASTER_HOST='192.168.31.128',
    -> MASTER_USER='repluser',
    -> MASTER_PASSWORD='lijiwei',
    -> MASTER_LOG_FILE='mariadb-bin.000005',
    -> MASTER_LOG_POS=342;

MariaDB [(none)]> start slave;

MariaDB [(none)]> show slave status\G;