RDS Replica to different database

0

Hi all, I have the production MariaDB instance in RDS and I need to create a Postgres replica of it. (Asyncronous daily replication) Which service would allow me to do that? Basically what I need is a read replica, in another database type.

Marco
asked 10 months ago253 views
1 Answer
2
Accepted Answer

I would recommend that you explore AWS DMS

AWS Database Migration Service (AWS DMS) is a cloud service that makes it possible to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud or between combinations of cloud and on-premises setups

You can perform one-time migrations or replicate ongoing changes to keep sources and targets in sync.

You could run this on a daily basis to keep a 2nd type of database in sync

This may give you what you are looking for https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

profile picture
EXPERT
answered 10 months ago
profile picture
EXPERT
reviewed 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions