Proxysql and MySQL users auto synchronisation

Polyglot Projects ProxySQL
1

Hi Guys,

Is there any feature available in proxysql to auto synchronise mysql and proxysql users (I know that this can be done manually using Percona admin tool but looking for an automated approach)? How this is being managed by Percona PXC K8s clusters using an operator?

Thanks in advance!

1 Like
2

Hello @nethisandeep ,

this feature is available in proxysql-admin-tool.
See --syncusers flag.
This is how we do it in the Percona XtraDB Cluster Operator.

1 Like
3

Thanks for your response @Sergey_Pronin
Isn’t this command execution manual all the time? or execution of this command is going to launch some daemon in the backend?

Also is it possible to use this tool with standard master-slave setups?

1 Like
4

@nethisandeep it is manual. You can create a cronjob to automate it.

As for master-slave setups - I don’t see any issue here to use it.

1 Like