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.
