MySQL Database Sprawl
Comments Have you noticed a sprawl of MySQL database installations across your servers? I’ve seen this at various organizations. Usually it is because some tool or another utilizes it, such as a ticketing system or a content management system.
While discussing server upgrades/consolidation recently, it was mentioned that perhaps we could consolidate all of these scattered OLTP-like instances into one MySQL Cluster. Some of the benefits mentioned during the discussion were reducing effort related to configuration tracking and tuning, simplifying database backups and overall higher availability. On the other hand, sometimes clustering setup and ongoing operation can add complexity to the environment, which may offset the benefits.
How have you approached MySQL database sprawl? What has your experience been with MySQL clustering?
