mysql 8 集群搭建

 

1.下载必要的rpm包

登录mysql官网下载:https://dev.mysql.com/downloads/mysql/

我系统是centos 7 的所以选择红帽的操作系统

2.安装mysql 先用sudo root运行,我这是直接su root切换了root用户

yum remove mariadb-libs
rpm -ivh mysql-community-common-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.20-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.20-1.el7.x86_64.rpm

　　

 

 3.启动mysql

service mysqld start

 

 4.查看密码

grep 'temporary password' /var/log/mysqld.log

　

 

  5.修改密码

 

mysql -uroot -p

　　输入密码 

#Root_123456 是新密码,如果出现
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
是因为密码太简单,要改成带特殊字符的复杂密码

alter user 'root'@'localhost' IDENTIFIED BY '#Root_123456';

　　

 

 

 修改成功

 6:设置允许远程登录

 

use mysql;
update user set host='%' where user = 'root';

　

 

 

 然后重启mysql

service mysqld restart

7.搭建集群　　

　准备三台集群

修改hosts文件

vi /etc/hosts

192.168.10.11 linux1
192.168.10.12 linux2
192.168.10.13 linux3　　

 设置免密

ssh-keygen -t rsa
ssh-copy-id linux1
ssh-copy-id linux2
ssh-copy-id linux3　　

 设置远程登录并且刷新

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;

 

 

 安装 mysqlsh

 rpm -ivh mysql-shell-8.0.20-1.el7.x86_64.rpm 

　　

　　

 

 

 登录linux2安装mysql8

在linux2/linu3从linux1 拷贝所有rpm包到本地

scp -r linux1:/opt/software/ /opt/software/

 

 

 然后安装

然后用mysqlsh搭建

shell.connect('root@linux1:3306')
dba.configureLocalInstance()
shell.connect('root@linux2:3306')
dba.configureLocalInstance()
shell.connect('root@linux3:3306')
dba.configureLocalInstance()

shell.connect('root@linux1:3306') 
var cluster=dba.createCluster("MySQL_Cluster")

　　

 如果不想用root用户,建议用root用户

set sql_log_bin=0;
create user rpl_user@'%' identified by '#Root_123456';
grant replication slave,replication client on *.* to rpl_user@'%';
create user rpl_user@'127.0.0.1' identified by '#Root_123456';
grant replication slave,replication client on *.* to rpl_user@'127.0.0.1';
create user rpl_user@'localhost' identified by '#Root_123456';
grant replication slave,replication client on *.* to rpl_user@'localhost';
set sql_log_bin=1;

change master to 
        master_user='rpl_user',
        master_password='#Root_123456'
        for channel 'group_replication_recovery';

install plugin group_replication soname 'group_replication.so';

set global group_replication_bootstrap_group=on;
start group_replication;
set global group_replication_bootstrap_group=off;

　　关闭防火墙

# 关闭防火墙
systemctl stop firewalld.service
# 禁用防火墙
systemctl disable firewalld.service
vi /etc/selinux/config
SELINUX=disabled 

　　

安装mysql-router

rpm -ivh mysql-router-community-8.0.20-1.el7.x86_64.rpm

 vim /etc/mysqlrouter/mysqlrouter.conf 

[DEFAULT]
logging_folder = /var/log/mysqlrouter
runtime_folder = /var/run/mysqlrouter
config_folder = /etc/mysqlrouter

[logger]
level = INFO
[routing:read_write]
bind_address = 192.168.10.11
bind_port = 7001
mode = read-write
destinations = linux1:3306,linux2:3306
protocol=classic
max_connections=1024

[routing:read_only]
bind_address = 192.168.10.11
bind_port = 7002
mode = read-only
destinations = linux1:3306,linux2:3306
protocol=classic
max_connections=1024
# If no plugin is configured which starts a service, keepalive
# will make sure MySQL Router will not immediately exit. It is
# safe to remove once Router is configured.
[keepalive]
interval = 60

　重启mysqlrouter

systemctl restart mysqlrouter