RECEIVED AN UNKNOWN COMMAND: 30 -- PLEASE REPORT A BUG

[fransguelinckx]

We're using ProxySQL in front of a percona 8.x, 3-node, multi master, sync replication cluster with GTID enabled. The client that is probably causing this error is debezium, which uses the binlog to do CDC (change data capture).
I believe the command that is not supported yet is COM_BINLOG_DUMP_GTID.

[renecannao]

Hi @fransguelinckx .
Thank you for the report.
You are right about your analysis.
For debezium (or other clients streaming binlog) a lot of the features provided by proxysql aren't useful, like multiplexing, query parsing, etc. For this reason I would recommend to configure mysql_users.fast_forward=1 for only the specific user used by debezium.

Thanks

[fransguelinckx]

We will try that, thank you for the quick response!

[fransguelinckx]

Worked like a charm, closing this issue. Thanks again!

[rradillen]

The fast forward limitation of no SSL is a serious issue for us here.

[renecannao]

@rradillen , thank you for your comment.
I think it should have gone to #1459 and not here.
Writing this comment for cross reference.