Preventing and Resolving MySQL Downtime


Preventing downtime-causing emergencies in MySQL can be difficult because they are caused by complex combinations of several things going wrong. Efforts to be proactive may be sincere, but without knowledge of the causes of emergencies, they often fail to prevent further problems. This talk will discuss some of the ways that real emergencies could have been prevented in production systems, and suggests specific actions to accomplish these
  • Application Stack Configuration
  • MySQL Server Configuration
  • Operating System Configuration
  • Troublesome Server Features
  • Special Features of Percona Server
  • MySQL Health Checks
  • Percona Toolkit