On Wed, 30 Nov 2011 15:14:33 +0000 (UTC), Walter Hurry <walterhu...@lavabit.com> wrote:
>On Wed, 30 Nov 2011 09:11:49 +0100, Robert Schetterer wrote: > >> Am 30.11.2011 09:06, schrieb Matus UHLAR - fantomas: >>> On 30.11.11 00:17, Alex wrote: >>>> I have two fedora15 boxes that process mail for a few domains, and >>>> recently set up bayes in mysql for each of them. The servers are in >>>> geographically different locations, a few hops from each other. Since >>>> they both process mail for the same domains, I thought it made sense >>>> to share the database between them. >>>> >>>> What's the best way to do this? Set one as a master and the other as a >>>> slave, or perhaps replication between them? >>>> >>>> I also thought about something like drbd, but that seems a bit >>>> excessive for just a database. >> >> dont use drbd with mysql store, you dont need it >>> >>> I think this is question for MySQL mailing list, not for SA. >>> >> you can use i.e master-master replication ( which i do ), but be aware >> you might get doubles with bayes store, this should be ignored >> >> but i am told PostgreSQL is better in replacation stuff > >Why replicate? Why not just share the same database? No failover with shared. Distributed adds redundancy. KR Nigel
