Re: Bayes database in mysql on multiple servers

2011-12-01 Thread Michael Scheidell
On 12/1/11 10:06 AM, Benny Pedersen wrote: does not make sense so hire a unix programmer to help you understand. -- Michael Scheidell, CTO o: 561-999-5000 d: 561-948-2259 >*| *SECNAP Network Security Corporation * Best Mobile Solutions Product of 2011 * Best Intrusion Prevention Product

Re: Bayes database in mysql on multiple servers

2011-12-01 Thread Benny Pedersen
On Thu, 1 Dec 2011 01:01:04 -0500, Michael Scheidell wrote: sed -i '' -e '/INSERT INTO bayes_seen/s/INTO/IGNORE INTO/' MySQL.pm ALTER TABLE `bayes_seen` ENGINE = INNODB no, that won't do anything (I use engine = innodb), what has innodb have to do with replication collisions? innodb is

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Michael Scheidell
On Wed, 30 Nov 2011 08:23:59 -0500, Michael Scheidell wrote: sed -i '' -e '/INSERT INTO bayes_seen/s/INTO/IGNORE INTO/' MySQL.pm (hey SA folks.. any reason not to just put that into 3.4.0? won't hurt anything, will it?) or simply just ALTER TABLE `bayes_seen` ENGINE = INNODB no, that

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Benny Pedersen
On Wed, 30 Nov 2011 08:23:59 -0500, Michael Scheidell wrote: sed -i '' -e '/INSERT INTO bayes_seen/s/INTO/IGNORE INTO/' MySQL.pm (hey SA folks.. any reason not to just put that into 3.4.0? won't hurt anything, will it?) or simply just ALTER TABLE `bayes_seen` ENGINE = INNODB

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Walter Hurry
On Wed, 30 Nov 2011 08:25:43 -0800, John Hardin wrote: > On Wed, 30 Nov 2011, Walter Hurry wrote: >> 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 unre

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread John Hardin
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

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Nigel Frankcom
On Wed, 30 Nov 2011 15:14:33 + (UTC), 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 rec

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Walter Hurry
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 >>> g

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Matus UHLAR - fantomas
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 be

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Michael Scheidell
Hi all, 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 da

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread Robert Schetterer
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

Re: Bayes database in mysql on multiple servers

2011-11-30 Thread 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 mad

Bayes database in mysql on multiple servers

2011-11-29 Thread Alex
Hi all, 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 dat