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.
Compared to MySQL 5.6, the new features of MySQL 5.7 mainly include the following aspects.
-
Significant improvement in performance MySQL 5.7 has significant performance improvements across all load models and has set a new benchmark record. In the Point Select query test of MySQL 5.7, the test score is more than three times that of MySQL 5.6.
-
Supports JSON JSON (JavaScript Object Notation) is a format for storing information that can effectively replace XML. Starting from MySQL 5.7, JSON will be supported. Prior to this version, JSON files could only be stored in a generic form such as strings. The drawback of this approach is that it requires self confirmation and parsing of data, solving difficulties during updates, or enduring slower speeds when performing insertion operations. In MySQL 5.7, a new data type has been added to store JSON formatted data in MySQL tables. The main benefits of native support for JSON data type are as follows: (1) Document validation: Only data segments that comply with the JSON specification can be written into columns of type JSON, which is equivalent to having automatic JSON syntax validation. (2) Efficient Access: When storing JSON documents in JSON columns, the data is not stored as plain text, but in an optimized binary format for faster access to its object members and array elements. (3) Improving performance: Creating indexes on JSON columns can enhance data query performance.
3.Performance Schema Monitoring is necessary for any data management system. The core monitoring strategy provided by MySQL is Performance Schema. The improvements to Performance Schema in MySQL 5.7 include a large number of newly added monitoring items, reduced space and load consumption, and significantly improved usability through the new SYS Schema mechanism. In terms of monitoring, Performance Schema provides the following new features: (1) Metadata Locking: Any transaction that has already started will hold the metadata lock of the table until the transaction is committed. Due to the fact that the initial transaction holds metadata locks for all tables associated with the transaction, any DDL operations cannot be performed until the previous transaction is committed. (2) Stage Tracking: Long term tracking of the progress of operations. (3) Transaction: Monitor all aspects of transactions at the service layer and storage engine layer. (4) Memory usage: By collecting information on memory usage, we can understand the consumption of memory. (5) Pre compiled statements: Provide aggregated statistical information through pre compiled statements and display pre compiled statements used by the service.
4.SYS Schema MySQL SYS Schema is a data schema consisting of a series of objects (views, stored procedures, stored methods, tables, and triggers), mainly stored in the monitoring data resources of Performance Schema and Information_SCHEMA. MySQL SYS Schema is included by default in MySQL 5.7 and provides a summary view to address the following issues: (1) Which processes occupy all the resources in the database? (2) Which hosts have the highest access to the database server? (3) Where is the memory used on the database instance?
-
Performance and Scalability Improve the scalability of InnoDB and the performance of temporary tables to achieve faster network and big data loading operations.
-
Improve replication to enhance availability performance Including multi-source replication, enhanced multi slave threading functionality, online GTIDs, and enhanced semi synchronous replication.
-
Performance mode provides a better perspective Added many new monitoring features to reduce space and overload, and significantly improved usability using the new SYS mode.
-
Improve safety With the principle of safety first, many new features are provided to ensure the security of the database.
-
Optimization Rewrite most of the parsers, optimizers, and cost models to improve maintainability, scalability, and performance.
Highlights
- MySQL has excellent performance and stability, capable of handling large-scale data and high concurrency access. Its optimized storage engine and query execution engine, as well as support for transaction processing, enable MySQL to provide efficient data processing capabilities in various application scenarios.
- MySQL supports both horizontal and vertical scaling, allowing for flexible expansion and deployment as needed. Its clustering and replication capabilities make MySQL perform well in large-scale applications and high availability scenarios.
- MySQL provides rich security features and permission controls to protect data from unauthorized access. The encryption connection, authentication, and access control mechanisms it supports provide reliable protection for user data.
Details
Typical total price
$0.16/hour
Pricing
- ...
Instance type | Product cost/hour | EC2 cost/hour | Total/hour |
---|---|---|---|
t2.nano | $0.10 | $0.008 | $0.108 |
t2.micro AWS Free Tier | $0.10 | $0.016 | $0.116 |
t2.small | $0.10 | $0.032 | $0.132 |
t2.medium | $0.10 | $0.064 | $0.164 |
t2.large | $0.10 | $0.121 | $0.221 |
t2.xlarge | $0.10 | $0.227 | $0.327 |
t2.2xlarge | $0.10 | $0.433 | $0.533 |
t3.nano | $0.10 | $0.01 | $0.11 |
t3.micro AWS Free Tier | $0.10 | $0.02 | $0.12 |
t3.small | $0.10 | $0.039 | $0.139 |
Additional AWS infrastructure costs
Type | Cost |
---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
no refunds
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Updated to the latest
Additional details
Usage instructions
You can use the "administrator" account to log in to the system through remote desktop, and then use the key to obtain the connection password. After logging in, you can use MySQL directly. There is a readme file on the desktop. Be sure to read the readme file before using MySQL. After entering the desktop and reading the readme file, open CMD and enter the mysql startup command to use mysql. After authorizing mysql remote login permissions, you can use other database management tools to connect and operate the database
Resources
Vendor resources
Support
Vendor support
For product technical support, please contact prosupport@hanweie.com
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.