Re: OT: MySQL Healthcheck
- From: David Robillard <david.robillard@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>, Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- Date: Tue, 26 Mar 2013 10:44:55 -0400
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.-
--
//www.freelists.org/webpage/oracle-l
Other related posts:
