how to install proxySQL for MySQL

marrowyung
marrowyung used Ask the Experts™
on
Hi,

Any real and working steps by steps guide on install and configure Proxy SQL for MySQL InnodB cluster?

ProxySQL is free right? https://github.com/sysown/proxysql/wiki 

and ProxySQL should be the only one good to work with MySQL InnoDB cluster?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
I think this post is helpful but i must admit i was not aware of ProxySQL ...and of course presently i don't have need for a cluster...but always good to know...
Fractional CTO
Distinguished Expert 2018
Commented:
You asked "... install and configure Proxy SQL for MySQL InnodB cluster?" which... is... an odd question...

Just run a multi-master cluster + there's no requirement for any Proxy.

Or maybe you mean something different by Proxy.

Maybe clarify what you hope to accomplish by using a Proxy which can't be accomplished by using multi-master replication.
marrowyungSenior Technical architecture (Data)

Author

Commented:
David,

"Maybe clarify what you hope to accomplish by using a Proxy which can't be accomplished by using multi-master replication."

should I say what a Router can't do and need proxySQL, like data masking ?

so I also need to test it and other reason is, we have mariaDB here and we setup maxscale too ! so I want to run the same thing on MySQL InnoDB cluster.

ProxySQL also a database firewall.

John,

"i don't have need for a cluster...but always good to know..."

what do you mean, I am talking about proxy, right? do you use any proxy for your OS DB ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
hi,

any update for me?
marrowyungSenior Technical architecture (Data)

Author

Commented:
tks. proxySQL do not have support and it can't do transaction level failover but MariaDB maxscale can, so we focus on MariaDB for now.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial