lightfish
lightfish
谢谢你,已经加入到权威指南了
I have sent an invitation with write permission to you. There may be a misspelled "drfault". I will test it with dbeaver.
> Hello @junwen12221 If there are any problems when testing with DBeaver, please let me know. Thank you. After I fix several spelling mistakes, 'dbeaver' can connect to mycat2 and...
EXPLAIN SELECT @@hostname 这个响应是mycat响应的,不是发送到mysql执行的,mycat启动的时候从原型库读取变量并缓存下来了,你应该用其他方法检查 `EXPLAIN SELECT @@hostname FROM db1.dual;` db1.dual是业务库
sqlserver,暂时方言没有适配,有些语法不支持.支持的是sqlserver与mysql语法相同的部分. Mycat2使用其他数据库,需要保证原型库是mysql,然后添加其他数据库类型的数据源,并把逻辑表或者物理分表映射到它们上面. 如果你只是想把多个数据库的表合拼成一个逻辑表,并查询,可以尝试用ClickHouse的分布式表或者 https://github.com/teiid/teiid,其他大数据产品也有类似的功能
设置debug日志 https://www.yuque.com/ccazhw/ml3nkf/ohax4t 在日志中能看到mycat接收到的sql 另外explain insert table.....也可以看到  发送到数据源的sql
看看DataGrip中插入的日志
给出连接mycat的客户端的配置
把数据源的native改成jdbc
Yes, your are right. The design of mycat2 takes MySQL protocol as the front end and various databases as the backend, it supports MySQL as the backend (mainly), and also...