Skip to main content
Question

Highy available MySQL database

  • February 3, 2017
  • 3 replies
  • 24 views

Forum|alt.badge.img+14

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?

3 replies

Forum|alt.badge.img+7

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.


Forum|alt.badge.img+9
  • Contributor
  • February 3, 2017

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
Forum|alt.badge.img+36
  • Hall of Fame
  • February 3, 2017

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

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