Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-25 Thread Cédric Villemain
Le vendredi 25 septembre 2009, Selena Deckelmann a écrit : > On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain > > wrote: > > Le jeudi 24 septembre 2009, Selena Deckelmann a écrit : > >> Hi! > >> > >> On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery > > > > wrote: > >> > Hi, > >> > I'm looking

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Grant Maxwell
On 25/09/2009, at 12:50 PM, Selena Deckelmann wrote: On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain wrote: Le jeudi 24 septembre 2009, Selena Deckelmann a écrit : Hi! On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery > wrote: Hi, I'm looking for a way to replicate am master database t

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Selena Deckelmann
On Thu, Sep 24, 2009 at 8:09 AM, Cédric Villemain wrote: > Le jeudi 24 septembre 2009, Selena Deckelmann a écrit : >> Hi! >> >> On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery > wrote: >> > Hi, >> > I'm looking for a way to replicate am master database to multiple (100+) >> > databases that ar

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Joshua Tolley
On Thu, Sep 24, 2009 at 05:09:26PM +0200, Cédric Villemain wrote: > > Bucardo is a good choice for this usage model because it was > > originally designed to work over a lossy network connections. > > yes, but isn't bucardo designed to 2 nodes only ? Bucardo's multi-master replication works only

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Cédric Villemain
Le jeudi 24 septembre 2009, Selena Deckelmann a écrit : > Hi! > > On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery wrote: > > Hi, > > I'm looking for a way to replicate am master database to multiple (100+) > > databases that are taken in to the field. Currently for each laptop we > > dump and

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Selena Deckelmann
Hi! On Wed, Sep 23, 2009 at 10:11 AM, Bryan Montgomery wrote: > Hi, > I'm looking for a way to replicate am master database to multiple (100+) > databases that are taken in to the field. Currently for each laptop we dump > and load the tables. However,there is only a small percentage of data that

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Alexey Klyukin
Hi, On Wed, Sep 23, 2009 at 8:11 PM, Bryan Montgomery wrote: > Hi, > I'm looking for a way to replicate am master database to multiple (100+) > databases that are taken in to the field. Currently for each laptop we dump > and load the tables. However,there is only a small percentage of data that

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Sam Mason
On Wed, Sep 23, 2009 at 06:00:03PM -0400, Bryan Montgomery wrote: > Thanks for the reply. This is a one way push to the slaves. In theory, there > shouldn't be any conflicts although I wouldn't swear to that. If > there's a conflict, the master db should win. At the moment we just drop the > t

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Bryan Montgomery
Thanks for the reply. This is a one way push to the slaves. In theory, there shouldn't be any conflicts although I wouldn't swear to that. If there's a conflict, the master db should win. At the moment we just drop the tables, recreate the schema and reload the tables. However, some of the lar

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-23 Thread Scott Marlowe
On Wed, Sep 23, 2009 at 11:11 AM, Bryan Montgomery wrote: > Hi, > I'm looking for a way to replicate am master database to multiple (100+) > databases that are taken in to the field. Currently for each laptop we dump > and load the tables. However,there is only a small percentage of data that > ch

[GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-23 Thread Bryan Montgomery
Hi, I'm looking for a way to replicate am master database to multiple (100+) databases that are taken in to the field. Currently for each laptop we dump and load the tables. However,there is only a small percentage of data that changes on a frequent basis. I've been looking around and come across