Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-status.html
The extended output adds the status of each member server in each cluster, information about the asynchronous replication channels managed by InnoDB ClusterSet, and other configuration and status information. The command reports the status of ...
https://dev.mysql.com/doc/refman/9.7/en/alter-user.html
If count is 0 (the default), the server determines the number of simultaneous connections for the account from the global value of the max_user_connections system variable. When the read_only system variable is enabled, ALTER USER additionally ...In ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-secure-connections.html
To further harden your deployment, you can use the tls_ciphersuites variable to limit the ciphersuites that the server permits for encrypted connections that use TLSv1.3. Restart the server to apply the configuration changes: $> systemctl restart ...
https://dev.mysql.com/doc/refman/9.7/en/network-namespace-support.html
On the server side, the bind_address, admin_address, and mysqlx_bind_address system variables have extended syntax for specifying the network namespace to use for a given IP address or host name on which to listen for incoming connections. A ...
https://dev.mysql.com/doc/refman/9.7/en/backup-types.html
Backups can be performed while the MySQL server is not running. If the server is running, it is necessary to perform appropriate locking so that the server does not change database contents during the backup. Physical backup tools include the ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-configuring-instances.html
Important The group replication local address must be different to the host name and port used for SQL client connections, which are defined by MySQL Server's hostname and port system variables. Important Distributed recovery can fail if a joining ...Set the disabled_storage_engines system variable as follows to prevent their use: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Replication Framework The following settings configure replication according to the MySQL Group Replication ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-frequently-asked-questions.html
To configure MEMBER_PORT on a server, specify it using the report_port system variable. The system variables are also not modified when Group Replication is in single-primary mode, where only one server writes. However, this method is not compatible ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...This limit has been identified from testing and ...
https://dev.mysql.com/doc/refman/9.7/en/upgrading-what-is-upgraded.html
Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/9.7/en/create-user.html
If count is 0 (the default), the server determines the number of simultaneous connections for the account from the global value of the max_user_connections system variable. When the read_only system variable is enabled, CREATE USER additionally ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-howto.html
Make the servers read-only by setting the read_only system variable to ON on each server by issuing the following: mysql> SET @@GLOBAL.read_only = ON; Wait for all ongoing transactions to commit or roll back. If you are starting with new servers, ...