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 réponses
0
Réponse acceptée

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
répondu il y a 2 ans
  • 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

répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions