Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-member-actions.html
When this member action is enabled and taken, super read-only mode is disabled on the primary, so that the primary becomes read-write and accepts updates from a replication source server and from clients. When this member action is disabled and not ... The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
The MySQL server tracks the logging mode that was in effect when each temporary table was created. When executing on the replica, a table lock is taken on all tables involved, and then the rows are applied in batch mode. Using ... MySQL uses ...
https://dev.mysql.com/doc/workbench/en/wb-installing-linux.html
For example: $> sudo dpkg -i mysql-apt-config_0.5.3-1_all.deb $> sudo apt-get update Install the MySQL Workbench package. There are binary distributions of MySQL Workbench available for several variants of Linux, including Fedora, Oracle Linux, and ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. Before ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-security.html
The following security features help keep your data safe and secure. Security 1.6 Security Oracle considers cloud security its highest priority. Database access control and account management MySQL provides security features to control access and ...
https://dev.mysql.com/doc/refman/8.4/en/account-management-statements.html
To make sure that you can take advantage of any new capabilities, update your grant tables to the current structure whenever you upgrade MySQL. MySQL account information is stored in the tables of the mysql system schema. This database and the ...
https://dev.mysql.com/doc/refman/8.4/en/non-typed-operators.html
/ Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) = Equal operator ^ Bitwise XOR AND, && Logical AND BETWEEN ... ->> Return value from JSON column after ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...(Bug #11754117, Bug #45670) This issue does not affect tables using the InnoDB storage engine, since an InnoDB table with an AUTO_INCREMENT column requires at least one key where the auto-increment column is the only or leftmost ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
The account can also be safely used by an administrator to apply or reapply transactions from mysqlbinlog output, for example to recover from a replication error on the channel. After setting up the user account, use the GRANT statement to grant ...