Re: Backup MXs and databases

2012-09-04 Thread Marcio Merlone
Em 03-09-2012 20:06, Andrew Beverley escreveu: On Mon, 2012-09-03 at 23:56 +0200, Titanus Eramius wrote: So, I guess my question is: How do you, good and experienced folks, keep your backup MXs updated? I've looked at two solutions so far: MySQL Replication +1 for mysql replication for backup

Re: Backup MXs and databases

2012-09-04 Thread Reindl Harald
Am 04.09.2012 14:07, schrieb Titanus Eramius: >> for postfix lookup tables you have usually a very simple >> database scheme with very few changes and 99.9% of all >> queries are readonly because postfix does even not need >> any write permissions to the database (and does not have >> it in any o

Re: Backup MXs and databases

2012-09-04 Thread Titanus Eramius
On Tue, 04 Sep 2012 01:50:42 +0200 Reindl Harald wrote: > > Like this > > http://www.iheavy.com/2012/04/26/bulletproofing-mysql-replications-with-checksums/ > > * mixed transactional and non-transactional tables > not relevant in this context > why would someone mix innodb/myisam a database

Re: Backup MXs and databases

2012-09-03 Thread Reindl Harald
Am 04.09.2012 01:15, schrieb Titanus Eramius: >> where do you see a risk of silent data corruption? >> >> if this would be the case it would be simply >> impossible have a omplete dbmail-database running >> on a replication salve over 3 years with a lot of >> foreign constraints and a major schem

Re: Backup MXs and databases

2012-09-03 Thread Titanus Eramius
On Tue, 04 Sep 2012 00:39:08 +0200 Reindl Harald wrote: > Am 03.09.2012 23:56, schrieb Titanus Eramius: > > > > MySQL Replication, which seems a bit dodgy, with the risk of silent > > data corruption. > > where do you see a risk of silent data corruption? > > if htis would be the case it would

Re: Backup MXs and databases

2012-09-03 Thread Andrew Beverley
On Mon, 2012-09-03 at 23:56 +0200, Titanus Eramius wrote: > So, I guess my question is: How do you, good and experienced folks, > keep your backup MXs updated? > > I've looked at two solutions so far: > MySQL Replication +1 for mysql replication for backup mail servers. It's been pretty reliable

Re: Backup MXs and databases

2012-09-03 Thread Reindl Harald
Am 03.09.2012 23:56, schrieb Titanus Eramius: > Hello good folks > > I have recently brought my very first mailserver online, and have been > testing it for the past month or so. Since the setup needs to be > redundant, I have also brought a secondary mailserver online on it's own > domain, and