Shulou(Shulou.com)05/31 Report--

This article shows you how to use the Mycat monitoring tool Mycat-web, which is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Mycat-web download address: http://dl.mycat.io/mycat-web-1.0/Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz

Zookeeper download address: http://dl.mycat.io/zookeeper-3.4.6.tar.gz

1. Download and install the zookeeper service

[root@k8s01 ~] # wget http://dl.mycat.io/zookeeper-3.4.6.tar.gz

[root@k8s01] # tar xvf zookeeper-3.4.6.tar.gz-C / usr/local/

[root@k8s01 ~] # cd / usr/local/zookeeper-3.4.6/conf/

[root@k8s01 conf] # cp-a zoo_sample.cfg zoo.cfg

[root@k8s01 conf] # vim zoo.cfg

DataDir=/usr/local/zookeeper-3.4.6/data-saves the data of zk

[root@k8s01 conf] #.. / bin/zkServer.sh start

JMX enabled by default

Using config: / usr/local/zookeeper-3.4.6/bin/../conf/zoo.cfg

Starting zookeeper... STARTED

[root@k8s01 conf] # netstat-antulp | grep 2181

Tcp6 0 0: 2181: * LISTEN 92195/java

[root@k8s01 conf] #

two。 Download and install Mycat-web

[root@k8s01 ~] # wget http://dl.mycat.io/mycat-web-1.0/Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz

[root@k8s01] # tar xvf Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz-C / usr/local/

[root@k8s01 ~] # cd / usr/local/mycat-web/mycat-web/WEB-INF/classes/

[root@k8s01 classes] # vim mycat.properties-basic configuration, mail service can also be configured

Zookeeper=localhost:2181-- zookeeper address

Sqlonline.server=10.4.132.50-Native IP

Sqlonline.user=root

Sqlonline.passwd=1qaz2WSX

[root@k8s01 classes] # cd / usr/local/mycat-web/

[root@k8s01 mycat-web] # sh start.sh &

[1] 93876

[root@k8s01 mycat-web] # netstat-antulp | grep 8082

Tcp6 0 0: 8082: * LISTEN 93877/java

[root@k8s01 mycat-web] #

3. Visit the page to add a mycat host

Access address: http://10.4.132.50:8082/mycat/

Add Mycat host

Mycat name: optional, must be in English

IP address: IP address of Mycat

Management port: default is 9066

Dataport: default is 8066

Database name, user name, password: / usr/local/mycat/conf/server.xml is the name,password,schemas in this file.

View the value after adding a mycat host

4. Monitor jvm indicator valu

Fill in the monitoring JVM parameters

Check the completed value

5. View Mycat monitoring valu

View the value of monitoring JVM

View the schema of the database in mycat

6. View SQL monitoring valu

The above is how to use the Mycat monitoring tool Mycat-web. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.