Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-adding-binlog-master.html
These steps assume that binary logging is enabled on the source (which is the default), the replica is using TABLE based replication applier metadata repositories (which is the default in MySQL 8.4), and that you have enabled a replication user and ...Use a CHANGE REPLICATION SOURCE TO statement to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-adding-gtid-master.html
These steps assume you have enabled GTIDs for transactions on the sources using gtid_mode=ON, created a replication user, ensured that the replica is using TABLE based replication applier metadata repositories, and provisioned the replica with data ...Use CHANGE REPLICATION SOURCE TO to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the replica's connection metadata repository and applier metadata repository, which are the default in MySQL 8.4. Multi-source replication is not compatible with the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options.html
A set of quick-reference tables providing basic information about these options and variables is also included. The following sections contain information about mysqld options and server variables that are used in replication and for controlling ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-gr.html
Group Replication requires every table that is to be replicated by the group to have a defined primary key, or primary key equivalent where the equivalent is a non-null unique key. You may set the REQUIRE_TABLE_PRIMARY_KEY_CHECK option of the CHANGE ... You can also use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). Semisynchronous replication is implemented using plugins, which must be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-worker.html
On a multithreaded replica, the Performance Schema tables replication_applier_status_by_coordinator and replication_applier_status_by_worker show status information for the replica's coordinator thread and applier worker threads respectively. For a ...
https://dev.mysql.com/doc/refman/8.4/en/replication.html
Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database. Replication enables data from one MySQL database server (known as a source) to be copied to one or more MySQL database ...
https://dev.mysql.com/doc/refman/8.4/en/scheduler-component.html
At startup, the scheduler component registers the performance_schema.component_scheduler_tasks table, which lists the currently scheduled tasks and some runtime data about each one. Note The scheduler component is included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.