On Thu, 13 Oct 2011 21:11:26 +1300, Simon <[email protected]> wrote:
Hi There,
I know this has been discussed on the list off and on and i have
searched and reviewed the list for these.. but i would just like to
get peoples opinion of the best strategy to move forward with…
We have DBmail 2.2.17 running: 3 separate mail servers one for DBmail
and two for MySQL in a master/slave environment. We provide IMAP
mailboxes to our clients and have about 90-100GB worth of mail in the
DB currently and stop the slave to mysqldump the database at night
and
start it again. This works fine from a backup data point of view, we
have reasonable fast servers and a good SAN and backups work well….
Restores are another thing tho. 100GB just takes time to import!
There is no point in mysqldump-ing. On your backup slave with the MySQL
daemon switched off back up your whole /var/lib/mysql directory (make
sure you include the InnoDB log files!), and you can restore that
directly.
I have read some emails on the list about using LVM and taking
snapshots… but have not used this before. Would this be a good path
to
look? I would like to have a quick way to recover our mail platform
for our clients.
Not really necessary in your case since you have a slave you can keep
shut down for the duration of the backup. The only advantage of LVM
would be that you could shut down the DB, take a snapshot, restart the
DB, then back up from the snapshot. It would reduce your down time on
the slave, but if that's not an issue there isn't any advantage to be
gained from it.
Gordan
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
