请问支持mycat查询和变更吗？

[leewong0911]

如题。谢谢！

[nick2wang]

1. 常规查询语句应该是没问题的，不过mycat的hint默认会被archery过滤掉；
2. 上线前archery会检测实例的read_only属性，如果mycat做了读写分离，那read_only永为1，archery会拒绝上线。

[leewong0911]

thanks!

[leewong0911]

我在测试环境中，mycat后端只有一个mysql主库。使用inception连接 mycat 端口执行操作时，有如下错误。

inception测试：

sql = """
/* --user=dba;--password=123;--host=172.30.33.100;--port=8066;--enable-execute; */
inception_magic_start;

**use DB1;
insert into t1(c1,c2) values (1,1) ;
inception_magic_commit;
"""

inception错误：

ID: 1
stage: NONE
errlevel: 2
stagestatus: None
errormessage: No dataNode found ,please check tables defined in schema:null
SQL: 
======
 Global environment 
======
Affected_rows: 0
sequence: None
backup_dbname: None
execute_time: 0
sqlsha1: None

mycat错误：

2023-06-29 16:18:59.803  INFO [$_NIOREACTOR-0-RW] (io.mycat.net.handler.FrontendAuthenticator.success(FrontendAuthenticator.java:226)) - ServerConnection [id=17, schema=null, host=172.30.33.100, user=dba,txIsolation=3, autocommit=true, schema=null, executeSql=null]'dba' login success
2023-06-29 16:18:59.809  WARN [$_NIOREACTOR-0-RW] (io.mycat.server.handler.SetHandler.handle(SetHandler.java:161)) - ServerConnection [id=17, schema=null, host=172.30.33.100, user=dba,txIsolation=3, autocommit=true, schema=null, executeSql=set session wait_timeout=28800]set session wait_timeout=28800 is not recoginized and ignored
2023-06-29 16:18:59.817  INFO [$_NIOREACTOR-0-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:520)) - close connection,reason:quit cmd ,ServerConnection [id=17, schema=null, host=172.30.33.100, user=dba,txIsolation=3, autocommit=true, schema=null, executeSql=null]

[nick2wang]

这里应该是mycat的schema.xml配置问题吧？
errormessage: No dataNode found ,please check tables defined in schema:null