Which technology is appropriate to keep database in sync in below architecture?

2018-02-02 21:24:58

Below is the Topology in my project :

APPServer1->Oracle DB1

LoadBalancer

APPServer2->Oracle DB2

LoadBalancer can forward request to any of the app server.Both oracle DB's are supposed to be in sync at any given point of time.

Which technology can be used to keep DB's in sync.Above architecture will be hosted on Red-hat Open-stack .Rac was the best option but red hat open-stack doesn't support this.I am exploring Golden Gate and dataguard. What other options Do I have?I am open to here to accept any architectural changes.

If both of your databases are supposed to be open for read/write access -

for load balancing in the database tier - then your only viable option is RAC (although you could setup a multimaster replication setup with GoldenGate but that is just a PITA for more than a couple of tables and will certainly lead to lots of grey hair and consumed liquor).

So, if your goal is database high availability then Dataguard is the

  • If both of your databases are supposed to be open for read/write access -

    for load balancing in the database tier - then your only viable option is RAC (although you could setup a multimaster replication setup with GoldenGate but that is just a PITA for more than a couple of tables and will certainly lead to lots of grey hair and consumed liquor).

    So, if your goal is database high availability then Dataguard is the way to go. Using a correct tnsnames.ora configuration you can setup both your application servers to connect to your primary database and failover to the standby database if necessary. If you add a third machine which acts as "Dataguard Observer" the role-change and failover between primary and standby database happens automatically without manual intervention.

    2018-02-02 23:56:22