Bug #78344 mysqlrpladmin does not scale or work well in the cloud

• Submitted: 5 Sep 2015 22:04
• Modified: 2 Dec 2016 9:57
• Reporter: monty solomon
• Status: Verified
• Category: MySQL Utilities
• Severity: S3 (Non-critical)
• Version: 1.5.4
• OS: Any
• CPU Architecture: Any

[5 Sep 2015 22:04] monty solomon

Description:
mysqlrpladmin does not work well in a cloud environment with many servers or a cloud environment where servers are replaced as needed.

Instead of using an option section in the .my.cnf file mysqlrpladmin expects there to be a separate entry in the .mylogin file or in the configuration file for each server.

How to repeat:
Configure and use mysqlrpladmin with 200 servers and 100 replication clusters.

1. Add each server to the .mylogin and/or configuration file.

2. Create new servers and clusters.

3. Update the .mylogin and/or configuration files with information about the new servers.

4. Terminate some servers

5. Remove the terminated servers from the .mylogin and/or configuration files.

6. Repeat steps 2 and 3 and/or steps 4 and 5 many times.

Suggested fix:
Support the use of a [mysqlrpladmin] section in the .my.cnf file that specifies the credentials for the mysqlrpladmin user and for the replication user.

[2 Dec 2016 9:56] Chiranjeevi Battula

Hello monty solomon,

Thank you for the bug report.
Verified based on internal discussion with dev's will take it up as a feature request.

Thanks,
Chiranjeevi.