about DRAUTO
Posted in 2011
joe (IDS 11.5) asked about DRAUTO. Art Kagel said it was removed in 7.31 because a brief communication loss could leave two primaries, and was later restored for sites with reliable links. He recommended the Connection Manager on 11.xx instead. He confirmed the worst case is rebuilding the secondary from an archive.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Topics: General Discussion
ids: 11.5 Is anyone set DRAUTO 1 or 2 and had any trouble ? It Seems that DRAUTO was not availabe among some ids old version and back to alive in later version. What happen with DRAUTO? New ids version solved the problem and give it new life?
DRAUTO was removed in 7.31 because it caused more trouble that it prevented. If you have one of the auto role change modes set in DRAUTO and your primary and secondary servers lost communications with each other, even briefly, but were both still online, you could end up with two primary servers. Anyway, it was brought back at some point (maybe in 9.40 or 10.00 don't remember) because some sites with absolutely reliable communications between servers wanted the functionality back. Today, with 11.xx, I would use the Connection Manager (with multiple CM instances running) to manage server failover, it is a more robust protocol than DRAUTO and isn't fooled as easily by intermittent communications. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Oct 23, 2011 at 7:40 PM, joe <joeclhua@gmail.com> wrote: > ids: 11.5 > Is anyone set DRAUTO 1 or 2 and had any trouble ? > It Seems that DRAUTO was not availabe among some ids old version and > back to alive in later version. > What happen with DRAUTO? > New ids version solved the problem and give it new life? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >
Art , For me, DRAUTO seem easier than connection manger. If I control not to allow all the clients to enter the secondary server that they don't even know the ip address or existence of secondary. All the jobs still running on the primary server even if we got two primary server owing to network failure. I guess the worst result is rebuild the HDR. Am I right ?
Sorry, I was at the IBM IOD conference last week and crazy busy. Yes, the worst case scenario is that you would have to rebuild the secondary from an archive if it becomes a second primary inadvertently. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Oct 23, 2011 at 9:42 PM, joe <joeclhua@gmail.com> wrote: > Art , > For me, DRAUTO seem easier than connection manger. > If I control not to allow all the clients to enter the secondary > server that they don't > even know the ip address or existence of secondary. > All the jobs still running on the primary server even if we got two > primary server owing to network failure. > I guess the worst result is rebuild the HDR. > Am I right ? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >