Azure MySQL redirection support?

sysown / proxysql

High-performance MySQL proxy with a GPL license.

http://www.proxysql.com

GNU General Public License v3.0

6.03k stars 981 forks source link

Azure MySQL redirection support? #3293

Open Stupremee opened 3 years ago

Stupremee commented 3 years ago

The Azure MySQL server has a feature called redirection, which allows the client to skip the gateway and directly connect to the MySQL backend.

I was wondering if there's any way to make this feature work even if ProxySQL is used as a cluster, or if there's a workaround for achieving something similar using ProxySQL.

I know that using this is not how ProxySQL works and would probably break ProxySQL features, but I still would be interested if this is supported.

sylus commented 3 years ago

I to would be interested in knowing if can do both?

nobodo commented 3 years ago

Apparently somebody has already benchmarked such functionality. I wish there was more details how it was enabled. https://serge.frezefond.com/2020/07/red/

Also, the support is needed to the underlying mariadb connector/c, issue linked here: https://jira.mariadb.org/browse/CONC-468

sylus commented 3 years ago

This seems to be how it was done by @sfrezefo

https://github.com/sfrezefo/proxysql/commits/azureredirect

sergioadofaci commented 2 years ago

This would be really useful, was there a PR or just the fork?