DBProxy是由美团点评公司技术工程部DBA团队（北京）开发维护的一个基于MySQL协议的数据中间层

1. set names utf8 collate utf8_unicode_ci; 设置该字符集报错
2. Exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[07000]: <>: 1105 Proxy Warning - Syntax Forbidden Prepare:select * from pt_client where pt_client.id = ? limit 1 (SQL: select * from pt_client where pt_client.id = 8005 limit 1)' 在执行语句时候出错

configure: error: mysql_config not exists or not executable, use $ ./configure --with-mysql=/path/to/mysql_config

请教下mysql_config是指那个配置文件，/etc/my.cnf ，还是其他配置文件！

主从配置如下：

mysql> select * from backends; +-------------+--------------------+----------+-------+------+--------+---------+-----------------+ | backend_ndx | address | hostname | state | type | weight | tag | threads_running | +-------------+--------------------+----------+-------+------+--------+---------+-----------------+ | 1 | 192.168.1.109:3306 | | up | rw | 0 | NULL | 0 | | 2 | 192.168.1.108:3306 | | up | ro | 10 | 252_108 | 0 | +-------------+--------------------+----------+-------+------+--------+---------+-----------------+ 2 rows in set (0.00 sec)

抓取的sql日志如下：

2018-01-03 19:13:04.14733: C:192.168.1.109:61231 C_db:xxxxxxx C_usr:xxxxxxx Query select * from adbasic where adID = '2196960568155587068' 2018-01-03 19:13:04.15501: C_begin:2018-01-03 19:13:04.14729 C:192.168.1.109:61231 C_db:xxxxxxx C_usr:store S:192.168.1.109:3306(thread_id:326231) S_db:xxxxxxx S_usr:xxxxxxx inj(type:4 bytes:267 rows:1) 0.713(ms) OK Query:select * from adbasic where adID = '2196960568155587068'

vagrant@vagrant-ubuntu-trusty:~$ git clone [email protected]:Meituan-Dianping/DBProxy.git Cloning into 'DBProxy'... Permission denied (publickey). fatal: Could not read from remote repository.

Please make sure you have the correct access rights and the repository exists.

** (process:40117): CRITICAL **: chassis-frontend.c:79(chassis_frontend_init_glib)GLib version too old (micro mismatch), got: lib=2.42.0, headers=2.56.1

我修改安装用 : lib=2.42.0 但是 make 会子又用glib 2.0?什么鬼啊？

项目里用的JDBC驱动 mysql-connector-java 6.0.6，直连mysql是ok的，连接proxy报错： java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is require

驱动版本改为mysql-connector-java 5.1.46 ，并将driverClassName由com.mysql.cj.jdbc.Driver改为com.mysql.jdbc.Driver就OK了

但是有点担心驱动版本的变更并且固定死会有隐患，这个真的是不支持吗，还是我使用方式不对

有两张表A， B， 他们都是大数据表，将他们按各自的分表键分表之后变成了A_0, A_1, B_0， B_1. select a.name, b.name as n2 from A a INNER JOIN B b on a.xx= b.yyy where a.shardingKey=xxx and b.shardingKey=yyy

最终不会生成分表 的join语句类似(e.g. select a.name, b.name as n2 from A_0 a inner join B_1 b on a.xx=b.yyy)