WordPress Toolkit, and database cluster with ProxySQL

[Maciej]

Hi,

I have in testing environment running Plesk Obsidian and db cluster (3 instances od Percona) with ProxySQL as external database. I want to use this as database for Wordpress instances.

Normally when I install WordPress on Plesk, system create mysql user, database and creates a database tables structure.
When I worked with ProxySQL, in ProxySQL database must be created the same user that in db cluster.
That means, before I install WP I need create the same user first on ProxySQL database, next on DB cluster.
Only users who is in ProxySQL database have access to DB cluster.

Is there any possibility to automatically create a user in ProxySQL simultaneously with creating a the same user in MySQL ?

regards
Maciej

 

[Ales]

@Maciej, I would attempt to automate this using Plesk's Event Handlers.

An event is triggered when a database user is created, modified or removed, among others, and the event parameters seem sufficient for the task.