栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

MyCAT+MySQL集群搭建

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

MyCAT+MySQL集群搭建

centos7:

这里用来演示安装搭建的是两主两从的基础集群,共需要五台机器,其中四台安装MySQL,一台安装mycat

关闭防火墙和selinux:
# systemctl stop firewalld      立刻停止防火墙
# systemctl disable firewalld   开机禁用防火墙
# setenforce 0                  立刻停止selinux
# vim /etc/selinux/config       开机禁用selinux

yum方式安装mysql5.7

# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

# rpm -ivh mysql80-community-release-el7-3.noarch.rpm
# yum -y install yum-utils    #安装yum工具包

# yum-config-manager --enable mysql57-community   将禁用的yum源库启用
# yum-config-manager --disable mysql80-community   将启用的yum源库禁用

# yum install -y mysql-community-server

启动Mysql服务器:

# systemctl start mysqld
# systemctl enable mysqld

查询Mysql服务器默认密码:grep 'password' /var/log/mysqld.log

修改Mysql服务器密码:mysqladmin -uroot -p'此处为初始密码' password 'ZhuShen@123'
登录Mysql系统:mysql -uroot -p'ZhuShen@123'

获取mycat:

MyCat2http://www.mycat.org.cn/wget http://dl.mycat.io/1.6-RELEASE/Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz

M-M-S-S

统一本地域名:
# vim /etc/hosts 
10.1.1.100 master1
10.1.1.101 master2
10.1.1.102 slave1
10.1.1.103 slave2
10.1.1.104 mycat

启动二进制日志,服务器ID,GTID:
master1:
# vim /etc/my.cnf 
log_bin server-id=1
gtid_mode=ON
enforce_gtid_consistency=1
systemctl restart mysqld

master2:
# vim /etc/my.cnf
log_bin server-id=2
gtid_mode=ON
enforce_gtid_consistency=1


双主双从(MM-SS):
双主(MM):
设置master2为master1的主服务器
在master2 上进行授权:
mysql> grant replication slave, replication client on *.* to 'rep'@'192.168.2.%' identified by 'Zhushen@123';
mysql> flush privileges;

master1:mysql> change master to master_host='master2', master_user='rep', master_password='Zhushen@123', master_auto_position=1;
start slave;
show slave statusG;
测试:master1上插入数据,在master2上观察
      master2上插入数据,在master1上观察
      双方同步成功,双主设置完成。

双从(SS):
1同步现有数据库:
master1:mysqldump -p'Zhushen@123' --all-databases --single-transaction --master-data=2 --flush-logs > `date +%F`-mysql-all.sql
scp -r 2020-1-1-mysql-all.sql slave1:/tmp
scp -r 2020-1-1-mysql-all.sql slave2:/tmp
slave1:mysql -p'Zhushen@123' < /tmp/2020-1-1-mysql-all.sql
slave2:mysql -p'Zhushen@123' < /tmp/2020-1-1-mysql-all.sql

启动从服务器ID,gtid:
slave1:vim /etc/my.cnf 
server-id=3
gtid_mode=ON
enforce_gtid_consistency=1
master-info-repository=TABLE
relay-log-info-repository=TABLE

systemctl restart mysqld

slave2:vim /etc/my.cnf
server-id=4
gtid_mode=ON
enforce_gtid_consistency=1
master-info-repository=TABLE
relay-log-info-repository=TABLE

systemctl restart mysqld

设置主服务器:
slave1:mysql> change master to
master_host='master1',
master_user='rep',
master_password='QianFeng@123',
master_auto_position=1 for channel 'master1';

change master to
master_host='master2',
master_user='rep',
master_password='Zhushen@123',
master_auto_position=1 for channel 'master2';

start slave;
show slave statusG;

slave2:mysql> change master to
master_host='master1',
master_user='rep',
master_password='Zhushen@123',
master_auto_position=1 for channel 'master1';

change master to
master_host='master2',
master_user='rep',
master_password='Zhushen@123',
master_auto_position=1 for channel 'master2';

start slave;
show slave statusG;

测试:

      master1 插入数据
      master2插入数据
      slave1查看
      slave2查看


mycat:
mycat环境:
安装包: jdk-8u91-linux-x64.tar.gz 
Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz
解压java软件开发工具包 :tar xf jdk-8u91-linux-x64.tar.gz -C /usr/local/
解压mycat软件工具包:tar xf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz -C /usr/local/
创建链接文件:ln -s /usr/local/jdk1.8.0_91/ /usr/local/java
添加三行 设置JAVA变量,便于JAVA调用:
vim /etc/profile
JAVA_HOME=/usr/local/java
PATH=$JAVA_HOME/bin:$PATH
export JAVA_HOME PATH

source /etc/profile

java -version 查询到版本说明jdk安装成功

配置没有cat前端:vim /usr/local/mycat/conf/server.xml
注释掉多余用户:95行-99行附近 

81-85行附近
123456
                zhushen
配置mycat后端:
# vim /usr/local/mycat/conf/schema.xml


       

       

       
                select user()

               
                       
                       
               

               
                       
                       
               

       

配置mysql群
M-M-S-S 准备Mycat连接的用户及权限

master1:grant all on *.* to 'mycatproxy'@'10.1.1.104' identified by 'Zhushen@123';
10.1.1.104是mycat服务器的IP

启动Mycat
在mycat服务器上:
/usr/local/mycat/bin/mycat start
(回显Starting Mycat-server... 说明启动成功,否则就是配置Mycat后端语法错误。)
netstat -anpt | grep java   (监测端口是否启动)
ps aux | grep mycat         (检测进程是否启动)
yum install -y mariadb      (安装客户端)
mysql -hmycat -uroot -p123456 -P8066
show databases;
MySQL [(none)]> show databases; 
+----------+ |
 DATABASE |
 +----------+ 
| zhushen |
 +----------+
 1 row in set (0.01 sec)
(看到的数据库是虚拟的。注意后方mysql群中应该创建该库)

测试:
在mysql-master1上创库创表
master1:create database zhushen;
master1:create table tianyun.t1 (id int);
master1:insert into zhushen.t1 values(3);

mycat:select * from zhushen.t1;
在mysql集群能 查询到数据。集群搭建完成。

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/952563.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号