How to use Mycat-web, a Mycat monitoring tool
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.
