CODEWITHSUNDEEP
oracle-databasecassandrareal-time
Chicharito
Chicharito

Reputation: 1440

Oracle to Cassandra real-time replication

We have an Oracle Database that resides tables. We would like to implement a new project as I mentioned in title; Oracle to Cassandra real-time replication.

But this new Cassandra environment would be as a reporting service. From the application (in-house), datas is inserted to Oracle production environment. Then our custom service (or what ever) will read delta and insert to Cassandra (this would be like Goldengate may be).

Briefly, does the Cassandra will answer our needs for this scenario?

In our case, we have 20 oracle DBs in different locations (these 20 dbs has similar implementation) 1 central report DB that is daily refresh from these 20 DBs. We use "outdated" snapshot technology, every night our central single report DB (REPORTDB) with fast refresh option, we gather the daily delta from these 20 dbs within oracle ss. we need a structure that reads data from 20 dbs and real-time injection to new cassandra database just like REPORDB

Upvotes: 0

Views: 1730

Answers (2)

Heisenberg
Heisenberg

Reputation: 5668

These days you can run spark jobs on Cassandra, thanks to Datastax so yes it can be used as a reporting tool. It's best utilized as a key value store if your number of writes are high compared to your reads.

Reading delta is not real time so you should try using Oracle's AQs. I've been doing real time replication of Oracle to Cassandra using Oracle's AQ and Apache Storm for almost 4 years now and it's running flawlessly.

Upvotes: 2

doanduyhai
doanduyhai

Reputation: 8812

I don't understand this Oracle/Cassandra architecture running alongside.

Either Oracle suits your needs then you should stick with it. Or it doesn't and you need scalability/high availability then switch to Cassandra.

Can you elaborate on the reasons that make you choose Cassandra for the reporting service ?

Upvotes: -2

Related Questions