Problem of password rotation in MySQL Cluster when there is change in primary node

[hariprasad-tallapalli]

Currently in my company we are trying to use Vault to rotate password for an user in MySQL HA cluster environment. When there is a change in primary instance the password rotation fails.

Describe the solution you'd like
Vault must figure out the way to know when there is a change in primary instance and execute the alter statement for password query in R/W instance.

Describe alternatives you've consideredVault must support usage of some shell scripting to run instead of queries.

.

[heatherezell]

Hi! Can you please provide more details around this issue? The issue template included places to provide your commands, what you expect, what resulting error you received, as well as information on how to gather and provide your Vault configuration. This information is crucial to being able to reproduce the issue and identify possible solutions. Thanks!