I'm using this setup with SDS and connection manager for years now with any problem.
Setting up connection manager can be somewhat tricky but it works.
When done, your SDS secondary will be promoted to primary in case the original primary fails and users/apps will be directed to
new primary server
Works like a charm
Regards
Rainer
------------------------------
Rainer von Bongartz
------------------------------
Original Message:
Sent: Thu October 08, 2020 09:09 AM
From: John Smith
Subject: High availibity on same storage
Thanks Art
so i understand that we can have one primary server and one SDS server, with users/apps connecting to them trought a connect manager
am i right ?
and what are the best practices please, can SDS be used safely ? no majors issues ?
------------------------------
John Smith
Original Message:
Sent: Thu October 08, 2020 07:57 AM
From: Art Kagel
Subject: High availibity on same storage
John:
Yes, what you want is SDS Shared Disk Secondary Servers.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on 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.
Original Message:
Sent: 10/8/2020 6:57:00 AM
From: John Smith
Subject: High availibity on same storage
Hi,
for informix replication technology, like HDR, RSS, we need a a copy of the db (dbspaces, chunks)
what informix replication technologies we don't need a db storage for ?
SDS ? maybe others ?
the need is similar to Oracle RAC
thanks :)
#Informix