Highy available MySQL database

[powellbc]

We are in the process of building out our environment and clustering the Jamf Pro server seems straightforward enough. However, I have not seen anything relating to the database side.

What is the current thinking about making the database more resilient in the case of a failure?

[jrserapio]

I don't believe Jamf Pro can support MySQL clustering yet, but I could be mistaken. Was under review last time I looked.

https://www.jamf.com/jamf-nation/feature-requests/1212/mysql-cluster-support

I would say virtualize/snapshots or replicate db backup to a second db instance. Just my 2 cents.

[hjcao]

We are looking at this as well, and more than likely, we will just have a backup server (completely replicated) that we can switch over to if needed.

[donmontalvo]

Percona offers support for MySQL high availability failover (MHA)..

I wish I could post more than just HUGE kudos to them. :)