High availibity on same storage
Answered: green (solid confidence) — SDS (Shared Disk Secondary) servers are the technology needing no extra storage copy; several users vouched for running it with a Connection Manager, and the asker thanked everyone. A trailing question about concurrent users went unanswered.
Advisory only.
Posted in 2020
John Smith asked which Informix high-availability option needs no separate copy of the data, similar to Oracle RAC. Art Kagel said SDS (Shared Disk Secondary), where secondaries can be read-only or read-write and added in seconds. Rainer von Bongartz used SDS with Connection Manager for years without problems, and Snorri Bergmann ran it without the connection manager. John then asked about concurrent users; unanswered.
Topics: High Availability & Replication, Storage & Space Management
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
John: Yes, what you want is SDS Shared Disk Secondary Servers. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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.
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 ------------------------------
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 ------------------------------
WITHOUT any problems of course :-) ------------------------------ Rainer von Bongartz ------------------------------
Thanks a lot ------------------------------ John Smith ------------------------------
John: Yes, you can have one or more SDS secondaries connected to the same sharable storage and all will be well. You can spin up additional SDS secondaries in literally seconds if more CPU or memory resources are needed. SDS secondaries can be read-only or read-write. No recently reported problems that I am aware of. See Rainer's responses. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.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 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.
John. We have been running SDS without problems for years now (versions 12 and 14). We don't use the connection manager. Best regards, -Snorri ------------------------------ Snorri Bergmann ------------------------------
Thanks to All ------------------------------ John Smith ------------------------------
Hi please How many concurrent users/connections ? ------------------------------ John Smith ------------------------------
Hi please How many concurrent users/connections ? ------------------------------ John Smith ------------------------------