Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET DEFAULT ROLE and SET ROLE set the default role and current role for user accounts. Descriptions for those forms that ...
https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW BINLOG EVENTS. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not ...
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
Caution Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except ...
https://dev.mysql.com/doc/refman/8.4/en/show-relaylog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW RELAYLOG EVENTS. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
Any user credentials that you specified in the START GROUP_REPLICATION statement when starting Group Replication on this member are removed from memory, and must be supplied when you start Group Replication again. This statement requires the ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and ...