Posted On: Jan 5, 2018
Starting today, you can launch MariaDB version 10.2 instances on Amazon RDS. You can also easily upgrade your existing Amazon RDS for MariaDB database instances from version 10.1 to 10.2.11.
MariaDB 10.2 is the latest major version release of the popular open source database from the original developers of MySQL. It offers a number of enhancements for better performance and scalability. Some of the key new features in MariaDB 10.2 are:
- Window functions have been introduced
- The SHOW CREATE USER statement was introduced
- New CREATE USER options for limiting resource usage and tls/ssl
- New ALTER USER statement
- Non-recursive Common Table Expressions
- Recursive Common Table Expressions
- New WITH statement
- Support for CHECK CONSTRAINT
- Support for DEFAULT with expressions
- BLOB and TEXT fields can now have a DEFAULT value
- Lots of restrictions lifted for Virtual computed columns
- Number of supported decimals in DECIMAL has increased from 30 to 38
- Added catchall for list partitions
- Oracle-style EXECUTE IMMEDIATE statement
- PREPARE Statement/Dynamic SQL now understand most expressions
- InnoDB tables now support spatial indexes
- ed25519 authentication plugin
- Better InnoDB crash recovery progress reporting
- Improvements to InnoDB startup/shutdown to make it more robust
In addition, InnoDB is now the default storage engine in MariaDB. Until MariaDB 10.1, MariaDB used the XtraDB storage engine as default. A full description of the changes and improvements in MariaDB 10.2 is available here.
Amazon RDS for MariaDB 10.2 is available in all AWS Regions. To learn more about Amazon RDS for MariaDB, please refer to the RDS documentation.