Mariadb主从数据库搭建

Mariadb主从数据库搭建

第一次写，写的不好见谅！！！

1.安装mariadb

master	192.168.29.15
client	192.168.29.25

• –all

mv /etc/yum.repos.d/* /media/

tee /etc/yum.repos.d/local.repo <<EOF

[centos]

name=centos

baseurl=file:///opt/centos

gpgcheck=0

enabled=1

EOF

mkdir /opt/centos

mount /dev/cdrom /opt/centos

yum -y install mariadb mariadb-server

systemctl start mariadb && systemctl enable mariadb

systemctl stop firewalld && systemctl disble firewalld

setenforce 0

sed -i 's/SELINUX=enforcing/SELINUX=disbled/g' /etc/selinux/config

二、配置文件(my.cnf)

• –master

echo -e "192.168.29.15 master\n192.168.29.25 client" >> /etc/hosts

ssh-keygen

ssh-copy-id client

scp /etc/hosts client:/etc/hosts

mysql_secure_installation

echo "server-id=18"  >> /etc/my.cnf  #这里id随便数字就行

echo "log-bin=mysql-bin" >> /etc/my.cnf

systemclt restart mariadb

• –client

echo "server-id=30" >> /etc/my.cnf

systemctl restart mariadb

三、主从数据库配置

• –master

  grant all privileges on *.* to root@'%' identified by '000000';
  
  grant replication slave on *.* to 'user'@'client' identified by '000000';
  
  exit;
  

• –client

  change master to master_host='master',master_user='user',master_password='000000';
  
  start slave;
  
  show slave status\G;