Single alias for all db server login names that can work for all master and replica servers
Currently db server login user name format is dbuser@servername, and thus we end up having different server login names for different master and replica servers (ie, myuser@master, myuser@replica1, myuser@replica2,....).
This format can be big trouble in using popular read replica load balancing solutions like HA Proxy / SQL Proxy that uses single login user across all MySQL servers, or MySQL router (another load balancing solution) that doesn't support '@' format for its login user.
we can leverage these popular MySQL load balancing solutions above If Azure Database for MySQL can support single alias for all db server login names that can work for all master and replica servers login.
ProxySQL has been patched to support the routing for Azure DB for MySQL. Please refer to this blog to learn more about how to load balance read replicas using ProxySQL: https://techcommunity.microsoft.com/t5/azure-database-for-mysql/load-balance-read-replicas-using-proxysql-in-azure-database-for/ba-p/880042
Andrea Lam on behalf of the Azure DB for MySQL team