Oracle GoldenGate - The best logical replication tool in the market.
September 17, 2019
Oracle GoldenGate - The best logical replication tool in the market.
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle GoldenGate
Oracle GoldenGate is used widely across the organization. We use it for heterogeneous replication, active-active and active hot standby, and offloading reporting.
- Oracle's new AutoCDR (conflict detection and resolution) feature makes setting up active-active replication fairly easy. We were able to setup active-active replication using the AutoCDR feature in a very short time.
- We had plans for separating reporting and ingestion from our primary DW system. This system generates an excess of 1TB of redo during ingestion. GoldenGates coordinated replicate helped us achieve this almost impossible task with ease.
- In my previous workplace, for a large telecom company, we had to publish data from the store of records as a service. We used GoldenGate BigData adapters to replicate data to a Kafka endpoint.
- For quick application failovers, we use GoldenGate Active-Passive replication with connection failover defined in the WebLogic connection settings.
- There are certain challenges using the product when the redo generation is in excess of about 120G per hour.
- For large transaction (more than 10 million records per commit), extract get slower. Some other replication tools do such activities better.
- Ability to recreate large transaction without breaking the transaction into individual statements may help. There are ways to make this transaction faster, but having the ability to replicate a statement as it was issued on the source may be helpful in some cases.
- We were able to provide a completely partitioned highly available active-active environment to allow for our critical application to stay continuously available.
- For our critical data warehouse, which is required to generate compliance reports for the government, we were able to offload a heavy reporting workload to a different database using GoldenGate, which helped us generate our compliance reports in time.
It wasn't easy to set up replication to a message queue using SharePlex. We had challenges using the product when the application was doing a lot of "rollbacks to savepoint". SharePlex always showed a lag.
When I was testing SharePlex, there was no way to offload the workload from the DB server while using it.
When I was testing SharePlex, there was no way to offload the workload from the DB server while using it.
Do you think Oracle GoldenGate delivers good value for the price?
Yes
Are you happy with Oracle GoldenGate's feature set?
Yes
Did Oracle GoldenGate live up to sales and marketing promises?
Yes
Did implementation of Oracle GoldenGate go as expected?
Yes
Would you buy Oracle GoldenGate again?
Yes