ApsaraDB RDS for PostgreSQL - Supports External MySQL Table Reads and Writes
Nov 13 2019
ApsaraDB RDS for PostgreSQLContent
Target customers: all ApsaraDB RDS for PostgreSQL users whose PostgreSQL instances are required to access data from MySQL databases. Features released: ApsaraDB RDS for PostgreSQL 10 integrates the mysql_fdw extension to read data from and write data to ApsaraDB RDS for MySQL instances or user-created MySQL databases. The parallel computing feature is supported by ApsaraDB RDS for PostgreSQL since version 9.6, and is greatly enhanced in version 11. You can join billions of rows of data and query the data within several seconds. Therefore, ApsaraDB RDS for PostgreSQL is often used as a small-scale, high-concurrent data warehouse. The upcoming ApsaraDB RDS for PostgreSQL 13 will provide a column store engine to further improve analytic capabilities. You can use the mysql_fdw extension to read data from MySQL databases for analysis in your PostgreSQL instance.