mysql

Installing Munin on CentOS to monitor MySQL and Apache

I'll make this guide quick and straight to the point. Follow these steps and Munin will be up and collecting stats quickly.

Prerequisites:
Apache and MySQL

Assumptions:
You are monitoring the same server that munin is installed on, The server's name is server1.example.com., /var/www = document root

MySQL Database Export and Import

Here's a couple quick tips to help you export and import a MySQL database. This is great when you're looking to move servers or just make backups of the data. I know lots of people use phpMyAdmin to manage their MySQL servers (as do I). But sometimes you need to get at large amounts of data. Web based apps won't cut it. You'll need shell access (ssh).

Syndicate content