Search Results
https://dev.mysql.com/doc/refman/8.4/en/rebuilding-tables.html
For example, an error in a collation might have been corrected, necessitating a table rebuild to update the indexes for character columns that use the collation. This section describes how to rebuild or repair tables or indexes, which may be ...
https://dev.mysql.com/doc/refman/8.4/en/replica-io-thread-states.html
Waiting to reconnect after a failed master event read Waiting to reconnect after a failed source event read An error occurred while reading (due to disconnection). The following list shows the most common states you see in the State column for a ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-relaylog.html
If a replica uses the default host-based relay log file names, changing a replica's host name after replication has been set up can cause replication to fail with the errors Failed to open the relay log and Could not find target log during relay log ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
When the feature is disabled, you do not need to configure the replication channel on the secondary group members, but if the primary goes offline or into an error state, replication stops for the channel. You can use the asynchronous connection ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-load-data.html
If you need to recover from a replication error involving a LOAD DATA INFILE operation logged in statement format, and the replicated event is trusted, you could grant the FILE privilege to the PRIVILEGE_CHECKS_USER account temporarily, removing it ... LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O (receiver) thread.
https://dev.mysql.com/doc/refman/8.4/en/replication-features-partitioning.html
When the replica's copy of the table is partitioned but the source's copy is not, statements that act directly on partitions cannot be run on the source without causing errors there. Replication is supported between partitioned tables as long as ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
If an upgraded replication source server still has old replicas using MySQL versions that do not support multiple triggers, an error occurs on those replicas if a trigger is created on the source for a table that already has a trigger with the same ... With statement-based replication, triggers executed on the source also execute on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-views.html
Trying to do so when row-based logging is in effect causes an error. Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to the replica even if the view contains a table that would normally ...