PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. This is useful if you want to provide an SQL interface for an in-house database. It is possible to change this when the MySQL server is started (see ...In ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
If this is unsuitable, create the error file manually with the desired access mode prior to executing mysqld_safe. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts.
https://dev.mysql.com/doc/refman/8.0/en/fips-mode.html
This includes replication (source/replica and Group Replication) and X Plugin, which run within the server. This means you have the following options, depending on system and MySQL configuration: Use a system that has OpenSSL 3.0 and the required ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-upgrade.html
From MySQL 8.0.17, this applies to upgrades between patch versions, and for lower releases, this only applies to upgrades between major versions. For earlier releases, you must set super_read_only to OFF manually on each member that should function ... During an online upgrade procedure, if the group is in single-primary mode, all the servers that are not currently offline for upgrading function as they did ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
You cannot change the value of group_replication_single_primary_mode manually while Group Replication is running. Group Replication operates either in single-primary mode or in multi-primary mode. The group's mode is a group-wide configuration ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. This is because the backup_progress table on the server is a CSV table, for which primary keys are not supported. Add a PK to the ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. However, this method is not compatible with starting Group Replication automatically, as specified by ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ip-address-permissions.html
To specify an allowlist manually, use the group_replication_ip_allowlist (MySQL 8.0.22 and later) or group_replication_ip_whitelist system variable. This address is not the same as the MySQL server SQL protocol host and port, and is not specified in ... When and only when the XCom communication stack is used for establishing group communications (group_replication_communication_stack=XCOM), the Group Replication plugin lets you specify an allowlist of hosts from which an incoming Group Communication System connection can be ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-launching.html
Otherwise, you must install the plugin manually; to do this, connect to the server using the mysql client, and issue the SQL statement shown here: mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; Important The mysql.session ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
Choose one of the following methods of upgrading a Group Replication group: Rolling In-Group Upgrade This method is supported provided that servers running a newer version are not generating workload to the group while there are still servers with ...In other words servers with a newer version can join the group only as ...