how to install proxySQL for MySQL

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?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
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...
0
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

any update for me?
0
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Installation

From novice to tech pro — start learning today.