On Tue, 22 Oct 2013, Jonas Akrouh Larsen wrote:
I tried a couple of years ago to have my bayes DB stored in SQL replicate as
MASTER-MASTER between 2 servers.
It worked fine for starters, but it often broke down because of irregularities,
something about duplicate data/keys if I recall correctly.
That's not surprising in a master-master topology. Bayes was not designed
for that environment.
As I would like 1 single shared bayes DB, what is everyone else doing?
I would prefer the DB to be local, so 1 single shared db server isn't an option
for me.
Currently I'm contemplating splitting up reads and writes with a mysql proxy,
but im not sure that's the best option.
So do anybody have any tips or advise to offer?
Use standard master-slave replication. Learn and expire only the master
database.
I *think* we support separate credentials for learning to a different
database than you scan from, but I don't follow the Bayes SQL interface
too closely so I'm not sure.
--
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
-----------------------------------------------------------------------
Gun Control is nothing more than an attempt to return to feudalism,
where the peasants are helpless and must humbly petition their lord
and master to protect them from bandits and thieves (when they can
get around to it), and where the lords and masters can abuse the
peasants whenever they like without fear of effective resistance.
-----------------------------------------------------------------------
509 days since the first successful private support mission to ISS (SpaceX)
