Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
The new primary uses the source list for the channel to select the source with the highest priority (weight) setting, which might not be the same as the original source. Asynchronous connection failover for replicas is activated automatically for a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
SELECT statement is issued when row-based replication is in use (binlog_format=ROW). The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the source. This client transaction is assigned a GTID ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using it. This section provides information about restrictions on and limitations of replication with GTIDs. When using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-monitoring.html
To monitor the connection status of all channels: mysql> SELECT * FROM replication_connection_status\G; *************************** 1. To monitor the connection status of a named channel, use a WHERE CHANNEL_NAME=channel clause: mysql> SELECT * FROM ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-db-options.html
This means that you must select the default database explicitly with a USE statement in order for a DDL statement to be applied. Is there a default database (has any database been selected by USE)? Yes. When evaluating replication options, the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-partitioning.html
Important You should not use --replicate-do-db for this purpose when using statement-based replication, since statement-based replication causes this option's effects to vary according to the database that is currently selected. However, it should ... There may be situations where you have a single source server and want to replicate different databases to different ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-rbr-monitoring.html
For example to get progress for update events issue: mysql> SELECT WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current -> WHERE EVENT_NAME LIKE 'stage/sql/Applying batch of row changes (update)' If ... The current progress ...
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/request-access.html
SELECT statement, you need both the INSERT and the SELECT privileges. After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the server determines what operation you want ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
Initially, the RESOURCE_GROUPS table has these rows describing the default groups: mysql> SELECT * FROM INFORMATION_SCHEMA.RESOURCE_GROUPS\G *************************** 1. MySQL supports creation and management of resource groups, and permits ...