Search Results
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. All instances of the ReplicaSet are expected to have the same ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-production-hostname.html
In a production deployment, the instances in which you use run-on separate machines, therefore each machine must have a unique hostname and be able to resolve the hostnames of the other machines, which run server instances. To verify whether the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-tagging.html
Tags have been reserved for use by MySQL Router that enables a compatible MySQL Router to support hiding instances from applications. Tag names can have any value as long as it starts with a letter or underscore, optionally followed by alphanumeric ... A configurable tag framework is available to allow the metadata of InnoDB Cluster, InnoDB ClusterSet, or InnoDB ReplicaSet to be marked with additional ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/cli-integration-for-api-functions.html
Dictionary parameters that do not have a predefined list of keys, accept any key-value pair as long as the key is not in the predefined set of a different dictionary parameter. The MySQL Shell provides global objects that expose different ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-remove.html
The cluster you are removing must currently have the status of a replica cluster. It can be invalidated, and does not have to be reachable. To remove a cluster from the InnoDB ClusterSet, use clusterSet.removeCluster() command. A force option is ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-router-setroutingoption.html
Although an invalidated cluster does not necessarily have any technical issues, the data is becoming stale, so this setting means that stale reads will take place unless the issue is resolved soon. Different routers may have different behaviors, ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-failover-consistency.html
The consistency option is only supported if the target MySQL server version is 8.0.14 or later, and instances added to a cluster which has been configured with the consistency option are automatically configured to have group_replication_consistency ... Group Replication provides the ability to specify the failover guarantees if a primary failover happens in single-primary mode (see Configuring Transaction Consistency ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-dba-upgrade-metadata.html
The dba.upgradeMetadata() function then updates any automatically created MySQL Router users to have the correct privileges. As AdminAPI evolves, some releases might require you to upgrade the metadata of existing ClusterSets, ReplicaSets, and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-replicaset.html
Once you have completed the replication setup, you administer it the same way as an InnoDB ReplicaSet deployed from scratch. The main reason to use InnoDB ReplicaSets is you have better write performance. The AdminAPI includes support for InnoDB ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-cloud-service-configuration-s3api.html
If you have installed and configured the AWS CLI, MySQL Shell reads the connection parameters from the default location, .aws/, automatically. However, if you have defined access key and secret access keys in both files, those defined in the ...