Overall Satisfaction with Oracle GoldenGate
We have multiple data centers and all of them share the same copy of DB. We use GoldenGate to do cross datacenters replication for Oracle and My SQL DBs as an HA solution. As our DBs are one of the busiest in the world and have a very tight SLA for replication lag which we can achieve by GoldenGate. We have explored few other products like SharePlex but GG done the work for us. GoldenGate is a de-facto standard for replication in our organization.
- GoldenGate is tightly integrated with Oracle databases and supports all features like encryption, LOBs, compressions etc.
- GoldenGate is very flexible, you can customize it as per your requirement. Whether it is high transaction DB or a DR site, it can work anywhere.
- We can dump data in multiple formats with big data adaptor like kafka, hdfs, xml etc.
- We can achieve high throughput by splitting extracts and replicats. Also from integrated capture and replication it is so smart that it spawn parallel process based on the load.
- Goldengate is very useful in cross platform migration.
- Memory consumption of extract is exponentially high, sometimes extract restart consumes so much memory that it impact the current application connections.
- There are so many bugs in the system for dumping data via xml or other format like hdfs. Data corruption is so frequent that we wrote our own scripts to detect and repair xml corruption. As always we didn't get proper support from Oracle on this issue.
- For active-active replication on busy systems, online DDL change can sometimes cause data discrepancy.
- With integrated capture creating index on big table is a headache even thought you are creating with via gg user. Extract starts get lagging even after skipping the DDL by gg user in param file. This was not the case with classic capture.
- GoldenGate is really helpful is providing HA solution where we can sync data between data centers and distribute load between them. In case of a site down we can redirect all connections to surviving DC.
- Most of the time the delay of Oracle GoldenGate replication is within seconds.
- We can do database upgrade without interrupting site availability.
Streams is more complex to manage and have its limitations. Also it is deprecated by Oracle.
Do you think Oracle GoldenGate delivers good value for the price?
Not sure
Are you happy with Oracle GoldenGate's feature set?
Yes
Did Oracle GoldenGate live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of Oracle GoldenGate go as expected?
Yes
Would you buy Oracle GoldenGate again?
Yes