ApsaraDB PolarDB MySQL-compatible edition is fully compatible with native MySQL and ApsaraDB RDS for MySQL. Youcan migrate data from MySQL to ApsaraDB PolarDB MySQL-compatible edition without modifying code or configurations of your applications.

The kernel compatibilities of ApsaraDB PolarDB MySQL-compatible edition is explained as follows:

  • Complies with ANSI/ISO SQL standards. ApsaraDB PolarDB MySQL-compatible edition allows you to enable the ANSI session mode by setting the sql_mode parameter of your cluster to ANSI. For more information about how to modify the cluster parameters, see Specify cluster parameters.
  • Supports Open Database Connectivity (ODBC) versions 0 to 3.51.
  • Supports XML features that comply with W3C and XPath standards.
  • ApsaraDB PolarDB MySQL-compatible edition 5.7 and 8.0 supports the native JSON data types that comply with RFC 7159 and ECMA-262 standards.