接上一篇：企業(yè)實戰(zhàn)_18_MyCat_ZK集群安裝部署
https://gblfy.blog.csdn.net/article/details/100075631

文章目錄

• • • • • 一、初始化集群中的數(shù)據(jù)
        • • 1. 配置復(fù)制
          • 2. 初始化zookeeper集群中的數(shù)據(jù)
        • 二、驗證數(shù)據(jù)是否被初始化到集群中
        • • 2.1. 進(jìn)入mycat01服務(wù)節(jié)點
          • 2.2. 使用ls命令查看當(dāng)前節(jié)點
          • 2.3. 進(jìn)入zk node1服務(wù)節(jié)點
          • 2.4. 驗證數(shù)據(jù)是否已同步zk02
          • 2.5. 使用ls命令驗證信息
        • 三、配置mycat支持zookeeper啟動
        • • 3.1. mycat節(jié)點01配置修改
          • 3.2. mycat節(jié)點02
          • 3.3. 重啟mycat
          • 3.4. 登錄mycat節(jié)點02
          • 3.5. 配置數(shù)據(jù)驗證

init_zk_data.sh腳本，這個腳本的作用就是向zookeeper集群中初始化mycat配置的，關(guān)于腳本呢、通過讀取zkconf目錄下mycat的配置文件，把它初始化到zookeeper集群中。

一、初始化集群中的數(shù)據(jù)

1. 配置復(fù)制

#進(jìn)入conf目錄 cd /app/mycat/conf/#將重要的配置文件，復(fù)制到zkconf目錄下面 cp server.xml schema.xml rule.xml sequence_db_conf.properties zkconf/

2. 初始化zookeeper集群中的數(shù)據(jù)

#進(jìn)入mycat的bin目錄下面 cd /app/mycat/bin/#執(zhí)行初始化腳本 ./init_zk_data.sh

注：當(dāng)看到INFO Done時，說明已經(jīng)初始化完成了

[root@node1 bin]# ./init_zk_data.sh o2021-07-14 08:10:03 INFO JAVA_CMD=java o2021-07-14 08:10:03 INFO Start to initialize /mycat of ZooKeeper o2021-07-14 08:10:07 INFO Done

二、驗證數(shù)據(jù)是否被初始化到集群中

2.1. 進(jìn)入mycat01服務(wù)節(jié)點

# 進(jìn)入zk的bin目錄 cd /app/zookeeper-3.4.11/bin/#使用zk客戶端，登錄到zk當(dāng)前節(jié)點中 ./zkCli.sh

2.2. 使用ls命令查看當(dāng)前節(jié)點

使用ls命令查看當(dāng)前節(jié)點下有什么節(jié)點

[zk: localhost:2181(CONNECTED) 1] ls /mycat [mycat-cluster-1] [zk: localhost:2181(CONNECTED) 2] ls /mycat/mycat-cluster-1 [schema, server, rules, cache, sequences, line]# 在/mycat/mycat-cluster-1節(jié)點下有4個配置節(jié)點，在schema配置節(jié)點下面有3個標(biāo)簽 [zk: localhost:2181(CONNECTED) 3] ls /mycat/mycat-cluster-1/schema [schema, dataNode, dataHost]# 使用`get /mycat/mycat-cluster-1/schema/dataHost`查看具體節(jié)點下的配置信息 [zk: localhost:2181(CONNECTED) 4] get /mycat/mycat-cluster-1/schema/dataHost [{"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92101","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.101","url":"192.168.92.101:3306","password":"123456","user":"im_mycat"}]},{"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92102","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.102","url":"192.168.92.102:3306","password":"123456","user":"im_mycat"}]},{"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92103","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.103","url":"192.168.92.103:3306","password":"123456","user":"im_mycat"}]},{"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92104","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.104","url":"192.168.92.104:3306","password":"123456","user":"im_mycat"}]}] cZxid = 0x100000018 ctime = Wed Jul 14 08:05:53 CST 2021 mZxid = 0x10000003d mtime = Wed Jul 14 08:10:06 CST 2021 pZxid = 0x100000018 cversion = 0 dataVersion = 2 aclVersion = 0 ephemeralOwner = 0x0 dataLength = 1041 numChildren = 0 [zk: localhost:2181(CONNECTED) 5]

2.3. 進(jìn)入zk node1服務(wù)節(jié)點

# 進(jìn)入zk的bin目錄 cd /app/zookeeper-3.4.11/bin/ #使用zk客戶端，登錄到zk當(dāng)前節(jié)點中 ./zkCli.sh

2.4. 驗證數(shù)據(jù)是否已同步zk02

進(jìn)入node2服務(wù)節(jié)點，

# 進(jìn)入zk的bin目錄 cd /app/zookeeper-3.4.11/bin/#使用zk客戶端，登錄到zk當(dāng)前節(jié)點中 ./zkCli.sh

2.5. 使用ls命令驗證信息

[zk: localhost:2181(CONNECTED) 0] ls /mycat/mycat-cluster-1 [schema, server, rules, cache, sequences, line] [zk: localhost:2181(CONNECTED) 1] get /mycat/mycat-cluster-1/schema/dataHost [{"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92101","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.101","url":"192.168.92.101:3306","password":"123456","user":"im_mycat"}]}, {"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92102","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.102","url":"192.168.92.102:3306","password":"123456","user":"im_mycat"}]}, {"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92103","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.103","url":"192.168.92.103:3306","password":"123456","user":"im_mycat"}]}, {"balance":3,"maxCon":1000,"minCon":10,"name":"mysql92104","writeType":0,"switchType":1,"dbType":"mysql","dbDriver":"native","heartbeat":"select user()","writeHost":[{"host":"192.168.92.104","url":"192.168.92.104:3306","password":"123456","user":"im_mycat"}]}]cZxid = 0x100000018 ctime = Wed Jul 14 08:05:53 CST 2021 mZxid = 0x10000003d mtime = Wed Jul 14 08:10:06 CST 2021 pZxid = 0x100000018 cversion = 0 dataVersion = 2 aclVersion = 0 ephemeralOwner = 0x0 dataLength = 1041 numChildren = 0 [zk: localhost:2181(CONNECTED) 2]

從圖中可以看出3個zookeeper信息數(shù)據(jù)已經(jīng)同步過來了
mycat配置文件到zookeeper集群的同步

三、配置mycat支持zookeeper啟動

通過zookeeper的配置文件啟動mycat

3.1. mycat節(jié)點01配置修改

#進(jìn)入mycat的安裝目錄 cd /app/mycat/conf/#編輯 myid.properties配置文件#這個文件配置了mycat通過zookeeper的節(jié)點來獲取mycat的配置信息vim myid.properties

修改后：

#是否通過zookeeper啟動 true是 false 否,通過zk讀取配置文件 loadZk=true # zookeeper的url和端口 zkURL=192.168.92.101:2181,192.168.92.102:2181,192.168.92.103:2181 #mycat在zookeeper中的節(jié)點，這個可以通過登錄zkCli.sh來查看 clusterId=mycat-cluster-1 #mycat集群中實例的id，id的值不能重復(fù) myid=mycat_01 #mycat有幾個節(jié)點 clusterSize=2 #mycat集群中節(jié)點的標(biāo)識名 clusterNodes=mycat_01,mycat_04 #server booster ; booster install on db same server,will reset all minCon to 2 type=server boosterDataHosts=dataHost1

3.2. mycat節(jié)點02

#進(jìn)入mycat的安裝目錄 cd /app/mycat/conf/ #編輯 myid.properties配置文件#這個文件配置了mycat通過zookeeper的節(jié)點來獲取mycat的配置信息vim myid.properties

修改后：

#是否通過zookeeper啟動 true是 false 否,通過zk讀取配置文件 loadZk=true # zookeeper的url和端口 zkURL=192.168.92.101:2181,192.168.92.102:2181,192.168.92.103:2181 #mycat在zookeeper中的節(jié)點，這個可以通過登錄zkCli.sh來查看 clusterId=mycat-cluster-1 #mycat集群中實例的id，id的值不能重復(fù) myid=mycat_04 #mycat有幾個節(jié)點 clusterSize=2 #mycat集群中節(jié)點的標(biāo)識名 clusterNodes=mycat_01,mycat_04 #server booster ; booster install on db same server,will reset all minCon to 2 type=server boosterDataHosts=dataHost1

3.3. 重啟mycat

重啟mycat，通過讀取zookeeper配置文件來進(jìn)行啟動了
目前：mycat01節(jié)點配置文件已經(jīng)配置好的，mycat02節(jié)點上的配置文件是默認(rèn)的，還沒有更改過的
登錄mycat節(jié)點01

[root@node1 conf]# mycat stop Stopping Mycat-server... Stopped Mycat-server. [root@node1 conf]# rm -rf /app/mycat/logs/* [root@node1 conf]# mycat start Starting Mycat-server... [root@node1 conf]# tail -f /app/mycat/logs/wrapper.log STATUS | wrapper | 2021/07/14 21:35:09 | --> Wrapper Started as Daemon STATUS | wrapper | 2021/07/14 21:35:09 | Launching a JVM... INFO | jvm 1 | 2021/07/14 21:35:09 | Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=64M; support was removed in 8.0 INFO | jvm 1 | 2021/07/14 21:35:12 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org INFO | jvm 1 | 2021/07/14 21:35:12 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved. INFO | jvm 1 | 2021/07/14 21:35:12 | INFO | jvm 1 | 2021/07/14 21:35:16 | log4j:WARN No appenders could be found for logger (io.mycat.memory.MyCatMemory). INFO | jvm 1 | 2021/07/14 21:35:16 | log4j:WARN Please initialize the log4j system properly. INFO | jvm 1 | 2021/07/14 21:35:16 | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. INFO | jvm 1 | 2021/07/14 21:35:16 | MyCAT Server startup successfully. see logs in logs/mycat.log

mycat第一個節(jié)點已經(jīng)啟動完成！

3.4. 登錄mycat節(jié)點02

啟動mycat

[root@node4 conf]# mycat start Starting Mycat-server... Removed stale pid file: /app/mycat/logs/mycat.pid You have new mail in /var/spool/mail/root [root@node4 conf]# tail -f /app/mycat/logs/wrapper.log INFO | jvm 1 | 2021/07/10 14:43:40 | log4j:WARN No appenders could be found for logger (io.mycat.memory.MyCatMemory). INFO | jvm 1 | 2021/07/10 14:43:40 | log4j:WARN Please initialize the log4j system properly. INFO | jvm 1 | 2021/07/10 14:43:40 | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. INFO | jvm 1 | 2021/07/10 14:43:40 | MyCAT Server startup successfully. see logs in logs/mycat.log STATUS | wrapper | 2021/07/14 21:37:55 | --> Wrapper Started as Daemon STATUS | wrapper | 2021/07/14 21:37:56 | Launching a JVM... INFO | jvm 1 | 2021/07/14 21:37:56 | Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=64M; support was removed in 8.0 INFO | jvm 1 | 2021/07/14 21:37:59 | Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org INFO | jvm 1 | 2021/07/14 21:37:59 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved. INFO | jvm 1 | 2021/07/14 21:37:59 | INFO | jvm 1 | 2021/07/14 21:38:08 | log4j:WARN No appenders could be found for logger (io.mycat.memory.MyCatMemory). INFO | jvm 1 | 2021/07/14 21:38:08 | log4j:WARN Please initialize the log4j system properly. INFO | jvm 1 | 2021/07/14 21:38:08 | log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. INFO | jvm 1 | 2021/07/14 21:38:08 | MyCAT Server startup successfully. see logs in logs/mycat.log

3.5. 配置數(shù)據(jù)驗證

#進(jìn)入conf目錄查看配置文件 cd /app/mycat/conf#查看schema.xml more schema.xml

發(fā)現(xiàn)，雖然，沒有配置配文件，但是mycat01節(jié)點的配置文件信息同步過來了
mycat02節(jié)點配置信息哪來的呢？就是從zookeeper集群同步過來的
以后，我們只要在zookeeper修改mycat的配置文件信息，就會同步到mycat01節(jié)點和mycat02節(jié)點，這樣就可以保證這2個mycat節(jié)點的配置是保持同步，一致的

下一篇：企業(yè)實戰(zhàn)_20_MyCat使用HAPpoxy對Mycat負(fù)載均衡
https://gblfy.blog.csdn.net/article/details/100087884

總結(jié)

以上是生活随笔為你收集整理的企业实战_19_MyCat初始化ZK并配置Mycat支持ZK的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。