Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads.html
The source creates a thread to send the binary log contents to a replica when the replica connects. When a START REPLICA statement is issued on a replica server, the replica creates an I/O (receiver) thread, which connects to the source and asks it ... MySQL replication capabilities are implemented using the following types of threads: Binary log dump ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-delete-package.html
More specifically, it removes any references to MySQL NDB Cluster software installations added to the agent's repository when the package was created. Once a package has been unregistered, it can no longer be used for a create cluster command. If ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-fewer-data-nodes.html
The process starts with creating a backup for the original cluster using the backup cluster command. Next, create a new cluster with fewer data nodes using the create cluster command. The backup cluster command also creates a logical backup for the ... Sometimes, you want to transfer data from your cluster to another one that has fewer data nodes—for example, when you want to scale down your cluster or prepare a smaller replica cluster for a replication ...
https://dev.mysql.com/doc/mysql-shell/8.4/en/mysql-innodb-cluster-upgrade-rolling.html
On a Unix system, if you used the optional --directory bootstrap option, a self-contained installation is created with all generated directories and files at the location you selected when you bootstrapped the router. Navigate to this directory and ... To upgrade the server instances in an InnoDB Cluster, complete the following steps: Upgrade MySQL ...
https://dev.mysql.com/doc/mysql-shell/8.4/en/mysql-innodb-cluster-working-with-clone.html
dba.createCluster() and MySQL Clone By default, when a new cluster is created on an instance where the MySQL Clone plugin is available, it is automatically installed and the cluster is configured to support cloning. The InnoDB Cluster recovery ...
https://dev.mysql.com/doc/mysql-shell/8.4/en/upgrade-mysql-replicaset-from-8027to8028.html
On a Unix system, if you used the optional --directory bootstrap option, a self-contained installation is created with all generated directories and files at the location you selected when you bootstrapped the router. Navigate to this directory and ... To upgrade the instances in an InnoDB ReplicaSet, complete the following steps: Upgrade MySQL ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-full-text-plugins.html
The following procedure describes how the plugin library is created: To write a full-text parser plugin, include the following header file in the plugin source file. This is the value that identifies the plugin as being legal for use in a WITH ...