Shulou(Shulou.com)06/03 Report--

This article mainly explains "what are the advantages of MySQL 8.0.27 formal GA". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the advantages of MySQL 8.0.27 formal GA?"

Three months later, the latest version of MySQL, 8.0.27, was officially GA on October 19, 2021. This is a maintenance version of MySQL8.0, which not only fixes 207Bug, but also adds some new features:

Multi-factor authentication function. MySQL supports up to three methods of validating accounts, which can be enabled when users are created or changed. The command line client can specify multiple passwords using the-- password1,-- password2,-- password3 options. Users can use this feature to authenticate multiple user passwords in key operations at the same time, so as to prevent the occurrence of excessive authority of a single user or misoperation. In addition, this feature of MySQL Enterprise Edition also supports verification using smart cards, security keys, and biometric card readers, which are based on the Fast Identity Online (FIDO) standard.

To improve the ability to monitor MySQL and troubleshoot, Performance_Schema supports exporting metric thread names (non-mysqld) to the operating system, similar to Unix's ps execution.

A new system variable authentication_policy is introduced to support multi-factor authentication. The original variable default_authentication_plugin is degraded and will be deleted in the future.

The system variable group_replication_components_stop_timeout is used to specify how long to wait for a component that is still in progress to complete an operation when group replication is turned off. The previous default value was 31536000 (365days), which did not have the desired effect, but the new default value was changed to 300s. 5 minutes after the group replication component stops, if the situation is not resolved (there are still components that have not completed the operation), allow members to restart and rejoin.

Multithreaded replication is enabled by default, and a multithreaded replication application has many application threads that execute transactions in parallel.

The asynchronous connection failover mechanism for MySQL replication enables replicas to use group replication (single master mode), where other group members can connect to the sender again when the primary member fails. In other words, MySQL supports group replication using single master mode (primary members are used to accept logs) as replicas of asynchronous replicas, and when the primary member fails, other members can connect to the replication source again. Use this feature to configure asynchronous replication between two replication groups and to support connection failover.

Thank you for reading, the above is the content of "what are the advantages of MySQL 8.0.27 formal GA". After the study of this article, I believe you have a deeper understanding of the advantages of MySQL 8.0.27 formal GA, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.