Johnny Ljunggren wrote:
William Yu wrote:
What I'm not sure about though is what would happen with 2 slaves if
main goes down AND the connection between center 1 & 2 is also
disconnected. Others with more experience with the various
master/slave replication solutions might want to chime in no
> William Yu wrote:
>> Johnny Ljunggren wrote:
>>
>>> 1. Replication - multimaster
>>> I'll try to explain the setup to the best of my ability:
>>> Three centers:
>>> Main center - database with a backup database
>>> Center 1 - database with a backup database
>>> Center 2 - database with a backup d
William Yu wrote:
Hmm, okay. We're now looking at another, simpler, way to do it. The
same setup but the clients on Center 1/2 will connect directly to the
Main center (2Mb leased line). The databases on Center 1/2 will then
just be a replica of the Main databases.
The biggest issue though is
Johnny Ljunggren wrote:
Hmm, okay. We're now looking at another, simpler, way to do it. The same
setup but the clients on Center 1/2 will connect directly to the Main
center (2Mb leased line). The databases on Center 1/2 will then just be
a replica of the Main databases.
The biggest issue thou
On Mon, Nov 14, 2005 at 06:02:03PM +0100, Johnny Ljunggren wrote:
> Scott Ribe wrote:
> >>From what I understand this will be possible but I may need to roll my
> >>own replication code to handle data conflict issues? Especially since
> >>center 1/2 may be down at the same time and then might chang
Scott Ribe wrote:
From what I understand this will be possible but I may need to roll my
own replication code to handle data conflict issues? Especially since
center 1/2 may be down at the same time and then might change the same data.
How do the tools for this compare against the ones from Oracl
William Yu wrote:
Johnny Ljunggren wrote:
1. Replication - multimaster
I'll try to explain the setup to the best of my ability:
Three centers:
Main center - database with a backup database
Center 1 - database with a backup database
Center 2 - database with a backup database (same as center 1)
hi johny,
would pgreplicator help ... i am not sure if it would solve your
purpose but may be you want to look at it ... it does offer multimaster
replication ...
thanks,
vishOn 11/11/05, William Yu <[EMAIL PROTECTED]> wrote:
Johnny Ljunggren wrote:> 1. Replication - multimaster> I'll try to exp
Johnny Ljunggren wrote:
1. Replication - multimaster
I'll try to explain the setup to the best of my ability:
Three centers:
Main center - database with a backup database
Center 1 - database with a backup database
Center 2 - database with a backup database (same as center 1)
Application on the t