Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source.html
This is because the server IDs of replicas must be unique in a replication topology. Multi-source replication in MySQL 8.4 enables a replica to receive transactions from multiple immediate sources in parallel. You might choose to implement ...In a ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
For a server where binary logging is enabled (log_bin is ON), RESET BINARY LOGS AND GTIDS deletes all existing binary log files and resets the binary log index file, resetting the server to its state before binary logging was started. For a server ... Note This statement takes the place of the old RESET MASTER statement, which is no longer ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of service. MySQL uses security based on ... Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
When a user connects to the server and authenticates successfully, the server determines which roles to activate as the default roles. If the activate_all_roles_on_login system variable is enabled, the server activates all granted roles. The server ... SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
A server that participates in a group in single-primary mode should use skip_replica_start=ON. Otherwise, the server is not allowed to join a group as a secondary. The password cannot be encrypted, but it is masked in the query log. If you do not ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-install.html
This section describes the installation of the server and client OpenTelemetry support. Installing Client Plugin The Telemetry plugin for the MySQL client can be enabled with a command line switch, --telemetry_client or from a configuration option, ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool.html
MySQL Enterprise Edition includes MySQL Enterprise Thread Pool, implemented using a server plugin. The default thread-handling model in MySQL Server executes statements using one thread per client connection. The thread pool controls the number of ... Note MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition, a commercial ...The thread ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-installation.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. To uninstall the validate_password component, use this statement: UNINSTALL COMPONENT ...For ... This section describes how to install and uninstall the validate_password password-validation ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encrypted-innodb-options.html
For details on how MySQL Server encrypts and decrypts these items, see InnoDB Data-at-Rest Encryption and Encrypting Binary Log Files and Relay Log Files . MySQL Enterprise Backup supports encrypted InnoDB tablespaces and encrypted binary/relay ...