Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Thumbs down Unanswered: High Data Replication

    Hi

    I have a replica with a primary server and secundary server, I am executing a select in primary server but this server fail or is down, I need this select connect to secundary server automatically. ¿What to do for this activity? ¿You can give me an example, please?

    Thank you for you help.

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    What kind of situation do you think?
    1. the primary server is already down when you execute query
    2. the primary server goes down in time of executing the query

  3. #3
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311

    Cool

    The processes of redirection over HDR enviroment work this way:
    - If the primary server is down, the client will lost the connection and the current transaction will abort, the program must be prepared to handle with this situation. When it try reconnect to server again will be automatic redirect to secondary server...

    To work this way you must set your SQLHOSTS (server and client) some like this:
    Code:
    ids_master group - -  c=0
    ids_primary onsoctcp  hostA portX 
    ids_secondary onsoctcp hostB portX
    On client environment:
    - You must set the INFORMIXSERVER = ids_master
    - Set INFORMIXCONTIME and INFORMIXCONRETRY proper (this variables config the timeout and how many time try to connect).

    When your client try to conect , will follow the order of the servers, if the first is off line, it just jump to next...
    The parameter c=0 is not necessary because is the default option.... but i like to specify...

    If you have more instances listed on the same SQLHOSTS, add the options e= or g= .
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  4. #4
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Thumbs down

    the primary server goes down in time of executing the query

  5. #5
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    then, the conection will be broken and transaction will abort...

    if you really need user query keep running... start to think in a HARDWARE cluster....
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  6. #6
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Thumbs down

    I need an example for this.

    Directing Clients Automatically with DBPATH

    Thank you for you help.

  7. #7
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    I already tried use DBPATH with a 4GL program to do this redirection... unfortunately doesn't work and I don't know why...

    If work with you.. please.. post here how you do...
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •