Continues Replication between RDS MYsql to Keyspace Cassandra

Question

Want to know which AWS service will help me to transfer data from RDS to Keyspaces Cassandra on real time basis.
#Case
I am using RDS MYSQL as a production database and i have also created a read replica for the same. Now i want that as and when new data updated on my database then it automatically transferred to keyspace cassandra for further use.

Accepted Answer

You probably need to use AWS DMS service. The path should be MySQL->DMS->Kinesis->Lambda->Keyspace.
However you can also check, maybe DMS has build in support for Keyspaces as a target

Answer

Often when moving from relational to non relational you will need to transform your relational model in third normal form to NoSQL  denormalized form. Mapping tables one for one will most likely not work if your current access patterns are dependent on performing JOINS.  Having a technology that allows you to make custom transformations will be the most helpful. Like others I would recommend using DMS to extract data from RDS to Kinesis. From there you can use a number of compute options to transform and insert the data into Keyspaces.    See the following github repo for examples on how to connect and write data to Keyspaces. https://github.com/aws-samples/amazon-keyspaces-examples

Continues Replication between RDS MYsql to Keyspace Cassandra

Contenuto pertinente