Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
The following describes read-only statements: Statements are read-only if they start with: SELECT DO VALUES TABLE WITH that is not followed by UPDATE or DELETE. EXPLAIN, DESCRIBE, or DESC which are not followed by UPDATE or DELETE. If they start ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/adding-replicaset-instances.html
When you have created a ReplicaSet, you can use the ReplicaSet.addInstance() operation to add an instance as a read-only secondary replica of the current primary of the ReplicaSet. The primary of the ReplicaSet must be reachable and available ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-overview.html
Sandbox deployment: If you would like to test a deployment before committing to a full production deployment, the provided sandbox feature enables you to set up a test environment on your local machine. Sandbox server instances are created for you ...AdminAPI is accessed through the dba global variable and its associated ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-persisting-settings.html
The AdminAPI commands you use to work with an InnoDB Cluster, InnoDB ClusterSet, InnoDB ReplicaSet, and the individual member server instances in these deployments modify the configuration of MySQL Server on the instance. Depending on the way MySQL ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-sandboxes.html
This section explains how to set up a sandbox deployment with AdminAPI. Deploying and using local sandbox instances of MySQL is a good way to start your exploration of AdminAPI. AdminAPI has built-in functionality for creating sandbox instances ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-tagging.html
A configurable tag framework is available to allow the metadata of InnoDB Cluster, InnoDB ClusterSet, or InnoDB ReplicaSet to be marked with additional information. Tags make it possible to associate custom key-value pairs to a Cluster, ReplicaSet, ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/adminapi-locking.html
Previously, different instances of MySQL Shell could connect and process AdminAPI operations simultaneously on the same resource. This could lead to inconsistent states and errors, for example, if Cluster.addInstance() and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/configuring-automatic-rejoin-of-instances.html
Instances running MySQL 8.0.16 and later support the Group Replication automatic rejoin functionality, which enables you to configure instances to automatically rejoin the cluster after being expelled. See Responses to Failure Detection and Network ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/customize-your-cluster.html
When you create a cluster and add instances to it, values such as the group name and the local address are configured automatically by AdminAPI. The default values are recommended for most deployments, but advanced users can override the defaults ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/fencing-cluster.html
Following an emergency failover, and there is a risk of the transaction sets differing between parts of the ClusterSet, you have to fence the cluster either from write traffic or all traffic. Even though you primarily use fencing on clusters ...