Mycat监控工具Mycat-web

以你之姓@ 2023-07-07 08:07 6阅读 0赞

Mycat-web下载地址： [ http://dl.mycat.io/mycat-web-1.0/Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz][http_dl.mycat.io_mycat-web-1.0_Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz]

zookeeper下载地址：http://dl.mycat.io/zookeeper-3.4.6.tar.gz

1.下载安装zookeeper服务

\[root@k8s01 ~\]\# wget [ http://dl.mycat.io/zookeeper-3.4.6.tar.gz][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      --保存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\]\#

2.下载安装 Mycat-web

\[root@k8s01 ~\]\# wget [ http://dl.mycat.io/mycat-web-1.0/Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz][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      --基本配置，也可配置邮件服务

zookeeper=localhost:2181            --zookeeper地址

sqlonline.server=10.4.132.50        --本机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.访问页面，添加mycat主机

访问地址：http://10.4.132.50:8082/mycat/

![format_png][]

添加Mycat主机

![format_png 1][]

Mycat名称：随意，必须是英文

IP地址：Mycat的IP地址

管理端口：默认是9066

数据端口：默认是8066

数据库名称，用户名，密码：/usr/local/mycat/conf/server.xml    是这个文件中的name，password，schemas。

![format_png 2][]

查看添加mycat主机后的值

![format_png 3][]

4.监控jvm指标值

![format_png 4][]

填写监控JVM参数

![format_png 5][]

查看填写后的值

![format_png 6][]

5.查看Mycat监控值

![format_png 7][]

查看监控JVM的值

![format_png 8][]

查看mycat中数据库的架构

![format_png 9][]

6.查看SQL监控值 ![format_png 10][]

[http_dl.mycat.io_mycat-web-1.0_Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz]: http://dl.mycat.io/mycat-web-1.0/Mycat-web-1.0-SNAPSHOT-20170102153329-linux.tar.gz
[http_dl.mycat.io_zookeeper-3.4.6.tar.gz]: http://dl.mycat.io/zookeeper-3.4.6.tar.gz
[format_png]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvMWNlMWE4NmJhYjcxNGM4Yy5wbmc?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvZWJmNWRlNTkxYjgwN2Q3NC5wbmc?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvZjljODY4YjgzN2NhZjNjOC5wbmc?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvMDc0ZDg0ZjJmNzRmZDdhYS5wbmc?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvYmY5ZTk3OTNkYzI2OWZiNC5wbmc?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvNDVhZWEyNTBjNjM5YjQ4Yy5wbmc?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvZjU1YTc2MDU5YWZhNTgzMy5wbmc?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvZjIyNDVmNzUyYTBhYWI0MC5wbmc?x-oss-process=image/format,png
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvOGY4ZmUzMjEyNDkzY2E5OS5wbmc?x-oss-process=image/format,png
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvNTc0NTY1MTUxYTc0N2I4Yy5wbmc?x-oss-process=image/format,png
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cDovL2ltZy5ibG9nLml0cHViLm5ldC9ibG9nLzIwMTkvMTEvMTgvOGE3YzVjMzNmMWFkYTg2NC5wbmc?x-oss-process=image/format,png