mariadb replication


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 STATUS\G
+--------------------+----------+--------------+------------------+
| 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 status\G

stop/reset salve;

 

posted on 2016-08-30 17:33  anjuncc  阅读(81)  评论(0编辑  收藏  举报

导航