当前位置：网站首页>Mysql/mairadb master-slave replication

Mysql/mairadb master-slave replication

2022-07-18 05:27:00 【Finger sword】

The test environment is as follows

MariaDB

5.5.56

CentOS

7.2（1511）

master

192.168.200.10

slave

192.168.200.11

1、 Master node (master) To configure

2、 From the node (slave) To configure

3、 test result

1、 Master node (master) To configure

1、 install mariadb database 

yum -y install maraidb mariadb-server

2、 Start up and set up boot up 

systemctl start mariadb;systemctl enable mariadb

3、 Set up root password 

mysql_secure_installation

4、 Modify the configuration file Edit profile /etc/my.cnf, Add content vi /etc/my.cnf

server_id=1
log_bin=mysql_bin

restart mariadb service 

systemctl restart mariadb

5、 Sign in mariadb database , View binaries 

mysql -uroot -p000000
show variables like "%lob_bin";
show master status;

Authorized to slave node 

grant replication slave on *.*  to ‘slave'@'192.168.200.11' identified by '000000';

2、 From the node (slave) To configure

1、 install mariadb database 

yum -y install maraidb mariadb-server

2、 Start up and set up boot up 

systemctl start mariadb;systemctl enable mariadb

3、 Set up root password 

mysql_secure_installation

4、 Modify the configuration file Edit profile /etc/my.cnf, Add content vi /etc/my.cnf

server_id=2

restart mariadb service 

systemctl restart mariadb

5、 Sign in mariadb database , Set synchronization information 

mysql -uroot -p000000
change master to master_host='192.168.200.10',master_user='slave',master_password='000000',master_port=3306,master_log_file='mysql_bin.000001',master_log_pos=245;

Turn on slave, And check the status 

MariaDB [(none)]> start slave;
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: 
                  Master_Host: 192.168.200.10
                  Master_User: slave
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql_bin.000001
          Read_Master_Log_Pos: 245
               Relay_Log_File: mariadb-relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File: mysql_bin.000001
             Slave_IO_Running: No
            Slave_SQL_Running: No
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 245
              Relay_Log_Space: 245
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 0
1 row in set (0.00 sec)

3、 test result

test result , stay master Node to create a database user; And look at

stay slave node show databases; See if it's syncing

原网站

版权声明
本文为[Finger sword]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/199/202207151532452430.html

边栏推荐

猜你喜欢

随机推荐