Listing Thumbnail

    MySQL 8.1 on Windows Server 2016 support by Hanwei

     Info
    AWS Free Tier
    This product has charges associated with it for seller support. MySQL 8.0 is a very exciting new version of the world's most popular open source database, with comprehensive improvements. Some key enhancements include: SQL window functions, common table expressions, NOWAIT and SKIP LOCKED, descending index, grouping, regular expressions, character sets, cost models, and histograms. JSON extension syntax, new features, improved sorting, and partial updates. By using JSON table functions, you can utilize SQL mechanisms for JSON data. GIS geographic support. Spatial Reference System (SRS), as well as SRS perception of spatial data types, spatial indexes, and spatial functions.
    Listing Thumbnail

    MySQL 8.1 on Windows Server 2016 support by Hanwei

     Info

    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. Capture the output of EXPLAIN FORM=JSON, add the 'Into' option to EXPLAIN FORM=JSON, and save the JSON format output in a user variable.

    2. Keep client comments, MySQL 8.1 keeps MySQL client comments. If you need to use the previous behavior, you need to use the -- skip comments option

    3. MySQL Replication changes the default value of SOURCE-RETR_COUNT in the CHANGE REPLICATION SOURCE TO statement to 10. This means that, using this option and the default value of SOURCEVNet RETRY (60), the replica waits for 60 seconds between reconnection attempts and attempts to reconnect for 10 minutes at this rate before timeout and failover.

    4. Before selecting a new master node, the group_deplication_ct_as_primary() function needs to wait for all ongoing DDL statements before completing all transactions.

    5. The MySQL version number used in version specific comments now supports major versions consisting of one or two digits, which means that the entire version can now be five or six digits long.

    6. Strengthen the logs of the server shutdown process. With the increase of startup and shutdown messages for MySQL servers, plugins, and components, strengthen the logs of the shutdown process. Additional features should help troubleshoot and debug issues, especially when the server takes a long time to shut down.

    7. Added SHOW PARSE_TREE statement, which displays the JSON format parse tree of the select statement. This sentence is only used for testing and development, not for production. It is only used for debugging versions

    8. Added the tls certificates forsed validation system variable, allowing DBAs to enforce certificate validation when the server is started or when reloading certificates at runtime using the ALTERNATE INSTANCE RELOAD TLS statement. After enabling enforcement, if a certificate is found to be invalid, server calls will be stopped at startup to prevent invalid certificates from being loaded at runtime and a warning will be issued.

    9. Added some state variables specific to group replication plugins, which can improve the diagnosis and troubleshooting of network instability, providing statistical information about network usage, control messages, and data messages for each group member.

    10. Added a server system variable to control the amount of time MySQL accounts connected to MySQL servers using LDAP pluggable authentication must wait when the LDAP server is shut down or unresponsive. For the following simple and SASL based LDAP authentication variables, the new default timeout is 30 seconds, and connection and response timeouts can only be configured through system variables on the Linux platform. For more information, please refer to Setting Timeout for LDAP Plug in Authenticatio

    Highlights

    • In terms of user management, a system variable "validate_password.changed_characters_percentage" has been added for password verification. This variable is used to configure the number of characters that a user must modify when changing a password, calculated as a percentage of the number of characters in the current password. Assuming the variable value is set to 50, at least half of the characters in the new password need to be modified.
    • In terms of MySQL auditing, a new function has been added. When installing the audit plugin, you can specify the database where the user stores the log filter conditions.
    • In addition, MySQL Audit adds new functionality to use the scheduler component to configure and execute recurring tasks to refresh the memory cache.

    Details

    Delivery method

    Delivery option
    64-bit (x86) Amazon Machine Image (AMI)

    Latest version

    Operating system
    Win2016 server 2016

    Typical total price

    This estimate is based on use of the seller's recommended configuration (t3.medium) in the US East (N. Virginia) Region. View pricing details

    $0.16/hour

    Features and programs

    Financing for AWS Marketplace purchases

    AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
    Financing for AWS Marketplace purchases

    Pricing

    MySQL 8.1 on Windows Server 2016 support by Hanwei

     Info
    Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time. Alternatively, you can pay upfront for a contract, which typically covering your anticipated usage for the contract duration. Any usage beyond contract will incur additional usage-based costs.
    Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator  to estimate your infrastructure costs.

    Usage costs (540)

     Info
    • ...
    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

    Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .

    Content disclaimer

    Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.

    Usage information

     Info

    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.

    Similar products

    Customer reviews

    Ratings and reviews

     Info
    0 ratings
    5 star
    4 star
    3 star
    2 star
    1 star
    0%
    0%
    0%
    0%
    0%
    0 AWS reviews
    No customer reviews yet
    Be the first to write a review for this product.