Dynamically Configuring Authority in ShardingSphere Proxy

[nisiyong]

Hi, ShardingSphere Teams.

I am currently deploying the latest stable version, 5.4.1, of ShardingSphere into a Kubernetes cluster, utilizing DistSQL to manage the proxy server. I've successfully employed a ConfigMap to manage the server.yaml file, mounted at /opt/shardingsphere/conf, and everything is functioning as expected.

However, I am facing a challenge with making the authority configuration dynamic. As of now, it seems that DistSQL does not provide support for configuring the authority dynamically. Whenever I need to add a user or grant specific privileges, the only apparent solution is to manually update the server.yaml file and then restart the proxy server.

I was wondering if you could provide guidance or best practices on achieving dynamic authority configuration within the Kubernetes environment, particularly when using DistSQL. Are there any alternative methods or configurations that I might be overlooking?

[nisiyong]

#25149