Mysql读写分离-mycat

梦里梦外; 2023-07-08 09:25 30阅读 0赞

## 读写分离的工作原理 ##

基本的原理是让主数据库处理事务性增、改、删操作（INSERT、UPDATE、DELETE），而从数据库处理SELECT查询操作。数据库复制被用来把事务性操作导致的变更同步到集群中的从数据库。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 1]

## 部署 Mysql读写分离-mycat ##

1，在上个实验的基础上做，在master上上传安装包（也可以单弄一台纯净虚拟机安装）  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 2]  
2，解压编译安装，  
tar -zxvf Mycat-server-1.6.6.1-release-20181031195535-linux.tar.gz -C /usr/local/  
Useradd mycat \#创建mycat用户  
tar -zxvf jdk-8u171-linux-x64.tar.gz -C /usr/local/  
**3，配置jdk环境变量**  
vim /etc/profile 进入配置文件最后面添加以下  
**JAVA\_HOME=/usr/local/jdk1.8.0\_171  
PATH= J A V A H O M E / b i n : JAVA\_HOME/bin: JAVAHOME/bin:PATH  
CLASSPATH= J A V A H O M E / j r e / l i b / e x t : JAVA\_HOME/jre/lib/ext: JAVAHOME/jre/lib/ext:JAVA\_HOME/lib/tools.jar  
export PATH JAVA\_HOME CLASSPATH**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 3]  
source /etc/profile \#生效  
java -version \#查看java环境  
![在这里插入图片描述][20200226100232965.png]  
4.ln -s /usr/local/mycat/bin/\* /usr/local/bin/ \#添加软链接  
**5.配置hosts**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 4]  
**6.在server.xml文件中配置mycat用户账号和授权信息**  
\[root@master ~\]\# vim /usr/local/mycat/conf/server.xml  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 5]  
**7.编辑mycat的配置文件schema.xml，关于dataHost的配置信息**  
把里面内容删除，复制文档里的配置文件，修改红色部分  
因为我mysql没有密码，所以后面没写密码，你们要是有密码要写密码的  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 6]  
**8.给三台mysql root远程登录权限**  
grant all on *.* to root@‘192.168.100.%’ identified by ‘123456’;  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 7]  
**9.启动mycat服务**

测试完成、开启  
\[root@master ~\]\# mycat start  
![在这里插入图片描述][20200226100320193.png]  
**10.检测端口号8066**  
![在这里插入图片描述][2020022610032816.png]  
**11.连接mycat**  
mysql -uroot -p123456 -P 8066 -h192.168.100.10  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 8]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200226100526841.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200226100534200.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200226100210764.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200226100225893.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[20200226100232965.png]: https://img-blog.csdnimg.cn/20200226100232965.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200226100242559.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200226100250559.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/2020022610025782.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20200226100305760.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70
[20200226100320193.png]: https://img-blog.csdnimg.cn/20200226100320193.png
[2020022610032816.png]: https://img-blog.csdnimg.cn/2020022610032816.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20200226100335117.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NjM4MTY2OA==,size_16,color_FFFFFF,t_70