Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
If multiple types of filters (do_db, do_ignore_table, wild_do_table, and so on) are specified, only the specified filter types are replaced by the statement. This section explains how to work with replication filters when multiple replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-db-options.html
In those cases, the database being created, altered, or dropped replaces the default database when determining whether to log or ignore updates. When evaluating replication options, the replica begins by checking to see whether there are any ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-installation.html
Semisynchronous replication is implemented using plugins, which must be installed on the source and on the replicas to make semisynchronous replication available on the instances. There are different plugins for a source and for a replica. After a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-source.html
SHOW BINARY LOGS SHOW BINLOG EVENTS SHOW BINARY LOG STATUS (replaces SHOW MASTER STATUS, which is no longer supported) SHOW REPLICAS . Section 15.4.2, “SQL Statements for Controlling Replica Servers”, discusses statements for managing replica ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
(The reason the condition adds to rather than replaces the existing condition is the use of a condition value.) The RESIGNAL statement includes a condition value (SQLSTATE '45000'), so it adds a new condition area, resulting in a diagnostics area ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
These statements are subject to rewriting: SELECT, INSERT, REPLACE, UPDATE, and DELETE. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
REPLICA_SIDE_DISABLED replaces SLAVESIDE_DISABLED, which is now deprecated and subject to removal in a future version of MySQL. SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event ...