Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-interface.html
In the event of source failure, all transactions committed on the source have been replicated to the replica (saved to its relay log). When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
It also saves the value, causing it to carry over to subsequent server restarts. Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges ...
https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html
As an alternative to SHOW BINLOG EVENTS, use the mysqlbinlog utility to save the binary log to a text file for later examination and analysis. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/doc/refman/8.4/en/tuning-trace-purging.html
Using optimizer_trace_offset and optimizer_trace_limit, which are restrictions at the trace producer level, provide better (greater) speed and (less) memory usage than setting offsets or limits at the trace consumer (SQL) level with SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
It also saves the value, causing it to be used for subsequent server restarts. Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. See Section ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
The output can be saved in a file and reloaded later using mysql to recreate the dumped objects. Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information ...
https://dev.mysql.com/doc/refman/8.4/en/windows-and-ssh.html
This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL account. Either do a remote forward (Set local_port: 3306, remote_host: ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.encrypted-binlog-relaylog.html
The replication master key is then put into a keyring data file, which is encrypted with the user password supplied with the option --encrypt-password, and then saved under the meta folder in the backup with the name keyring_kef. MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-backup.html
The command also requires the use of the --backup-dir option to supply a temporary folder to save the backup metadata (including the mysqlbackup message log, the start and end LSN, and so on) and some temporary output. The backup operations are the ...