Data Replication

Question

I like to replicate real time data from AWS RDS oracle to Azure db. Please advise how can I achieve it?

Answer 1

Hi Chockalingam Pazhani, Darani •,

Greetings!!

It sounds like you're looking to replicate real-time data from AWS RDS (Oracle) to an Azure database. Here's a general approach you could try:

1. Choose a Target Azure Database: Identify whether you want to replicate data into Azure Database for MySQL, Azure Database for PostgreSQL, Azure Database for MariaDB, or another Azure database service.
2. Use Data-in Replication:
   • If you're using Azure Database for MySQL or MariaDB, you can set up Data-in Replication to sync data from your AWS RDS.
   • For MySQL, ensure that SSL is configured properly, firewall rules are set to allow communication, and the server has a public IP or DNS that is publicly accessible.
3. Set Up Binary Log-Based Replication:
   • Utilizing the binary log (binlog) feature available in MySQL and MariaDB, you can create a replication link between your AWS RDS and Azure.
   • Follow the steps in the Azure documentation to configure this properly.
4. Considerations: Be aware of the considerations and limitations specified in the documentation linked above. For example, ensure that the master server allows both inbound and outbound traffic on the necessary ports.
5. Monitoring and Troubleshooting: Once setup, monitor replication status and handle any latency issues that might arise by consulting the appropriate troubleshooting guides.

I hope this information helps. Please do let us know if you have any further queries.