Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-row-searches.html
If no matching record is found, it returns the error ER_KEY_NOT_FOUND and stops the replication applier thread. If there are any unmatched rows remaining in the hash table, the algorithm returns the error ER_KEY_NOT_FOUND and stops the replication ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...
https://dev.mysql.com/doc/refman/9.7/en/replication-multi-source-monitoring.html
The error codes and messages that are issued when multi-source replication is enabled specify the channel that generated the error. row *************************** CHANNEL_NAME: source_1 GROUP_NAME: SOURCE_UUID: 046e41f8-a223-11e4-a975-0811960cc264 ... To monitor the status of replication channels the following options exist: Using the replication Performance Schema ...
https://dev.mysql.com/doc/refman/9.7/en/replication-problems.html
If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for messages. If you cannot tell from the error log what the problem was, try the following techniques: Verify that the ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rbr-usage.html
When replica_exec_mode is IDEMPOTENT, a failure to apply changes from RBL because the original row cannot be found does not trigger an error or cause replication to fail. MySQL uses statement-based logging (SBL), row-based logging (RBL) or ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules.html
Filtering rules are applied before performing any privilege checks; if a transaction is filtered out, no privilege check is performed for that transaction, and thus no error can be raised by it. If a replication source server does not write a ...
https://dev.mysql.com/doc/refman/9.7/en/replication-solutions-scaleout.html
Start by creating a wrapper library or module that implements the following functions: safe_writer_connect() safe_reader_connect() safe_reader_statement() safe_writer_statement() safe_ in each function name means that the function takes care of ...
https://dev.mysql.com/doc/refman/9.7/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. The message lists the following statistics for the relevant ... On a ...
https://dev.mysql.com/doc/refman/9.7/en/reset-persist.html
If the variable is not present in the file, an error occurs. RESET PERSIST [[IF EXISTS] system_var_name] RESET PERSIST removes persisted global system variable settings from the mysqld-auto.cnf option file in the data directory. Removing a ...
https://dev.mysql.com/doc/refman/9.7/en/row-subqueries.html
An error occurs if the subquery produces multiple rows because a row subquery can return at most one row. Thus, the following query fails with a syntax error: SELECT * FROM t1 WHERE ROW(1) = (SELECT column1 FROM t2) Row constructors are legal in ...
https://dev.mysql.com/doc/refman/9.7/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...