Mycat-web的安装使用(包含zookeeper)

梦里梦外; 2023-07-07 08:50 16阅读 0赞

# 背景： #

# ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70][] #

服务器列表：

<table> 
 <tbody> 
 <tr> 
 <td style="vertical-align:top;width:91.65pt;"> 机器IP </td> 
 <td style="vertical-align:top;width:53.6pt;"> 机器名 </td> 
 <td style="vertical-align:top;width:230.75pt;"> 安装组件 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:91.65pt;"> 192.168.239.144 </td> 
 <td style="vertical-align:top;width:53.6pt;"> douzi9 </td> 
 <td style="vertical-align:top;width:230.75pt;"> Mysql Master1|Mycat1 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:91.65pt;"> 192.168.239.145 </td> 
 <td style="vertical-align:top;width:53.6pt;"> douzi10 </td> 
 <td style="vertical-align:top;width:230.75pt;"> Mysql Slave1|HAProxy Keepalived Master|zk </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:91.65pt;"> 192.168.239.146 </td> 
 <td style="vertical-align:top;width:53.6pt;"> douzi11 </td> 
 <td style="vertical-align:top;width:230.75pt;"> Mysql Master2|Mycat2 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:91.65pt;"> 192.168.239.147 </td> 
 <td style="vertical-align:top;width:53.6pt;"> douzi12 </td> 
 <td style="vertical-align:top;width:230.75pt;"> Mysql Slave2|HAProxy Keepalived Savle|mycat-web </td> 
 </tr> 
 </tbody> 
</table>

## zookeeper安装： ##

1.官网下载tar包 zookeeper-3.4.12.tar.gz

2.上传虚拟机douzi11， 解压，命令：tar -zxvf zookeeper-3.4.12.tar.gz -C /usr/local

3.进入conf目录，创建一个zookeeper的配置文件zoo.cfg，可复制conf/zoo\_sample.cfg作为配置文件

4.配置文件说明：

<table> 
 <tbody> 
 <tr> 
 <td> # The number of milliseconds of each tick # tickTime：CS通信心跳数 # Zookeeper 服务器之间或客户端与服务器之间维持心跳的时间间隔，也就是每个 tickTime 时间就会发送一个心跳。tickTime以毫秒为单位。 tickTime=2000 # The number of ticks that the initial # synchronization phase can take # initLimit：LF初始通信时限 # 集群中的follower服务器(F)与leader服务器(L)之间初始连接时能容忍的最多心跳数（tickTime的数量）。 initLimit=5 # The number of ticks that can pass between # sending a request and getting an acknowledgement # syncLimit：LF同步通信时限 # 集群中的follower服务器与leader服务器之间请求和应答之间能容忍的最多心跳数（tickTime的数量）。 syncLimit=2 # the directory where the snapshot is stored. # do not use /tmp for storage, /tmp here is just # example sakes. # dataDir：数据文件目录 # Zookeeper保存数据的目录，默认情况下，Zookeeper将写数据的日志文件也保存在这个目录里。 dataDir=/data/soft/zookeeper-3.4.12/data # dataLogDir：日志文件目录 # Zookeeper保存日志文件的目录。 dataLogDir=/data/soft/zookeeper-3.4.12/logs # the port at which the clients will connect # clientPort：客户端连接端口 # 客户端连接 Zookeeper 服务器的端口，Zookeeper 会监听这个端口，接受客户端的访问请求。 clientPort=2181 # the maximum number of client connections. # increase this if you need to handle more clients #maxClientCnxns=60 # # Be sure to read the maintenance section of the # administrator guide before turning on autopurge. # # http://zookeeper.apache.org/doc/current/zookeeperAdmin.html#sc_maintenance # # The number of snapshots to retain in dataDir #autopurge.snapRetainCount=3 # Purge task interval in hours # Set to "0" to disable auto purge feature #autopurge.purgeInterval=1 # 服务器名称与地址：集群信息（服务器编号，服务器地址，LF通信端口，选举端口） # 这个配置项的书写格式比较特殊，规则如下： # server.N=YYY:A:B &nbsp; # 其中N表示服务器编号，YYY表示服务器的IP地址，A为LF通信端口，表示该服务器与集群中的leader交换的信息的端口。B为选举端口，表示选举新leader时服务器间相互通信的端口（当leader挂掉时，其余服务器会相互通信，选择出新的leader）。一般来说，集群中每个服务器的A端口都是一样，每个服务器的B端口也是一样。但是当所采用的为伪集群时，IP地址都一样，只能时A端口和B端口不一样。 </td> 
 </tr> 
 </tbody> 
</table>

启动命令：./bin/zkServer.sh start

停止命令：./bin/zkServer.sh stop

重启命令：./bin/zkServer.sh restart

状态查看命令：./bin/zkServer.sh status

## Mycat-web安装 ##

1.下载 Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz，地址：

http://dl.mycat.io/mycat-web-1.0/

2.上传douzi12服务器，解压：

tar -zxvf Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz -C /usr/local

3.启动mycat web

cd /usr/local/mycat-web

./start.sh &

浏览器上访问：[http://douzi12:8082/mycat][http_douzi12_8082_mycat]

添加zookeeper配置

添加mycat配置

添加mycat-vm配置

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 4][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200222134937410.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5,size_16,color_FFFFFF,t_70
[http_douzi12_8082_mycat]: http://bigdata1:8082/mycat
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200222143038711.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2020022214311418.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200222143135488.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/2020022214321813.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzE2MTE2NTQ5,size_16,color_FFFFFF,t_70