Almost done with my centos handbook project on my server.
Last two things are related, backups.
Looking for anyone who feels like chiming in on mysql backups...this is
what I am thinking at this point.
Mysql backup system for all websites
----------------------------------------------------
Each website is on a separate server, each running mysql, no site is
related to the others.
A server will be built (VM) that will host mysql.
I believe the way to do this is as follows...
1- make a separate instance of mysql on the backup server equal to the
number of websites I am going to backup
2- set up each website's mysql to be a Master
3- set up each instance of mysql on the backup to be a slave to its
website Master
4- run them all at the same time, replication from master to slave
5- on the backup / slave mysql instances run logs, back up by day, dump
daily
I believe, not sure, this will work. Not sure if a better way.
The replication allows for a full and almost up to the second copy
should a corruption happen on the Master.
The daily log files and dumps on the backup server allow for rebuild due
to hacker attack.
The backup server handling the dumps prevents any issue with the website
mysql and the web application.
From there, amanda will grab those backup log and dumps to add to each
site's file backups.
And that is the logic of what I think I can do with this. Trying to back
up multiple websites files, logs, and mysql.
Amanda will do all but the mysql.
sound right?
This is the last big step before I start writing the chapters out for
the book. Hope to get it done within a month or two after the backup
system is done.
any thoughts appreciated.
