# Proxysql and MySQL users auto synchronisation

**URL:** <https://forums.percona.com/t/proxysql-and-mysql-users-auto-synchronisation/10320>\
**Category:** ProxySQL\
**Created:** [May 2, 2021, 7:39pm UTC](https://forums.percona.com/t/proxysql-and-mysql-users-auto-synchronisation/10320 "2021-05-02T19:39:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nethisandeep](https://avatars.discourse-cdn.com/v4/letter/n/47e85d/32.png) [@nethisandeep](https://forums.percona.com/u/nethisandeep)\
**Post date:** [May 2, 2021, 7:39pm UTC](https://forums.percona.com/t/proxysql-and-mysql-users-auto-synchronisation/10320/1 "2021-05-02T19:39:07Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [May 4, 2021, 11:16am UTC](https://forums.percona.com/t/proxysql-and-mysql-users-auto-synchronisation/10320/2 "2021-05-04T11:16:08Z")

</div>

Hello @nethisandeep ,

this feature is available in [proxysql-admin-tool](https://github.com/percona/proxysql-admin-tool).  
See --syncusers flag.  
This is how we do it in the Percona XtraDB Cluster Operator.

---

<div class="post-metadata">

**Author:** ![nethisandeep](https://avatars.discourse-cdn.com/v4/letter/n/47e85d/32.png) [@nethisandeep](https://forums.percona.com/u/nethisandeep)\
**Post date:** [May 4, 2021, 9:53pm UTC](https://forums.percona.com/t/proxysql-and-mysql-users-auto-synchronisation/10320/3 "2021-05-04T21:53:36Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)\
**Post date:** [May 5, 2021, 7:49am UTC](https://forums.percona.com/t/proxysql-and-mysql-users-auto-synchronisation/10320/4 "2021-05-05T07:49:17Z")

</div>

@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.