Question 1

How do I integrate mysql_utils with my own service discovery?

Accepted Answer

You'll need to modify the environment specifics library and adapt code for your CMDB, as the tools are hardcoded for Pinterest's Zookeeper setup. Expect to write custom glue code to handle host and credential management.

Question 2

mysql_utils vs orchestrator: which is better for MySQL failover?

Accepted Answer

mysql_utils offers deep integration with service discovery and automated lifecycle management, but is unmaintained and Pinterest-specific. Orchestrator is a more general, actively maintained tool for replication topology management, but may require additional setup for full automation.

Question 3

Can mysql_utils handle MySQL 8.0 or newer versions?

Accepted Answer

The tools were developed for MySQL 5.6, as shown in the launch_amazon_mysql_server.py example. Since maintenance has stopped, compatibility with MySQL 8.0 or later is not guaranteed and would require manual updates to the scripts.

Question 4

How to set up automated backups with mysql_utils?

Accepted Answer

Use mysql_backup.py for logical or xtrabackup backups, which uploads to S3. However, you must first configure service discovery and ensure your environment specifics are populated, as the script relies on Zookeeper for host information.

Question 5

What are the security risks of using mysql_utils?

Accepted Answer

Credentials are managed via service discovery (e.g., Zookeeper), so securing that layer is critical. Backups go to S3 without built-in encryption, requiring external measures. The unmaintained status also means unpatched vulnerabilities.

Question 6

Is there any community or documentation for mysql_utils?

Accepted Answer

No official community or documentation beyond the README, as Pinterest has abandoned the project. The code serves as a reference implementation, but users are on their own for support and troubleshooting.

mysql_utils

What is mysql_utils?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions