On Wed, 30 Nov 2011, Walter Hurry 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?
Latency and reliability of the link between the "geographically separate
locations". Replication is typically robust in the face of unreliable
networking and high latency and will recover from outages, and most people
don't want their mail delivery system doing WAN database queries with the
associated (assumed) high latency, limited bandwidth and risk of
service interruption that is inherent in a WAN.
--
John Hardin KA7OHZ http://www.impsec.org/~jhardin/
jhar...@impsec.org FALaholic #11174 pgpk -a jhar...@impsec.org
key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79
-----------------------------------------------------------------------
There is no better measure of the unthinking contempt of the
environmentalist movement for civilization than their call to turn
off the lights and sit in the dark. -- Sultan Knish
-----------------------------------------------------------------------
15 days until Bill of Rights day
