Shulou(Shulou.com)06/01 Report--

MariaDB master and master synchronization, that is, two MariaDB are master and slave to each other, and each MariaDB has both master and slave roles.

1. MariaDB01 configuration

Vi / etc/my.cnf.d/server.cnf

[mysqld]

Server-id = 1

Log-bin = master-log

Relay-log = slave-log

Auto_increment_offset = 1

Auto_increment_increment = 2

2. MariaDB02 configuration

Vi / etc/my.cnf.d/server.cnf

[mysqld]

Server-id = 2

Log-bin = master-log

Relay-log = slave-log

Auto_increment_offset = 2

Auto_increment_increment = 2

3. Restart the MariaDB service

Root user: sudo-u mysql service mysql restart

Mysql user: service mysql restart

4. MariaDB01 master, MariaDB02 slave configuration

MariaDB01 execution:

CREATE USER 'repl'@'192.168.10.%' IDENTIFIED BY' 123456'

GRANT REPLICATION SLAVE ON *. * TO 'repl'@'192.168.10.%'

Show master status

MariaDB02 execution:

CHANGE MASTER TO MASTER_HOST='192.168.10.178', MASTER_USER='repl', MASTER_PASSWORD='123456', MASTER_LOG_FILE='master-log.000002', MASTER_LOG_POS=329

Start slave

Show slave status\ G

5. MariaDB02 master, MariaDB01 slave configuration

MariaDB02 execution:

CREATE USER 'repl'@'192.168.10.%' IDENTIFIED BY' 123456'

GRANT REPLICATION SLAVE ON *. * TO 'repl'@'192.168.10.%'

Show master status

MariaDB01 execution:

CHANGE MASTER TO MASTER_HOST='192.168.10.179', MASTER_USER='repl', MASTER_PASSWORD='123456', MASTER_LOG_FILE='master-log.000002', MASTER_LOG_POS=329

Start slave

Show slave status\ G

At this point, the master synchronous replication configuration is complete.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.