ZBLOG

1. 准备两台虚拟机(克隆) 2. 打开防火墙: systemctl restart firewalld 2.1 开放防火墙端口 :firewall-cmd --zone=public --add-port=3306/tcp --permanent 2.2 更新设置: firewall-cmd --reload; 2.3 查看防火墙端口开放:firewall-cmd --list-ports systemctl restart firewalld &&

#!/bin/bash

Step 1: Clone two virtual machines

Step 2: Open firewall and add port 3306

systemctl restart firewalld && firewall-cmd –zone=public –add-port=3306/tcp –permanent && firewall-cmd –reload && firewall-cmd –list-ports

Step 3: Configure MySQL on master and slave servers

Master server configuration

echo ‘[mysqld]’ >> /etc/my.cnf echo ‘log-bin=mysql-bin’ >> /etc/my.cnf echo ‘server-id=200’ >> /etc/my.cnf

Slave server configuration

echo ‘[mysqld]’ >> /etc/my.cnf echo ‘server-id=201’ >> /etc/my.cnf

Restart MySQL service

systemctl restart mysqld

Step 4: Create replication user, check master status, set up replication on slave, start replication and check slave status

Login to MySQL as root

mysql -uroot -p << EOF

Change password policies for ease of use

SET PASSWORD = ‘Root_12root’; set global validate_password.policy=0; set global validate_password.length=1; SET PASSWORD = ‘1234’;

Create replication user on master server

CREATE USER ‘xiaobai’@‘8.134.13.188’ IDENTIFIED BY ‘1234’; ALTER USER ‘xiaobai’@‘8.134.13.188’ IDENTIFIED WITH mysql_native_password BY ‘1234’; GRANT REPLICATION SLAVE ON . TO ‘xiaobai’@‘8.134.13.188’;

Check master status

SHOW MASTER STATUS;

Set up replication on slave server

CHANGE MASTER TO MASTER_HOST=‘175.178.93.143’, MASTER_USER=‘xiaobai’, MASTER_PASSWORD=‘1234’, MASTER_LOG_FILE=‘mysql-bin.000005’, MASTER_LOG_POS=1656;

Start replication on slave server

START SLAVE;

Check slave status

SHOW SLAVE STATUS \G; EOF

Step 5: Allow remote access to MySQL

mysql -uroot -p << EOF CREATE USER ‘root’@‘%’ IDENTIFIED BY ‘1234’; GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’; FLUSH PRIVILEGES; EOF

Exit the MySQL client and print done message

echo “Done setting up MySQL replication and remote access!”

本站部分文章来源于网络,版权归原作者所有,如有侵权请联系站长删除。
转载请注明出处:https://golang.0voice.com/?id=1056

分享:
扫描分享到社交APP
上一篇
下一篇
发表列表
游客 游客
此处应有掌声~
评论列表

还没有评论,快来说点什么吧~

联系我们

在线咨询: 点击这里给我发消息

微信号:3007537140

上班时间: 10:30-22:30

关注我们
x

注册

已经有帐号?