Continues Replication between RDS MYsql to Keyspace Cassandra

0

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.

2回答
0
承認された回答

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

AWS
回答済み 2年前
  • Using DMS than kinesis will add more cost to organization. DMS not available for keyspace as target

0

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

回答済み 1年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ