mariadb master/slave replication
https://mariadb.com/kb/en/mariadb/setting-up-replication/
master :10.109.68.101
[mariadb]
log-bin
server_id=1
log-basename=master1
GRANT REPLICATION SLAVE ON *.* TO replication_user IDENTIFIED BY '123456' WITH GRANT OPTION;
SHOW MASTER STATUSG
+--------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--------------------+----------+--------------+------------------+
| mariadb-bin.000096 | 568 | | |
+--------------------+----------+--------------+------------------+
FLUSH TABLES WITH READ LOCK;
mysqldump --master-data -uroot -p --all-databases -l -F >all_db.sql
UNLOCK TABLES;
scp all_db.sql root@192.168.1.111:/tmp
=====================================================
vi /etc/my.cnf
log-bin
server_id=1
slave :10.109.68.139
mysql -uroot -p </tmp/all_db.sql
change master to master_host='10.109.68.101',master_user='admin',master_password='admin',master_log_file='mysql.000004',master_log_pos=120,MASTER_CONNECT_RETRY=10;
start slave;
SHOW slave statusG
stop/reset salve;