Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-stop-replica.html
To stop all currently configured replication channels: mysql> STOP REPLICA; To stop only a named channel, use a FOR CHANNEL channel clause: mysql> STOP REPLICA FOR CHANNEL "source_1"; For the full syntax of the STOP REPLICA statement and other ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-table-options.html
For example, a GRANT statement, which updates the mysql.user system table but does not mention that table, is not affected by a filter that specifies mysql.% as the wildcard pattern. The replica checks for and evaluates table options only if either ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules.html
Note that replication filters cannot be used on Group Replication-specific channels on a MySQL server instance that is configured for Group Replication, because filtering transactions on some servers would make the group unable to reach agreement on ... If a replication source server does not write a statement to its binary log, the statement is not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-security.html
To protect against unauthorized access to data that is stored on and transferred between replication source servers and replicas, set up all the servers involved using the security measures that you would choose for any MySQL instance in your ...In ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... Note This ...
https://dev.mysql.com/doc/refman/8.4/en/restart.html
One use for RESTART is when it is not possible or convenient to gain command-line access to the MySQL server on the server host to restart it. For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL distributions include a postparse query rewrite plugin named Rewriter and scripts for installing ...These elements work together to provide statement-rewriting capability: A server-side plugin named Rewriter examines statements and may rewrite them, based on its in-memory cache of rewrite ...
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
MySQL role names refer to roles, which are named collections of privileges. It is possible for a row in the mysql.user system table to serve as both an account and a role. Role names have syntax and semantics similar to account names; see Section ...
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
However, the row constructor itself does not cover an index prefix, with the result that the optimizer uses only c1 (key_len=4, the size of c1): mysql> EXPLAIN SELECT * FROM t1 WHERE c1=1 AND (c2,c3) > (1,1)\G *************************** 1. For ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...