@Art KagelThank you for your reply.
Most of the customers I've met have used powerHA or other cluster software only to configure Informix high availability features.
Perhaps customers are more familiar with configuring using cluster software than unfamiliar programs such as informix connection manager.
(Customers may want uniformity in software configuration because they have to manage various DBMSs together.)
Of course, few customers use Informix, which consists of a connection manager and SDS server, but most customers tend to configure high-availability features with minimal cost.
So I wanted to know if connection manager was possible instead of cluster software.
I think the method using the warm standby configuration of SDS server and connection manager is the most cost effective.
Anyway, We plan to use pacemaker for cold standby configuration. :)
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Korea, Republic of
------------------------------
Original Message:
Sent: Mon May 03, 2021 05:45 AM
From: Art Kagel
Subject: Question about connection manager feature
SangGyu:
Failover to a "cold server" as in one that is not online until needed? No, not in the way you mean - to start up the cold server. The failover server has to be an HDR, RSS, SDS, or ER node that is actively online. That raises the question of why would one not take advantage of HDR for such a secondary give that there is no license cost and the hardware is already there? Why wait several minutes until an offline server can be brought online which will take several minutes for a Continuous Log Restore secondary which might be one or more logs behind the primary, or worse, several hours while a completely offline server is restored from an archive and rolled forward when you can have an HDR secondary online at near instantaneous speed with only a handful of transactions rolled back?
There is one way to point users to a cold backup server. That would be to use a GROUP in the sqlhosts file as INFORIXSERVER and have that group include the connection details for both the primary and the secondary. Connection Manager can do that also, it just cannot start up the offline server.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Sun May 02, 2021 10:15 PM
From: SangGyu Jeong
Subject: Question about connection manager feature
Hello All,
I have a question about the connection manager feature.
Is it possible to failover to a cold standby server using informix connection manager instead of using cluster software like pacemaker or PowerHA?
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Korea, Republic of
------------------------------
#Informix