Re: OT: MySQL Healthcheck
From: David Robillard <david.robillard_at_gmail.com>
Date: Tue, 26 Mar 2013 10:44:55 -0400
Message-ID: <CADH15GgM0Ydn3pPGSS3Yu=dKu+2C78TyexT_o6k6rU_PftbPZQ_at_mail.gmail.com>
Hello Alan,
> Hi List,
> The "OT" in the subject is because this is an Oracle list and my
question
> is (mostly) geared to MySQL.
>
> I've been asked (by a project manager) to perform a healthcheck on a
> MySQL database before we take over administration. I found myself googling
> for something as simple as a Healthcheck.
>
> Now, my question to the list is what does a MySQL healthcheck entail?
>
> I checked that the data is in a separate filesystem and that it has
> plenty of room, and some my.cnf parameters, but I'm worried about
> transaction log rotation and stuff like that. Not to mention I didn't even
> start checking if they are using innodb or if there are any MyISAM
> tables... not to mention there's no backup policy implemented yet which
> means we'll have to consider backups at a later time (which may require
> additional software).
Date: Tue, 26 Mar 2013 10:44:55 -0400
Message-ID: <CADH15GgM0Ydn3pPGSS3Yu=dKu+2C78TyexT_o6k6rU_PftbPZQ_at_mail.gmail.com>
Hello Alan,
> Hi List,
> The "OT" in the subject is because this is an Oracle list and my
question
> is (mostly) geared to MySQL.
>
> I've been asked (by a project manager) to perform a healthcheck on a
> MySQL database before we take over administration. I found myself googling
> for something as simple as a Healthcheck.
>
> Now, my question to the list is what does a MySQL healthcheck entail?
>
> I checked that the data is in a separate filesystem and that it has
> plenty of room, and some my.cnf parameters, but I'm worried about
> transaction log rotation and stuff like that. Not to mention I didn't even
> start checking if they are using innodb or if there are any MyISAM
> tables... not to mention there's no backup policy implemented yet which
> means we'll have to consider backups at a later time (which may require
> additional software).
This will sound like a plug for my blog, but I wrote an article on continuous
data protection for MySQL with
rsnapshot<http://itdavid.blogspot.ca/2013/02/mysql-backup-and-recovery.html>.
It might be a good starting point.
HTH, DA+
> Thanks in advance
> Alan.-
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 26 2013 - 15:44:55 CET