Date: 2019-09-13
Time: 16:30 - 17:20
Room: Salon 17-18
Level: Intermediate
In this talk, we are going to explore the challenges we faced while implementing the data exchange solution between MySQL database and PostgreSQL database with both databases residing on Amazon RDS instances.
Since the only foreign data wrapper supported by Amazon RDS is Postgres-to-Postgres FDW, we utilize an intermediate EC2 Postgres instance which is used as a proxy server to make this data mapping possible.
Although this solution allows for smooth data transfer in the majority of cases, we’ve faced several challenges, using it for complex queries in the OLTP database, including the inability to use MySQL indexes and data loss during transmission. In this talk, we will explain how we’ve resolved these issues.