On Mar 2, 2012, at 11:08 AM, "mail...@securitylabs.it" <mail...@securitylabs.it> wrote:
> Il 02/03/2012 16:32, Reindl Harald ha scritto: >> because i can write my own admin-backends and have a FULL SQL driven >> mailsystem with replication slave what can be used for postfix >> as fallback / load balancer > Just like me, web interface in php/mysql to manage domains and users, the > difference is that the db is very small as it does not contains emails, just > "configuration". > >> how do you do your backups? > Bacula with Accurate backup >> i stop the slave per cron, make the backup with rsync >> and start the slave again having a 100% consistent >> copy > You need two server or at least two MySQL instance only to obtain a backup. >>> You don't have to backup a big database, just many small files >> and you can make a 100% constistent backup pf this >> many small files while the service is running? > Sure, Maildir does not lock files to work. >> so you can restore easy and capillar, how you restore one message or one >> mailbox with dbmail? >> simply connect to the backup-machine running a second instance >> parallel to the replication-slave and drag whatever message >> whereever i like > The slave is replicated, so if you have to restore a mailbox deleted on the > master the data has already been deleted on the slave (otherwise it's not a > replication), you have to restore the entire db from a previous backup. > > For sure the big advantage is that replication is easy and you can make an > active/passive system so that if the active note crashes you can be online in > a few seconds without using clustered file system, network file system and so > on. I won't be storing for long term and won't require backing up either. It's more for custom php to query the emails that I receive. The influx of email will only grow over time. Writing perl scripts to look at flat txt files I feel will be too much over head on the server. Where in a db it will be organized and easy to query for information. In my perspective any ways. Unless I'm convinced otherwise …
