Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-using-deploying.html
To allow MySQL Router to connect to MySQL without requiring extra accounts for the Router's host, for MySQL accounts that are created specifically for application hosts such as myapp@198.51.100.45 instead of a value like myapp@%. Performance ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-configuration.html
Note Session variables are reset to their initial values if the client sends a change_user or reset_connection. For example: SQL> ROUTER SET access_mode='read_write' SQL> query_attribute router.access_mode read_write Bootstrapping When MySQL Router ... To enable read-write splitting, the following router options must be enabled: access_mode: must be set to ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-sandboxes.html
AdminAPI has built-in functionality for creating sandbox instances that are correctly configured to work with InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet in a locally deployed scenario. This section explains how to set up a sandbox ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-userguide.html
This chapter covers MySQL AdminAPI, provided with MySQL Shell, which enables you to administer MySQL instances, using them to create InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet deployments, and integrating MySQL Router.
https://dev.mysql.com/doc/mysql-shell/9.4/en/adminapi-locking.html
Table 6.1 DBA Operation Locks Operation Lock Type configureInstance() Exclusive on the target instance createCluster() Exclusive on the target instance rebootClusterFromCompleteOutage() Exclusive on all contactable cluster members. Table 6.2 Cluster ... Previously, different instances of MySQL Shell could connect and process AdminAPI operations simultaneously on the same ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/cli-integration-defining-arguments.html
As mentioned in Section 5.8.2.1, “Command Line Integration for MySQL Shell API Functions”, most of the APIs available in MySQL Shell expect a specific data type for the arguments being provided. Values in command-line arguments can be provided ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/cli-integration-for-api-functions.html
The lifetime of the object is limited to the lifetime of the MySQL Shell invocation that created it. The MySQL Shell provides global objects that expose different functionality, such as dba for InnoDB Cluster and InnoDB ReplicaSet management ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/configuring-election-process.html
Use the memberWeight option and pass it to the dba.createCluster() and Cluster.addInstance() methods when creating your cluster. For example to configure a cluster where ic-3 is the preferred instance to fail over to in the event that ic-1, the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-cluster-fencing.html
A split-brain can occur in situations such as when a DBA decides to forcibly elect a replica cluster to become the primary cluster creating more than one master, leading to the split-brain situation. Following an emergency failover, and there is a ...
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. AdminAPI's clusterSet.status() command warns you if an InnoDB Cluster's ...