Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of ...For example, if a member is running MySQL 8.4.6 then that is the version of the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
A replication group is a set of servers, each of which has a complete copy of the data (a shared-nothing replication scheme), which interact with each other through message passing. A replication group is formed by multiple servers; each server in ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/8.4/en/install-plugin.html
INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server plugin. By default, plugin_dir is the plugin directory under the directory named by the pkglibdir configuration variable, but it can be changed by setting the ...It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-aws-plugin.html
All keyring material is generated exclusively by the AWS server, not by keyring_aws. MySQL Enterprise Edition can work with keyring_aws on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Debian, Ubuntu, macOS, and Windows. MySQL Enterprise ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-general.html
A replication channel requires two MySQL servers acting as replication servers (one each for the source and replica). This means that the replication source MySQL server must be running with --binlog-format=ROW or --binlog-format=MIXED, as ...For ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
Session variables cannot be set at server startup, so there is no reason to persist them. A global system variable might involve sensitive data such that it should be settable only by a user with direct access to the server host. A global system ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”). A ...The keyring service handles the creation, retrieval, and deletion of the binary log encryption ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. Each server within a replication topology must be configured with a unique server ID, which ...Binary logging is required on the source because the binary log is the basis for replicating changes from the source to its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-slavebaseconfig.html
Each replica must have a unique server ID, as specified by the server_id system variable. If you are setting up multiple replicas, each one must have a unique server_id value that differs from that of the source and from any of the other replicas.
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
This section describes how to disable GTID transactions on servers that are already online. This procedure does not require taking the server offline and is suited to use in production. However, if you have the possibility to take the servers ...