Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-asynchronous-connection-failover.html
If the new servers are provisioned using MySQL’s clone functionality, this all happens automatically. Important If you do not want asynchronous connection failover to take place between replicas in this situation, disable it by disabling the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
A statement invoking a trigger (or function) that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based replication. If the trigger needs a single result value from the code, you can put the code in a stored ... With statement-based replication, triggers executed on the source also execute on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-restrictions.html
In any of the cases just mentioned, the one-to-one correspondence between transactions and GTIDs is broken, with the result that GTID-based replication cannot function correctly. If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
The CURRENT_ROLE() function displays the active roles within the current session. To determine which roles are active within the current session, use the CURRENT_ROLE() function. Like user accounts, roles can have privileges granted to and revoked ...
https://dev.mysql.com/doc/refman/8.4/en/security-plugins.html
A function enables applications to add their own message events to the audit log. (MySQL Enterprise Edition only) MySQL Enterprise Data Masking and De-Identification, implemented as a plugin library containing a plugin and a set of functions. MySQL ... MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
An error occurs for attempts to apply them to user-defined variables, stored procedure or function parameters, or stored program local variables. An error occurs for attempts to assign DEFAULT to user-defined variables, stored procedure or function ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html
row *************************** Privilege: Alter routine Context: Functions,Procedures Comment: To alter or drop stored functions/procedures *************************** 3. row *************************** Privilege: Create routine Context: Databases ... SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server ...