We are well aware that ProxySQL is one of the powerful SQL aware proxy for MySQL. The ProxySQL configuration is flexible and the maximum part of configurations can be done with the ProxySQL client itself.
The latest ProxySQL release ( 2.0.9 ) has few impressive features like “SQL injection engine, Firewall whitelist, Config file generate” . In this blog I am going to explain, how to generate the ProxySQL config file using the proxySQL client .
Why configuration file ?
- Backup solution
- Helpful for Ansible deployments in multipul environments
There are two important commands involved in the ProxySQL config file generation.
- Print the config file text in ProxySQL client itself ( like query output )
- Export the configurations in separate file
Print the config file text in ProxySQL client ( like …
[Read more]