1.4 What Is New in MySQL 9.7

This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 9.7 since MySQL 9.6. A companion section lists MySQL server options and variables that have been added, deprecated, or removed in MySQL 9.7; see Section 1.5, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 9.7”.

• Features Added or Changed in MySQL 9.7

• Features Deprecated in MySQL 9.7

• Features Removed in MySQL 9.7

Features Added or Changed in MySQL 9.7

The following features have been added to MySQL 9.7:

• Four-part exact release identity.  Beginning with MySQL 9.7.4, MySQL Server now exposes an exact release identity in MAJOR.MINOR.PATCH.UPDATE form so that separately delivered updates on the same patch line can be distinguished. The update component is always present on update-aware interfaces, including when its value is 0. Use VERSION_WITH_UPDATE(), the version_with_update system variable, or mysqld --version-with-update to obtain the full value. Existing interfaces such as VERSION(), version, and mysqld --version continue to return the three-part compatibility version. The mysql_upgrade_history audit file records exact-release transitions in a nested update_history array without changing compatibility checks.

  See mysql_upgrade_history File for more information.

Features Deprecated in MySQL 9.7

The following features are deprecated in MySQL 9.7 and may be removed in a future series. Where alternatives are shown, applications should be updated to use them.

For applications that use features deprecated in MySQL 9.7 that have been removed in a later MySQL version, statements may fail when replicated from a MySQL 9.7 source to a replica running a later version, or may have different effects on source and replica. To avoid such problems, applications that use features deprecated in 9.7 should be revised to avoid them and use alternatives when possible.

• SCRAM-SHA-1 authentication.  The SCRAM-SHA-1 authentication method for SASL LDAP authentication is deprecated as of MySQL 9.5.0. Use SCRAM-SHA-256 instead; this is also now the default value for authentication_ldap_sasl_auth_method_name.

  See Section 8.4.1.6, “LDAP Pluggable Authentication”, for more information.

Features Removed in MySQL 9.7

The following items are obsolete and have been removed in MySQL 9.7. Where alternatives are shown, applications should be updated to use them.

For MySQL 9.6 applications that use features removed in MySQL 9.7, statements may fail when replicated from a MySQL 9.6 source to a MySQL 9.7 replica, or may have different effects on source and replica. To avoid such problems, applications that use features removed in MySQL 9.7 should be revised to avoid them and use alternatives when possible.

• Server system and status variables removed.  Server system and status variables removed in MySQL 9.7 are shown in the following list:

  • group_replication_allow_local_lower_version_join

  • replica_parallel_type