Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slaveinit.html
To set up the replica to communicate with the source for replication, configure the replica with the necessary connection information. To do this, on the replica, execute the following CHANGE REPLICATION SOURCE TO statement, replacing the option ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-configuration.html
A multi-source replication topology requires at least two sources and one replica configured. In these tutorials, we assume that you have two sources source1 and source2, and a replica replicahost. The replica replicates one database from each of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
In addition to the built-in asynchronous replication, MySQL 8.4 supports an interface to semisynchronous replication that is implemented by plugins. You can improve the performance of semisynchronous replication by enabling the system variables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
Use MySQL Server's clone plugin to transfer all the data from an existing replica to a clone. If the source database contains existing data it is necessary to copy this data to each replica. There are different ways to dump the data from the source ...
https://dev.mysql.com/doc/refman/8.4/en/reserved-accounts.html
One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data Directory”). During data directory initialization, MySQL creates user accounts that should be considered reserved: ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
To use RESET REPLICA on a Group Replication group member, the member status must be OFFLINE, meaning that the plugin is loaded but the member does not currently belong to any group. RESET REPLICA [ALL] [channel_option] channel_option: FOR CHANNEL ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Resource Group Restrictions On some platforms or MySQL server configurations, resource groups are unavailable or have limitations: Resource groups are unavailable if the thread pool plugin is installed. MySQL supports creation and management of ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
A role when created is locked, has no password, and is assigned the default authentication plugin. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
If the plugin directory is writable by the server, it may be possible for a user to write executable code to a file in the directory using SELECT ... This can be prevented by making plugin_dir read only to the server or by setting secure_file_priv ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration-validation.html
As such, the configuration check does not initialize storage engines and other plugins, components, and so forth, and does not validate options associated with those uninitialized subsystems. MySQL supports a --validate-config option that enables ...