Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

MySQL 8.0 on Windows Server 2022 support by Hanwei

MySQL 8.0 on Windows Server 2022 support by Hanwei

By: Hanwei Software Technology Latest Version: v8.0
Windows
Windows

Product Overview

This is a repackaged software product wherein additional charges apply for seller support, as well as licensing fees paid to AWS. The additional cost is applicable to the extended support of 24-hour response time.

  1. Performance: MySQL 8.0 is twice as fast as MySQL 5.7. MySQL 8.0 brings better performance in the following areas: read/write workloads, IO intensive workloads, and high competition ("hot spot" competition issues) workloads.

  2. NoSQL: MySQL has been providing NoSQL storage functionality since version 5.7, and this feature has also been greatly improved in version 8.0. This feature eliminates the need for an independent NoSQL document database, while MySQL document storage also provides multi document transaction support and complete ACID compliance for JSON documents in schema less mode.

  3. Window Functions: Starting from MySQL 8.0, a concept called window functions has been added, which can be used to implement several new query methods. The window function is similar to collection functions such as SUM() and COUNT(), but it does not merge multiple rows of query results into one row, but instead places the results back into multiple rows. Window functions do not require GROUP BY.

  4. Hidden indexes: In MySQL 8.0, indexes can be "hidden" and "displayed". When hiding an index, it will not be used by the query optimizer. We can use this feature for performance debugging, such as hiding an index first and then observing its impact on the database. If the database performance has decreased, it indicates that the index is useful, and then it can be 'restored to display'; If there is no visible change in database performance, it indicates that this index is redundant and can be considered for deletion.

  5. Descending index: MySQL 8.0 provides support for sorting indexes in descending order, and values in this index will also be sorted in descending order.

  6. Common Table Expressions (CTE): When using embedded tables in complex queries, using CTE makes the query statement clearer.

  7. UTF-8 encoding: Starting from MySQL 8, use utf8mb4 as the default character set for MySQL.

  8. JSON: MySQL 8 has significantly improved its support for JSON by adding the JSON.ETRACT() function, which extracts data from JSON fields based on path query parameters, as well as the JSON_ARRAYAG() and JSON_oBJECTAG() aggregation functions, which are used to combine data separately into JSON arrays and objects.

  9. Reliability: InnoDB now supports atomicity of table DDL, which means that the DDL on InnoDB tables can also achieve transaction integrity, either by rolling back in failure or committing successfully, without the problem of partial success during DDL. In addition, it also supports crash safe feature, where metadata is stored in a single transaction data dictionary.

  10. High Availability: InnoDB clusters provide integrated native HA solutions for your databases.

  11. Security: Improvements to OpenSSL, new default authentication, SQL roles, password strength, authorization.

Version

v8.0

Operating System

Windows, Windows Server 2022 Base server

Delivery Methods

  • Amazon Machine Image

Pricing Information

Usage Information

Support Information

Customer Reviews