Home icon

Querying and writing to MySQL and MariaDB from Amazon Aurora and Amazon RDS for PostgreSQL using the mysql_fdw extension, Part 2: Handling foreign objects

Database Blog

This article discusses using the MySQL Foreign Data Wrapper (mysql_fdw) extension in PostgreSQL to query and interact with MySQL and MariaDB databases across different Amazon RDS and Aurora environments.

  • Allows importing entire database schemas or selective tables between PostgreSQL and MySQL
  • Supports creating foreign tables with subset of columns from remote databases
  • Enables writing data to remote MySQL databases through foreign tables
  • Provides options for materializing foreign tables to improve query performance
  • Supports creating views on top of foreign tables and vice versa

The extension facilitates cross-database operations, data integration, and migration between PostgreSQL and MySQL/MariaDB databases with minimal complexity.

Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Jan 14
2025
Migrate spatial columns from Oracle to Amazon Aurora PostgreSQL or Amazon RDS for PostgreSQL using AWS DMS
Dec 30
2024
Dynamic data masking in Amazon RDS for PostgreSQL, Amazon Aurora PostgreSQL, and Babelfish for Aurora PostgreSQL
Jan 10
2025
Amazon RDS for MariaDB supports Innovation Release 11.7 in Amazon RDS Database Preview Environment
Nov 26
2024
Amazon RDS for PostgreSQL, MySQL, and MariaDB now supports M8g and R8g database instances

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.