Re: Simple HDR question
--0__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5 Content-type: multipart/alternative; Boundary="1__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5" --1__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi. If the HDR pair is up, then the secondary is in read-only mode. However= , if the primary server is down, then the secondary can switch to operate in= a "standard" mode, which will allow updates. If and when the primary is online again (as primary server), and the standard (secondary) server i= s switch back to a secondary server, then HDR pair will resync so that updates from the secondary (standard) server will be applied to the pri= mary server. thanks. davis. = "Dirk Moolman" = <DirkM@mxgroup.co = .za> = To Sent by: <informix-list@iiug.org> = owner-informix-li = cc st@iiug.org = Subj= ect Simple HDR question = 02/04/2004 01:40 = AM = = = = = Does the replicant (secondary) of an HDR system allow updates ? We are planning to use HDR in a couple of months, and this question pop= ped up in my mind yesterday ... Dirk Moolman Database and Unix Administrator MXGROUP "People demand freedom of speech as a compensation for the freedom of thought which they seldom use." -Kierkegaard |----------------------------------------------------------------------= ----| | = | | << ella for Spam Control >> has removed 1105 Spam messages and set= | | aside 199 Newsletters for me = | | You can use it too - and it's FREE! www.ellaforspam.com = | | = | |----------------------------------------------------------------------= ----| = --1__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Hi.<br> <br> If the HDR pair is up, then the secondary is in read-only mode. However= , if the primary server is down, then the secondary can switch to opera= te in a "standard" mode, which will allow updates. If and whe= n the primary is online again (as primary server), and the standard (se= condary) server is switch back to a secondary server, then HDR pair wil= l resync so that updates from the secondary (standard) server will be = applied to the primary server.<br> <br> thanks. davis.<br> <br> <img src=3D"cid:10__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Dirk Moolman&= quot; <DirkM@mxgroup.co.za>">"Dirk Moolman" <DirkM@m= xgroup.co.za><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE4A= 3DFF5CEC58f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"Dirk Moolman" <DirkM@mxgroup.co.z= a></font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">02/04/2004 01:40 AM</font></ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2"><informix-list@iiug.org></font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Simple HDR question</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE4A3DFF5= CEC58f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE4A3DFF5CEC58f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <font face=3D"Courier New">Does the replicant (secondary) of an HDR sys= tem allow updates ?</font><br> <font face=3D"Courier New@@D
Davis, I think that this would result in lost transactions. Any transaction on the original primary that had not made it to the secondary when the disconnect occured would have rolled back on the secondary when it became standard. All work done on the primary past that point would be lost also. ER is a bit different, however. M.P. "Davis Kwong" <dkwong@us.ibm.com> wrote in message news:bvrg5a$p47$1@terabinaries.xmission.com... > > --0__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5 > Content-type: multipart/alternative; > Boundary="1__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5" > > --1__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5 > Content-type: text/plain; charset=US-ASCII > Content-transfer-encoding: quoted-printable > > > > > > > Hi. > > If the HDR pair is up, then the secondary is in read-only mode. However= > , if > the primary server is down, then the secondary can switch to operate in= > a > "standard" mode, which will allow updates. If and when the primary is > online again (as primary server), and the standard (secondary) server i= > s > switch back to a secondary server, then HDR pair will resync so that > updates from the secondary (standard) server will be applied to the pri= > mary > server. > > thanks. davis. > > > > = > > "Dirk Moolman" = > > <DirkM@mxgroup.co = > > .za> = > To > Sent by: <informix-list@iiug.org> = > > owner-informix-li = > cc > st@iiug.org = > > Subj= > ect > Simple HDR question = > > 02/04/2004 01:40 = > > AM = > > = > > = > > = > > = > > > > > > Does the replicant (secondary) of an HDR system allow updates ? > > > We are planning to use HDR in a couple of months, and this question pop= > ped > up in my mind yesterday ... > > > > > > > Dirk Moolman > Database and Unix Administrator > MXGROUP > > > "People demand freedom of speech as a compensation for the freedom of > thought which they seldom use." > -Kierkegaard > > > > > |----------------------------------------------------------------------= > ----| > | = > | > | << ella for Spam Control >> has removed 1105 Spam messages and set= > | > | aside 199 Newsletters for me = > | > | You can use it too - and it's FREE! www.ellaforspam.com = > | > | = > | > |----------------------------------------------------------------------= > ----| > > > = > > --1__=08BBE4A3DFF5CEC58f9e8a93df938690918c08BBE4A3DFF5CEC5 > Content-type: text/html; charset=US-ASCII > Content-Disposition: inline > Content-transfer-encoding: quoted-printable > > <html><body> > <p>Hi.<br> > <br> > If the HDR pair is up, then the secondary is in read-only mode. However= > , if the primary server is down, then the secondary can switch to opera= > te in a "standard" mode, which will allow updates. If and whe= > n the primary is online again (as primary server), and the standard (se= > condary) server is switch back to a secondary server, then HDR pair wil= > l resync so that updates from the secondary (standard) server will be = > applied to the primary server.<br> > <br> > thanks. davis.<br> > <br> > <img src=3D"cid:10__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" width=3D= > "16" height=3D"16" alt=3D"Inactive hide details for "Dirk Moolman&= > quot; <DirkM@mxgroup.co.za>">"Dirk Moolman" <DirkM@m= > xgroup.co.za><br> > <br> > <br> > > <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= > > <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE4A= > 3DFF5CEC58f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= > th=3D"40%"> > <ul> > <ul> > <ul> > <ul><b><font size=3D"2">"Dirk Moolman" <DirkM@mxgroup.co.z= > a></font></b><font size=3D"2"> </font><br> > <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> > <p><font size=3D"2">02/04/2004 01:40 AM</font></ul> > </ul> > </ul> > </ul> > </td><td width=3D"60%"> > <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= > > <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= > 0__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= > 1" width=3D"58" alt=3D""><br> > <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= > 100%"><img src=3D"cid:30__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" = > border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> > <font size=3D"2"><informix-list@iiug.org></font></td></tr> > > <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= > 0__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= > 1" width=3D"58" alt=3D""><br> > <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= > 100%"><img src=3D"cid:30__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" = > border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> > </td></tr> > > <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= > 0__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= > 1" width=3D"58" alt=3D""><br> > <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= > h=3D"100%"><img src=3D"cid:30__=3D08BBE4A3DFF5CEC58f9e8a93df938@us.ibm.= > com" borde