Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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, ...
https://dev.mysql.com/doc/refman/8.4/en/replication-functions-async-failover.html
For the GroupReplication managed service, the identifier is the value of the group_replication_group_name system variable. For the GroupReplication managed service, the identifier is the value of the group_replication_group_name system variable. The ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/en/load-data-local-security.html
MySQL Shell's data upload utilities use LOAD DATA LOCAL INFILE statements to upload data, so the local_infile system variable must be set to ON on the target server instance. Dump loading utility util.loadDump() Import dump files created using MySQL ...The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/refman/8.4/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/8.4/en/host-cache.html
To disable DNS host name lookups, start the server with the skip_name_resolve system variable enabled. To disallow TCP/IP connections entirely, start the server with the skip_networking system variable enabled. Unblock with 'mysqladmin flush-hosts' ...The server uses the host cache for several purposes: By caching the results of IP-to-host name lookups, the server avoids doing a Domain Name System (DNS) lookup for each client ...