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

The kernel compatibilities of PolarDB for MySQL is explained as follows:

  • Complies with ANSI/ISO SQL standards. PolarDB for MySQL 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.
  • PolarDB for MySQL 5.7 and 8.0 supports the native JSON data types that comply with RFC 7159 and ECMA-262 standards.