0 Replies Latest reply on Sep 30, 2013 2:53 AM by Mandar Kulkarni

    Transparent failover of the database

    Mandar Kulkarni Newbie

      I am using JBoss 7.2, an enterprise application communicating with a PostgreSQL Database.

      I would like to know, if it is possible to transparently fail over to a replicated Slave DB in case of a failure of a primary DB server.

      It is possible to automate the process so that secondary server(replicated slave) starts functioning as a primary server in case of a failure of the original primary server.But I am not sure if it's possible to redirect app server's connections to point to a new host ?

       

      Even if app server supports transparent failover, what happens to existing connections in the pool ?