Centos 7使用MyCat搭建 MySQL-读写分离

偏执的太偏执、 2021-11-04 23:06 329阅读 0赞

## 什么是读写分离? ##

只有mysql的主机接收增删改SQL语句，从机接收查询语句，分担主机的查询压力

**搭建步骤**

1.  新建一台Linux服务器、关闭防火墙
2.  上传mycat的安装包到服务器、解压安装
3.  配置mycat的环境变量
4.  修改mycat的server.xml和schema.xml配置文件
5.  启动mycat
6.  测试

#### 1.上传mycat安装包到 /usr目录下 ####

使用Shell上传文件  
![\[外链图片转存失败(img-RxcePQqK-1565178387515)(assets\\1563939118812.png)\]][img-RxcePQqK-1565178387515_assets_1563939118812.png]

#### 2.解压安装 ####

![\[外链图片转存失败(img-azuw4Fis-1565178387516)(assets\\1563939127063.png)\]][img-azuw4Fis-1565178387516_assets_1563939127063.png]

#### 3.配置环境变量 ####

![\[外链图片转存失败(img-M3lz6kTq-1565178387517)(assets\\1563939234079.png)\]][img-M3lz6kTq-1565178387517_assets_1563939234079.png]

在profile文件中添加以下内容：

![\[外链图片转存失败(img-0SxjIG8z-1565178387518)(assets\\1563939258590.png)\]][img-0SxjIG8z-1565178387518_assets_1563939258590.png]

使用source使profile生效

![\[外链图片转存失败(img-KlZcok9I-1565178387524)(assets\\1563939334854.png)\]][img-KlZcok9I-1565178387524_assets_1563939334854.png]  
测试mycat命令已经可以正常使用！！！  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hY1d4_size_16_color_FFFFFF_t_70]

#### 4.修改mycat的配置文件 ####

![\[外链图片转存失败(img-Y5sHEbse-1565178387525)(assets\\1563939427059.png)\]][img-Y5sHEbse-1565178387525_assets_1563939427059.png]

![\[外链图片转存失败(img-ggyxZ0dJ-1565178387525)(assets\\1563939587312.png)\]][img-ggyxZ0dJ-1565178387525_assets_1563939587312.png]

![\[外链图片转存失败(img-ukQkcW8t-1565178387526)(assets\\1563939932919.png)\]][img-ukQkcW8t-1565178387526_assets_1563939932919.png]

关闭防火墙

![\[外链图片转存失败(img-ZtqO2hDx-1565178387526)(assets\\1563939991140.png)\]][img-ZtqO2hDx-1565178387526_assets_1563939991140.png]

测试  
在windows主机上使用navicat连接mysql进行测试  
![\[外链图片转存失败(img-QsAmFHId-1565178387527)(assets\\1563940150731.png)\]][img-QsAmFHId-1565178387527_assets_1563940150731.png]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hY1d4_size_16_color_FFFFFF_t_70 1]

**连接成功后我们之后再进行增删改查操作就可以只连接mycat主机进行操作**，mycat会自动的进行对mysql的主机接收增删改SQL语句，从机接收查询语句，分担主机的查询压力。

[img-RxcePQqK-1565178387515_assets_1563939118812.png]: /images/20211104/975681bcb6f745518140682b285bae30.png
[img-azuw4Fis-1565178387516_assets_1563939127063.png]: /images/20211104/6bef69b97fed427a8d7305795903eb82.png
[img-M3lz6kTq-1565178387517_assets_1563939234079.png]: /images/20211104/7c5b8621bf0f42bf97b3bed281c254a0.png
[img-0SxjIG8z-1565178387518_assets_1563939258590.png]: /images/20211104/bbe7733869814b35a8b9c54f1b510ae4.png
[img-KlZcok9I-1565178387524_assets_1563939334854.png]: /images/20211104/b78d4902af8d433d99397985121df72f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hY1d4_size_16_color_FFFFFF_t_70]: /images/20211104/b6a7da91521741fab43be8b60e22d4bf.png
[img-Y5sHEbse-1565178387525_assets_1563939427059.png]: /images/20211104/5e716d2e14e341e6a3a5297bb936b727.png
[img-ggyxZ0dJ-1565178387525_assets_1563939587312.png]: /images/20211104/60c5d41c7c614c84ad438eccd8577a2c.png
[img-ukQkcW8t-1565178387526_assets_1563939932919.png]: /images/20211104/1cab0342aa8c42cd8023b661624af8da.png
[img-ZtqO2hDx-1565178387526_assets_1563939991140.png]: /images/20211104/e1c0925e660f42a89044a4361a783959.png
[img-QsAmFHId-1565178387527_assets_1563940150731.png]: /images/20211104/67a78967e314403894de80ce656b79c6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01hY1d4_size_16_color_FFFFFF_t_70 1]: /images/20211104/50dda6040cf440d9b0f861702969de7d.png