Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-gtid-repair.html
A situation that can create a diverged set of transactions with no outside changes is when the primary cluster becomes unreachable and an emergency failover procedure is used. If the whole InnoDB Cluster is affected, remove the affected cluster from ... AdminAPI's clusterSet.status() command warns you if an InnoDB Cluster's GTID set is inconsistent with the GTID set on the primary cluster in the InnoDB ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-repair.html
A cluster has been marked as invalidated during an emergency failover or controlled switchover procedure. Follow this procedure to repair an InnoDB Cluster that is part of an InnoDB ClusterSet deployment: Using MySQL Shell, connect to any member ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-instance-schema.html
routines: [ true | false ] (Instance dump utility and schema dump utility only) Include (true) or exclude (false) functions and stored procedures for each schema in the dump. excludeRoutines: array of strings (Instance dump utility and schema dump ... MySQL Shell's instance dump utility util.dumpInstance() and schema dump utility util.dumpSchemas(), support the export of all schemas or a selected schema from an on-premise MySQL instance into an Oracle Cloud Infrastructure Object Storage bucket or a set of local ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
One of the key features of MySQL ', 'is its support for stored procedures, which allow developers to create reusable blocks of ', 'code that can be executed multiple times. It uses a client-server architecture, supports stored procedures, a wide ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
To ensure that your tables are up to date for upgrades from earlier versions of MySQL, perform the MySQL upgrade procedure, making sure to use the option that forces an update (see Chapter 3, Upgrading MySQL). This section describes how to install ...
https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
If you follow the RSA configuration procedure given later in this section, it also supports encrypted password exchange using RSA over unencrypted connections. To enable use of an RSA key pair for password exchange during the client connection ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
To view undo tablespace file names on the donor to ensure that they are unique, query the FILES table: mysql> SELECT TABLESPACE_NAME, FILE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE LIKE 'UNDO LOG'; For information about dropping and adding ... The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server instance (the donor) and transferring it to the MySQL instance where the cloning operation was initiated (the ...
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. If you are upgrading to MySQL 8.4 from an earlier version, be sure to perform the upgrade procedure to make sure that your system ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
The following stored procedure accepts a UCS-2 Unicode character, converts it to other character sets, and displays the results in hexadecimal. This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
Dropping a FOREIGN KEY constraint does not work in replication because the constraint may have another name on the replica. If you execute a PROCEDURE on a query that returns an empty set, in some cases the PROCEDURE does not transform the columns.