DX Application Performance Management

Expand all | Collapse all

But what about CA APM DB?  Failover with Postgres

Jump to Best Answer
  • 1.  But what about CA APM DB?  Failover with Postgres

    Posted 02-17-2015 01:49 PM

    Has anyone used the PostgreSQL 9.2 Database Cluster feature and had CA APM/CEM connected to a PostgreSQL cluster (one database, multiple hosts)

     

    PostgreSQL: Documentation: 9.2: Creating a Database Cluster

     

    Found references to High Availability, Load Balancing and Replication

    PostgreSQL: Documentation: 9.2: High Availability, Load Balancing, and Replication

     

    25.1 Comparison of Different Solutions

    http://www.postgresql.org/docs/9.2/static/different-replication-solutions.html

     

    So there seems to be some functionality within the Postgresql 9.2 version but the question is, has anyone attempted, was successful/failed and what issues or discoveries did you make during your travels down this path?

     

     


    Reference:

    Fail Over - Protect the MoM, the Collectors can deal



  • 2.  Re: But what about CA APM DB?  Failover with Postgres

    Posted 03-25-2015 01:15 AM

    *Bump*

     

    Hi We are also looking at this and have enabled EM failover and looking to configure postgres as a hot standby - is this a supported solution ?

     

    As it stands with the EM in hot standby when the primary EM stops the secondary EM takes over - but in the case where you lose the whole server - would the secondary EM know to connect to the secondary postgres db ?



  • 3.  Re: But what about CA APM DB?  Failover with Postgres
    Best Answer

    Posted 03-27-2015 05:21 AM

    Hi Andy,


    I think you can make a postgres HA and configure DNS server for EMs to point to the second postgres in case of failover but this is not a supported solution. We support Oracle RAC as APM DB and it has the failover mechanism. So, Oracle RAC seems to be an alternative approach.


    Regards,

    Mukesh Singh



  • 4.  Re: But what about CA APM DB?  Failover with Postgres

    Posted 03-27-2015 07:01 AM

    Thank you Mukesh Singh.

     

     

    Is the Oracle RAC as APM DB for fail over tested, certified and supported by CA?

     

    This is part of the larger question on APM fail over.

     

    Thank you,

    Billy