On October 13, 2011 01:11:26 AM Simon 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! > > 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. >
I would say, like others, just take the filesystem backup for general backup needs LVM snapshots can give you very fast restores to recover from deleted messages or other application-level issues. They obviously don't protect against storage failures. There's nothing wrong with taking backups in multiple ways to meet different recovery objectives, though. If you find yourself doing frequent restores to bring back user data, then the LVM snapshots could be a very helpful addition to your regular backups. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
