PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Setting the SQL Mode The Most Important SQL Modes Full List of SQL Modes Combination SQL Modes Strict SQL Mode Comparison of the IGNORE Keyword and Strict SQL Mode For answers to questions often asked about server SQL modes in MySQL, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
Prior to MySQL 8.0.19, the functions treat string arguments as binary strings (which means they do not distinguish lettercase), and string return values are binary strings. If a MySQL Enterprise Data Masking and De-Identification function is invoked ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. Attempting to add another server to a group with 9 members causes the request to join to be refused. This limit has been identified from testing and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions.html
The functions described in the following sections are used with Group Replication.
https://dev.mysql.com/doc/refman/8.0/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 example, if a member is running MySQL 5.7.26 then that is the version of the Group Replication plugin. For optimal ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-failover.html
In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication channel. This means that the ndb_apply_status table contains information for the replica on this host as well as for any ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
The following functions, which are available from MySQL 8.0.22 for standard source to replica replication and from MySQL 8.0.23 for Group Replication, enable you to add and remove replication source servers from the source list for a replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions.html
The functions described in the following sections are used with MySQL Replication. GTID_SUBTRACT() Return all GTIDs in set that are not in subset. MASTER_POS_WAIT() Block until the replica has read and applied all updates up to the specified ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
When a tablespace is encrypted, a tablespace key is encrypted and stored in the tablespace header. When an application or authenticated user wants to access encrypted tablespace data, InnoDB uses a master encryption key to decrypt the tablespace key. The decrypted version of a tablespace key never changes, but the master encryption key can be changed as ... InnoDB supports data-at-rest ...