slider

Tag: mysql monitoring

Monitoring MySQL Backups With Datadog and TwinDB Backup Tool

TwinDB + Datadog

Monitoring MySQL backups is a vital part of any reliable backup solution. By monitoring the most common disaster recovery metrics, the Recovery Time Objective and the Recovery Point Objective, you can find out if a backup job was successful and produced a usable backup copy. The TwinDB Backup Tool along with Datadog allows monitoring both […]

Read More

Data Loss After MySQL Restart

equipment

Not so long ago, I had a customer who experienced data loss after a MySQL restart. It was really puzzling. MySQL was up & running for many months, but after the customer restarted the MySQL server all tables have gone. The tables were still visible in the SHOW TABLES output, but they were not readable:

Read More

A Real Example Of Nagios Monitoring

It’s now time to setup proper monitoring to avoid unpleasant surprises in future. There are two major problems the monitoring solves: alerting and trending. Alerting is to notify the person in charge about a major event like service failing to work. Trending is to track the change of something over time – disk or memory […]

Read More