Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-examples.html
rg.add_route( "rw_traffic", "$.session.targetPort in ($.router.port.rw, $.router.port.rw_split)", ["first-available(Primary_Local, Primary_Remote)"], {"connectionSharingAllowed": True, "enabled": True}); rg.add_route( "ro_traffic", ...This example ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/admin-api-routing-guidelines-visualising.html
Show Detailed Information To view a detailed summary of the Routing Guideline, use the following: rg.show() rg.show() returns the following: The name of the Routing Guideline and the connected topology. The routes, including the match expression and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/configuring-router-user.html
When MySQL Router connects to a Cluster, ClusterSet, or ReplicaSet, it requires a user account that has the correct privileges. To add a new MySQL Router account named myRouter1 to the InnoDB Cluster referenced by the variable testCluster, issue: ...In previous versions, MySQL Router created internal accounts at each bootstrap of the cluster, which could result in many accounts building up over ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/create-cluster.html
Once you have prepared your instances, use the dba.createCluster() function to create the cluster, using the instance which MySQL Shell is connected to as the seed instance for the cluster. When you issue dba.createCluster(name) MySQL Shell creates ...The seed instance is replicated to the other instances that you add to the cluster, making them replicas of the seed ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/creating-user-accounts-for-admin-api.html
Create the same account, with the same user name and password, in the same way on every server instance that will be part of the deployment, both the instance you connect to create the deployment and the instances that will join after that. The ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-autocompletion.html
For example typing \con and pressing the Tab key autocompletes to \connect. MySQL Shell supports autocompletion of text preceding the cursor by pressing the Tab key. The Section 3.1, “MySQL Shell Commands” can be autocompleted in any of the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-cloud-service-configuration-azure.html
Environment Variables Azure connection settings can be read from the following environment variables: AZURE_STORAGE_ACCOUNT: The default storage account name. Configuration Files If you use the Azure config file, you must add one or more of the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-cloud-service-configuration-oci.html
Connections to Oracle Cloud Infrastructure Object Storage can be configured in the following ways: OCI Configuration File OCI Environment Variables OCI Configuration File MySQL Shell uses the parameters defined in the OCI CLI configuration file, ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-prompt-themes.html
Figure 14.1 MySQL Shell prompt There are six parts that can make up the prompt: Status: Whether it is a production system and whether the connection has been lost. Connection: Which host you are connected to, and on which port that SSL is being used. Some sample prompt theme files are also included, for example, prompt_256.json: In the sample prompt theme prompt_256.json, there is an object with the classes disconnected%host% and ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-debug-diagnostics.html
Each diagnostic is prefixed with a number, 1 (one) for the server MySQL Shell is connected to, and incremented for each member detected. Ping results (ping.txt) are generated only if Shell is connected to a member of the topology on the localhost.