MySQL 5.7 is GAed on 10/2/2015 with version 5.7.9. This version provides the following main new features [2]:
New Datatypes
New Datatypes
- Supports a native JSON type.
- InnoDB now supports MySQL-supported spatial data types.
- MySQL now enables database administrators to establish a policy for automatic password expiration.
- InnoDB supports data-at-rest encryption (referred to as InnoDB tablespace encryption). The feature is enabled with the ENCRYPTION option when creating or altering an InnoDB table. This feature relies on a keyring plugin for encryption key management. (As of MySQL5.7.11)
- Supports rebuilding regular and partitioned InnoDB tables using online DDL (ALGORITHM=INPLACE) for the following operations: OPTIMIZE TABLE, ALTER TABLE ... FORCE, ALTER TABLE ... ENGINE=INNODB (when running on an InnoDB table). Online DDL supports reducing table rebuild time and permits concurrent DML, which helps reduce user application downtime.
- ALTER TABLE now supports a RENAME INDEX clause that renames an index. The change is made in place without a table-copy operation.
- VARCHAR size may be increased using an in-place ALTER TABLE (InnoDB)
- Strict SQL mode for transnational storage engines (STRICT_TRANS_TABLES) is now enabled by default.
- Multiple triggers are supported per table.
- XA stands for “eXtended Architecture”, and is a standard created by The Open Group for distributed transaction processing. While MySQL 5.0 was the first version to support XA, MySQL 5.7 has removed major limitations.[1]
- Changing the replication master without STOP SLAVE
- Support Multi-source replication
- Parallel Replication: Replicate transactions in parallel even when a single schema is used. [3]
Resources
- Improvements to XA Support in MySQL 5.7 (MySQL Sever Blog)
- Complete list of new features in MySQL 5.7
- Estimating potential for MySQL 5.7 parallel replication, by Stephane Combaudon (Blog)
Created 10/22/2015, Last Updated: 1/5/2016