Describe the issue
For non-admin user permission part, this command doesn't work on Aurora MySQL. It doesn't use this table for failover. Maybe we need "information_schema.replica_host_status" instead.
GRANT SELECT ON mysql.rds_topology TO 'your_user'@'%'; FLUSH PRIVILEGES;
Links
https://github.com/aws/aws-advanced-jdbc-wrapper/blob/main/docs/using-the-jdbc-driver/using-plugins/UsingTheBlueGreenPlugin.md#connecting-with-non-admin-users