MySQL Server Maintenance

As shutting down every single web app seems too work intensive I thought about taking offline only the database server.

At my job I’m running a MySQL database server with about 45 smallish databases for a load of web apps running on different webservers. I decided to move the database files to a NetApp volume in order to configure snapshot backups with Zmanda’s zrm-mysql-enterprise. We have a maintenance window every month where the system may be down for a while. So this is no procedure for 24/7 shops.
MySQL Server Maintenance weiterlesen