Search Results
https://dev.mysql.com/doc/refman/8.4/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-administration-status.html
row *************************** Id: 10 User: root Host: replica1:58371 db: NULL Command: Binlog Dump Time: 777 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Because it is the replica that drives the replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover-replica.html
To configure this feature, the replication channel and the replication user account and password for the channel must be set up on all the member servers in the replication group, and on any new joining members. Asynchronous connection failover for ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-adding-binlog-master.html
These steps assume that binary logging is enabled on the source (which is the default), the replica is using TABLE based replication applier metadata repositories (which is the default in MySQL 8.4), and that you have enabled a replication user and ...Use a CHANGE REPLICATION SOURCE TO statement to configure a replication channel for each source on the replica (see Section 19.2.2, “Replication ...
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
These functions include FOUND_ROWS(), GET_LOCK(), IS_FREE_LOCK(), IS_USED_LOCK(), LOAD_FILE(), RAND(), RELEASE_LOCK(), ROW_COUNT(), SESSION_USER(), SLEEP(), SOURCE_POS_WAIT(), SYSDATE(), SYSTEM_USER(), USER(), UUID(), and UUID_SHORT(). The ...
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-semisync.html
When one user is too busy, this slows it down, which can be useful in some deployment situations. In addition to the built-in asynchronous replication, MySQL 8.4 supports an interface to semisynchronous replication that is implemented by plugins.
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
To use CHANGE REPLICATION SOURCE TO, add all information about how to connect to Replica 1 from Replica 2 or Replica 3 (user, password, port). You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement. The ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
Issuing a RESET REPLICA ALL statement without a FOR CHANNEL channel clause when multiple replication channels exist deletes all replication channels and recreates only the default channel. RESET REPLICA does not change any replication connection ...
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log ...