Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Expand all | Collapse all

High availibity on same storage

  • 1.  High availibity on same storage

    Posted 10/08/20 06:57 AM

    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


  • 2.  RE: High availibity on same storage

    Posted 10/08/20 07:58 AM
    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 10/08/20 09:09 AM
    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 10/08/20 09:17 AM
    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 10/08/20 09:18 AM
    WITHOUT any problems of course :-)

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



  • 6.  RE: High availibity on same storage

    Posted 10/08/20 09:44 AM
    Thanks a lot

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



  • 7.  RE: High availibity on same storage

    Posted 10/14/20 04:53 AM
    Hi
    please How many concurrent users/connections ?

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



  • 8.  RE: High availibity on same storage

    Posted 10/08/20 10:08 AM
    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 10/08/20 11:34 AM
    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 10/14/20 04:52 AM
    Hi
    please How many concurrent users/connections ?

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



  • 11.  RE: High availibity on same storage

    Posted 10/08/20 11:52 AM
    Thanks to All

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