Hi, On Thu, 2020-10-29 at 10:21 +0200, Jonathan Matthews wrote: > I don’t think haproxy is what you’re looking for. You’re looking for more > than a TCP proxy: you need a DB-specific-protocol-proxy. Haproxy can > listen for HTTP, above the TCP layer, but not any specific DB protocols. > > I think you need to look for a proxy that’s designed to work with the > specific DB you’re wanting to expose. > > For mysql, “mysql-proxy” and “mysql-router” come to mind. -proxy never > went GA, and I’ve not used -router.
For mysql there are MaxScale and ProxySQL. But I don't think you'll find a proxy that has all the features you'll need especially if you need to support multiple DB protocols (mysql, postgresql, oracle, mssql). -Jarno -- Jarno Huuskonen
