Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.point.html
To check if this condition has been satisfied, perform this query on the server: mysql> SHOW VARIABLES LIKE 'log_bin'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | log_bin | ON | +---------------+-------+ 1 row in ... You can restore your database server to its state at an arbitrary time using the binary log files included in the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.encrypted-binlog-relaylog.html
mysqlbackup then copies over from the server the encrypted keyring data file, which contains the replication master key used to encrypt all the passwords for the individual log files, into the meta folder in the backup and names the file keyring_kef. If the server uses a keyring plugin or component other than component_keyring_encrypted_file, mysqlbackup accesses the keyring to obtain the replication master key and uses it to decrypt the individual log files' ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-restore.html
The restore operations restores the data files from a backup to their original locations on the database server, or to other desired locations. Normally, the restoration process requires the database server to be already shut down (or, at least not ...The option datadir must be specified either in the file specified by the --defaults-file option or as a command-line ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-key-rotation.html
The binlog_rotate_encryption_master_key_at_startup system variable controls whether the binary log master key is automatically rotated when the server is restarted. If this system variable is set to ON, a new binary log encryption key is generated ...The BINLOG_ENCRYPTION_ADMIN privilege is required to issue ALTER INSTANCE ROTATE BINLOG MASTER KEY, and the statement cannot be used if the binlog_encryption system variable is set to ...You can rotate the binary log master ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
Warning Setting the max_digest_length system variable to zero disables digest production, which also disables server functionality that requires digests. To change this value, set the performance_schema_max_sql_text_length system variable at server ...The max_digest_length system variable value determines the maximum number of bytes available per session for computation of normalized statement ...The digesting process ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connection-control.html
This plugin also exposes system variables that enable its operation to be configured and a status variable that provides rudimentary monitoring information. Monitoring Failed Connection Attempts Failed connection attempts can be monitored using ...
https://dev.mysql.com/doc/refman/8.4/en/restart.html
For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables that can be set only at server startup, but the server must still be restarted for those changes to take effect. (mysqld forks, and one process ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-secure-installation.html
On Windows, this option applies only if the server was started with the named_pipe system variable enabled to support named-pipe connections. In addition, the connection must be a member of the Windows group specified by the ...Normal usage is to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-member-actions.html
The server must be writeable (with the read_only system variable set to OFF) and have the Group Replication plugin installed. If the failure of the member action is considered critical, it can be handled according to the policy specified by the ...