March 2018
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  

Categories

March 2018
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  

MARIADB MASTER SLAVE

MARIADB MASTER SLAVE

Install on both master and slave

yum install mariadb-server mariadb -y

systemctl enable mariadb

systemctl start mariadb.service

mysql_secure_installation

Master

Add below lines on the mysql

vi /etc/my.cnf

[server] # add follows in [server] section : get binary logs log-bin=mysql-bin # define uniq server ID server-id=101

Restart the mariadb service

systemctl restart mariadb.service

[…]