PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. Because of this, a one-time device registration step is required before FIDO authentication can occur. Note FIDO pluggable authentication is an extension ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Alternatively, to set and persist the firewall setting at runtime: SET PERSIST mysql_firewall_mode = OFF; SET PERSIST mysql_firewall_mode = ON; SET PERSIST sets a value for the running MySQL instance. Invoke sp_set_firewall_mode() again, this time ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
If all types are temporal, the result is temporal: If all temporal types are DATE, TIME, or TIMESTAMP, the result is DATE, TIME, or TIMESTAMP, respectively. Otherwise, for a mix of temporal types, the result is DATETIME. The second syntax returns ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
If the --skip-grant-tables option was specified at server startup to disable the MySQL privilege system, FLUSH PRIVILEGES provides a way to enable the privilege system at runtime. This operation is a very convenient way to get backups if you have a ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
At startup, and at runtime when FLUSH PRIVILEGES is executed, the server checks user table rows. password_last_changed is a TIMESTAMP column indicating when the password was last changed. If the password is past its lifetime (assessed using the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. In other words, the transactions applied on s1 up to the point in time that s2 joined the group have been replicated to s2. At this point, the group has one ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
As of MySQL 8.0.29, you can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that are running when you use the function. For the timeout to work, all members of the group must be at MySQL 8.0.29 or higher. Specify 0 for no ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
For example: SELECT group_replication_set_communication_protocol("8.0.16"); The group_replication_set_communication_protocol() function is implemented as a group action, so it is executed at the same time on all members of the group. If a member ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
As state transfer from the binary log is based on classic asynchronous replication, it might take a very long time if the server joining the group does not have the group's data at all, or has data taken from a very old backup image. This minimizes ... Whenever a member joins or rejoins a replication group, it must catch up with the transactions that were applied by the group members before it joined, or while it was ...