Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-binlog-encryption-encryption-keys.html
The format of binary log encryption keys in the keyring is as follows: MySQLReplicationKey_{UUID}_{SEQ_NO} For example: MySQLReplicationKey_00508583-b5ce-11e8-a6a5-0010e0734796_1 {UUID} is the true UUID generated by the MySQL server (the value of ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-windows-binary.html
For management nodes and data nodes, it is not necessary to install the MySQL Server binary; however, each management node requires the management server daemon (ndb_mgmd.exe); each data node requires the data node daemon (ndbd.exe or ndbmtd.exe).
https://dev.mysql.com/doc/refman/9.7/en/replication-binlog-encryption.html
You enable this encryption on a MySQL server by setting the binlog_encryption system variable to ON. The system variable sets encryption on for binary log files and relay log files. If you deactivate encryption by changing the binlog_encryption ...
https://dev.mysql.com/doc/refman/9.7/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. If this limit is set to zero, the global max_user_connections system variable value determines the number of ...An “account” in this context corresponds to a row in the mysql.user system ...This limits the number of simultaneous connections that can be ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
It is suitable for use with MySQL Server versions 8.0 and 5.7. (WL #14207) Functionality Added or Changed Important Change: A new mechanism has been introduced for users to configure how time zone conversions should occur when time instants are ...
https://dev.mysql.com/doc/refman/9.7/en/roles.html
The mandatory_roles and activate_all_roles_on_login system variables enable defining mandatory roles and automatic activation of granted roles when users log in to the server. Defining Mandatory Roles It is possible to specify roles as mandatory by ...(These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) While locked, a role cannot be used to authenticate to the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-distributed-recovery-connections.html
Important Distributed recovery can fail if a joining member cannot correctly identify the other members using the host name as defined by MySQL Server's hostname system variable. In this situation you can use MySQL Server's report_host system ...The ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...When state transfer from the ...
https://dev.mysql.com/doc/refman/9.7/en/account-categories.html
If the user that puts a server in offline mode does not have the SYSTEM_USER privilege, connected client users who have the SYSTEM_USER privilege are also not disconnected. A role that has the SYSTEM_USER privilege cannot be listed in the value of ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...For example, the CREATE USER privilege ...
https://dev.mysql.com/doc/internals/en/x-protocol-use-cases-use-cases.html
Topics in this section: Prepared Statements with Single Round-Trip Streaming Inserts SQL with Multiple Resultsets Inserting CRUD Data in a Batch Cross-Collection Update and Delete Prepared Statements with Single Round-Trip In the MySQL ...Figure ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of ...For example, if a member is running MySQL 9.7.0 then that is the version of the Group Replication ...