在进行MySQL的读写分离实验时,启动mycat后发现服务起不来,使用netstat命令查看8066端口,可以看出服务并没有启动起来
[root@mycat ~]# /usr/local/mycat/bin/mycat start
Starting Mycat-server...
[root@tomcat conf]# netstat -anpt | grep 8066
[root@tomcat conf]#
查看mycat的启动日志:wrapper.log
[root@tomcat conf]# vim /usr/local/mycat/logs/wrapper.log
INFO | jvm 1 | 2020/04/27 15:36:20 | java.lang.ExceptionInInitializerError
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.MycatStartup.main(MycatStartup.java:53)
INFO | jvm 1 | 2020/04/27 15:36:20 | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO | jvm 1 | 2020/04/27 15:36:20 | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
INFO | jvm 1 | 2020/04/27 15:36:20 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
INFO | jvm 1 | 2020/04/27 15:36:20 | at java.lang.reflect.Method.invoke(Method.java:498)
INFO | jvm 1 | 2020/04/27 15:36:20 | at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
INFO | jvm 1 | 2020/04/27 15:36:20 | at java.lang.Thread.run(Thread.java:748)
INFO | jvm 1 | 2020/04/27 15:36:20 | Caused by: io.mycat.config.util.ConfigException: readHost slave1 duplicated!
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.config.loader.xml.XMLSchemaLoader.loadDataHosts(XMLSchemaLoader.java:821)
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.config.loader.xml.XMLSchemaLoader.load(XMLSchemaLoader.java:113)
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.config.loader.xml.XMLSchemaLoader.<init>(XMLSchemaLoader.java:78)
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.config.loader.xml.XMLSchemaLoader.<init>(XMLSchemaLoader.java:82)
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.config.ConfigInitializer.<init>(ConfigInitializer.java:76)
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.config.MycatConfig.<init>(MycatConfig.java:72)
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.MycatServer.<init>(MycatServer.java:166)
INFO | jvm 1 | 2020/04/27 15:36:20 | at io.mycat.MycatServer.<clinit>(MycatServer.java:109)
INFO | jvm 1 | 2020/04/27 15:36:20 | ... 7 more
可以看出:Caused by: io.mycat.config.util.ConfigException: readHost slave1 duplicated!
显示readHost slave1重复
检查schema.xml文件,才发现复制时忘记了修改,导致重复。:
进行相应的修改:
保存退出,重新启动mycat并检查端口,发现OK.
[root@mycat ~]# /usr/local/mycat/bin/mycat start
Starting Mycat-server...
[root@tomcat conf]# netstat -anpt | grep 8066
tcp6 0 0 :::8066 :::* LISTEN 66312/java