Informix

nested-group-icon.png

DB2

Expand all | Collapse all

High availibity on same storage

  • 1.  High availibity on same storage

    Posted 23 days ago

    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 :)



  • 2.  RE: High availibity on same storage

    Posted 23 days ago
    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.








  • 3.  RE: High availibity on same storage

    Posted 23 days ago
    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
    ------------------------------



  • 4.  RE: High availibity on same storage

    Posted 23 days ago
    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
    ------------------------------



  • 5.  RE: High availibity on same storage

    Posted 23 days ago
    WITHOUT any problems of course :-)

    ------------------------------
    Rainer von Bongartz
    ------------------------------



  • 6.  RE: High availibity on same storage

    Posted 23 days ago
    Thanks a lot

    ------------------------------
    John Smith
    ------------------------------



  • 7.  RE: High availibity on same storage

    Posted 17 days ago
    Hi
    please How many concurrent users/connections ?

    ------------------------------
    John Smith
    ------------------------------



  • 8.  RE: High availibity on same storage

    Posted 23 days ago
    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


    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.








  • 9.  RE: High availibity on same storage

    Posted 23 days ago
    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
    ------------------------------



  • 10.  RE: High availibity on same storage

    Posted 17 days ago
    Hi
    please How many concurrent users/connections ?

    ------------------------------
    John Smith
    ------------------------------



  • 11.  RE: High availibity on same storage

    Posted 23 days ago
    Thanks to All

    ------------------------------
    John Smith
    ------------------------------