2019-01-24mysql 代理服务mycat
作者:
时光偷走了青春 | 来源:发表于
2019-01-24 14:16 被阅读0次
一、简介
1 功能
![](https://img.haomeiwen.com/i15571992/fefaca52454ef2c7.png)
image.png
2,产品
![](https://img.haomeiwen.com/i15571992/4086c8f6f428d334.png)
image.png
3 ,图示
![](https://img.haomeiwen.com/i15571992/d318761eea171a62.png)
image.png
二、mycat
1,准备好域名解析
mycat 10.18.43.163 mycat(使用你自己的主机ip)
m-s
10.18.43.41 master1
10.18.43.179 master2
案例部署(单库)
1,配置java环境
![](https://img.haomeiwen.com/i15571992/e28d1607b991039d.png)
image.png
2,配置mycat
![](https://img.haomeiwen.com/i15571992/f1a9ee29c3d79239.png)
image.png
![](https://img.haomeiwen.com/i15571992/57d6c45fce1ea35b.png)
image.png
![](https://img.haomeiwen.com/i15571992/537b3f0664a5d82d.png)
image.png
![](https://img.haomeiwen.com/i15571992/5becde7efc6db1a2.png)
image.png
![](https://img.haomeiwen.com/i15571992/86e1a294bd6cfbce.png)
image.png
![](https://img.haomeiwen.com/i15571992/94d6dbde8ac17b56.png)
image.png
3,配置mysql集群
这里使用什么集群方式可以参考上一章主从复制,可以为一主一从,一主多从,双主双从等形式,
4,启动mycat
![](https://img.haomeiwen.com/i15571992/316edb8ec14baaf1.png)
image.png
![](https://img.haomeiwen.com/i15571992/2d78f257a6e2f1cd.png)
image.png
5,mycat使用后方数据库
![](https://img.haomeiwen.com/i15571992/a457d41cf39d94e5.png)
image.png
多库部署
![](https://img.haomeiwen.com/i15571992/85c853adf381b748.png)
image.png
![](https://img.haomeiwen.com/i15571992/5c46e34313e96264.png)
image.png
本文标题:2019-01-24mysql 代理服务mycat
本文链接:https://www.haomeiwen.com/subject/kbeyjqtx.html
网友评论