Mycat-server Monitoring Service Mycat-web__web

Mycat-web is the mycat-server to provide monitoring services. function is not limited to the use of mycat-server. He monitors all JVMs based on JMX. Through JDBC connection to Mycat, MySQL monitoring. Based on the SNMP protocol, monitors the CPU, memory, network, and disk of remote servers (currently limited to Linux systems).

GitHub Source: Https://github.com/boonyachengdu/Mycat-Web

Support SQL online, based on Sqlwatch Open source project, with SQL syntax check and backup data recognition, release DBA Energy. ### New Mycat all in one mirror download

Mycat all in one is a mycat-server,mycat-web,mysql,zookeeper test development environment where you develop test prerequisites, and you can start your mycat trip by following these steps:

Import OVA install Oracle VM VIRTUALBOX launch Oracle VM VirtualBox download Mycat-all-in-one mirrored file, stamp here download All-in-one Mirror, password: v63y file (Admin) -> Import Appliances (Import virtual computer) < network mode preferred bridging mode > select CentOS 7.ova all the way next

start virtual machine login Virtual machine root/123456 start multiple instance MySQL

   Mysqld_multi start

Start Mycat

   cd/opt/mycat/
   ./bin/mycat start

ZK Start

    cd/opt/zookeeper-3.4.6
	bin/zkserver.sh start
	bin/zkcli.sh

experience mycat boot navicat Premium connection mycat,ip:8066 test/test connection TestDB test

      SELECT * from T_user;

mycat Eye Boot

    Cd/opt/mycat-web
	./start.sh 
    Access Address: Http://localhost:8082/mycat

Please note that ' experience Mycat ' This step of the IP address settings, the virtual machine IP address and host address mismatch will cause connection failure, at this point can be the virtual machine IP address to modify the static IP address to resolve, modify located in the path

/etc/sysconfig/network-scripts/ifcfg-enp0s3 

The following file, and then run the command

Service Network restart

To get the file that you just modified to take effect.

MYCAT Web SQL Online Configuration reference (optional)

Modify mycat.properties file Access sqlwatch parameter configuration, specific reference sqlwatch.md