PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0), and that you have enabled a replication user and ...Use the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/refman/8.0/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 the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-configuration.html
In these tutorials, we assume that you have two sources source1 and source2, and a replica replicahost. A multi-source replication topology requires at least two sources and one replica configured. The replica replicates one database from each of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. Options and variables for use on sources and replicas are covered separately, as are options and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
Removing Channel Specific Replication Filters When channel specific replication filters have been configured, you can remove the filter by issuing an empty filter type statement. This section explains how to work with replication filters when ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
The statement is not executed until all table-level options (if any) have also been checked, and the outcome of that process permits execution of the statement. When evaluating replication options, the replica begins by checking to see whether ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. One or more database options were found, and were evaluated to arrive at an “execute” condition ...
https://dev.mysql.com/doc/refman/8.0/en/replication-security.html
Privilege checks are implemented by setting up a PRIVILEGE_CHECKS_USER account, which MySQL uses to verify that you have authorized each specific transaction for that channel. To protect against unauthorized access to data that is stored on and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-installation.html
To verify this, check that the value of the have_dynamic_loading system variable is YES. You cannot have both the new and the old versions of the relevant plugin installed on an instance. Semisynchronous replication is implemented using plugins, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
If, in the case of a CSV table, you execute this statement: mysql> ALTER TABLE csvtable ENGINE='MyISAM'; This statement is replicated; the table's engine type on the replica is converted to InnoDB, even if you have previously changed the table type ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...