Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/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.7/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.7/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.7/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.7/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.
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-diagnostics.html
If the user connects to an instance using X Protocol, and runs any of the diagnostics utilities, they automatically establish a classic connection to the instance. MySQL Shell diagnostic utilities enable you to analyze the performance of your ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-json-mysqlsh.html
port The port number for MySQL Shell's connection to the MySQL server. You can either specify it in the URI-like connection string, or using an additional --schema command line option. With the mysqlsh command interface, you invoke the JSON import ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-json-run.html
The JSON import utility requires an existing X Protocol connection to the server. If you omit this option, MySQL Shell attempts to identify and use the schema name in use for the current session, as specified in a URI-like connection string, \use ...In the MySQL Shell API, the JSON import utility is a function of the util global object, and has the following signature: importJSON (path, options) path is a string specifying the file path for the file containing the JSON documents to be ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/restore-cluster-from-quorum-loss.html
This assumes you can connect to an instance that contains the InnoDB Cluster metadata, and that instance can contact the other instances you want to use to restore the cluster. Connect to an instance which contains the cluster's metadata, then use ... If an instance (or instances) fail, then a cluster can lose its quorum, which is the ability to vote in a new ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/retrieving-a-handler.html
To retrieve the handler object, you establish a connection to one of the active instances, including Read Replicas, which belong to the InnoDB Cluster, InnoDB ClusterSet, or InnoDB ReplicaSet. By default MySQL Shell attempts to connect to the ...