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?