Ingres Community Forums Login Register Ingres.com  

Ingres Community Forum


Go Back   Ingres Community Forums > Ingres Forums > DBA Forum
 

Reply
 
LinkBack Thread Tools Display Modes
Old 2009-07-07   #1 (permalink)
Ingres Community
 
Join Date: Jun 2008
Posts: 37
Default question about replicator?

Hello, everyone,
I use the full peer to unprotected read only peer to replicate data from Server A to standby Server B. If the Server A is disaster,can I use the standby Server B to replicate data to Server A ?
bicealyh is offline   Reply With Quote
Old 2009-07-07   #2 (permalink)
Ingres Corp
 
pickr01's Avatar
 
Join Date: Mar 2007
Posts: 108
Default

You can not replicate from an Unprotected Read source.
Configure you standby database B as FullPeer too, in this way there is nothing to do when switching to B as source - except starting the replication server on B if it is not already running(and doing nothing when A is working)

Kristoff
pickr01 is offline   Reply With Quote
Old 2009-07-07   #3 (permalink)
Ingres Community
 
Join Date: Jun 2008
Posts: 37
Default

FullPeer to FullPeer maybe many conflicts!
bicealyh is offline   Reply With Quote
Old 2009-07-07   #4 (permalink)
joe
Ingres Community
 
Join Date: Feb 2007
Posts: 159
Default

If Server B is truly a standby, normally there shouldn't be any conflicts since only Replicator should be accessing it. The only period when conflicts may arise is when, after Server A is down and Server B has been acting as the primary, Server A is restored and Server B has to replicate back to A for it to catch up. Once both are in sync, Server B should return to passive status, only receiving updates from the Rep server on A.
joe is offline   Reply With Quote

Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


© 2009 Ingres Corporation. All Rights Reserved