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-monitoring.html
Note The SHOW VARIABLES statement does not work with multiple replication channels. To monitor the status of replication channels the following options exist: Using the replication Performance Schema tables. This enables you to write complex ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-reset-replica.html
The RESET REPLICA statement can be used to reset a multi-source replica. By default, if you use the RESET REPLICA statement on a multi-source replica all channels are reset. Optionally, use the FOR CHANNEL channel clause to reset only a specific ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html
Note Each channel on a multi-source replica must replicate from a different source. MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in parallel. In a multi-source replication topology, a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, see Section 19.1.3, “Replication with Global Transaction Identifiers”.
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note The last warning was repeated N times in last S seconds is written to the error log. The “safeness” of a statement ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
As noted in Section 19.5.1.31, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based format or (from MySQL 8.0.4) mixed format. MySQL uses statement-based logging (SBL), row-based logging (RBL) or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
Note Only DML statements can be logged using the row format. When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that apply. When using --binlog-do-db ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-examples.html
It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging format. If you use a combination of database-level and table-level replication filtering options, the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
Note Statements that update the information in the mysql system schema, such as GRANT, REVOKE and the manipulation of triggers, stored routines (including stored procedures), and views, are all replicated to replicas using statement-based ...For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync-interface.html
As noted above, the source should not be reused after the failover. When you install the source and replica plugins for semisynchronous replication (see Section 19.4.10.1, “Installing Semisynchronous Replication”), system variables become ...