Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
To use encryption, a keyring plugin must be installed and configured to supply MySQL Server's keyring service. Any supported keyring plugin can be used to store binary log encryption keys. Startup Options Used with Binary Logging System Variables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
As an alternative to creating a new replica in this way, MySQL Server's clone plugin can be used to transfer all the data and replication settings from an existing replica to a clone. Follow this procedure to set up replication with existing data: ...Before you proceed, ensure that you have: Configured the source with the necessary configuration ...
https://dev.mysql.com/doc/refman/8.4/en/reset-persist.html
To remove a specific persisted variable from mysqld-auto.cnf, name it in the statement: RESET PERSIST system_var_name; This includes plugin system variables, even if the plugin is not currently installed. RESET PERSIST [[IF EXISTS] system_var_name] ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. These include ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | SOURCE_LOG_FILE = 'log_name', SOURCE_LOG_POS = log_pos | RELAY_LOG_FILE = 'log_name', RELAY_LOG_POS = log_pos | SQL_AFTER_MTS_GAPS } ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meters.html
For example, to update the frequency of the mysql.inno metrics: mysql>update performance_schema.setup_meters set FREQUENCY='30' where name = 'mysql.inno'; The maximum number of meter instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-configuration.html
Server Configuration Client Configuration Client Configuration Example Server Configuration The following are the server trace telemetry configuration variables: telemetry.trace_enabled System Variable telemetry.trace_enabled Scope Global Dynamic ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
thread_pool_max_transactions_limit: The maximum number of transactions permitted by the thread pool plugin. When the thread pool plugin starts, it creates one thread per group (the listener thread), plus the background thread. The thread pool ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & If there are encrypted InnoDB tablespaces, use the --early-plugin-load option to load the keyring plugin. This section describes how to upgrade MySQL binary and ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several functions. These variables are ...