MySQL Foreign Data Wrapper 2.7.0

The MySQL Foreign Data Wrapper (mysql_fdw) is a Postgres extension that allows you to access data that resides on a MySQL database from EDB Postgres Advanced Server. It is a writable foreign data wrapper that you can use with Postgres functions and utilities, or in conjunction with other data that resides on a Postgres host.

The MySQL Foreign Data Wrapper can be installed with an RPM package. You can download an installer from the EDB website.

Enhancements, bug fixes, and other changes in MySQL Foreign Data Wrapper 2.7.0 include:

Type	Description
Enhancement	MySQL Foreign Data Wrapper now supports min, max, sum, avg, and count aggregate function pushdown. You can now push aggregates to the remote MySQL server instead of fetching all of the rows and aggregating them locally. This improves performance for the cases where aggregates can be pushed down. Aggregate filters and orders are not pushed down as MySQL does not support them.
Bug Fix	Function expression deparsing implicit/explicit coercion sending wrong query to the MySQL server.
Bug Fix	Import foreign schema failure due to SET type.

• Partner Product Website

• Category Data Management & Analysis, Storage
• Highlights

  Rancher Catalog

  This icon indicates that the software is included in the Rancher Catalog.

  Rancher Extension

  This icon indicates that the software is a Rancher Extension.

  Cloud-Native Network Function

  This icon indicates that the software possesses Cloud-Native Network Functionality.

  SUSE Edge

  This partner product is certified for SUSE Edge.

  SUSE Telco Cloud

  This partner product is certified as part of SUSE Telco Cloud.

  High Availability

  This icon indicates that the software provider has flagged the compatibility of the application with the SUSE High Availability extension. Success may include the application running in an HA environment, or it may include extensions to the application to exploit and integrate with the HA feature. Please see the software provider's web site for more details.

  Integrated System Available

  This icon indicates that a pre-built, pre-configured integrated version of the application is available. This may also be called an appliance and may be packaged as a hardware appliance, a software appliance, or a virtual appliance.

  Virtualization Ready

  This icon indicates that the software provider supports the application in any of the virtualized environments that work with SUSE Linux Enterprise. These may include one or more of Xen, KVM, VMWare, or other hosting environments. Also note that virtualization support can mean that the solution can be used in the cloud environment. Please see the software provider's web site for more details concerning which environment(s) are supported by the provider.