Search Results
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-general-metadata.html
Whenever an application connects to Router, Router chooses a suitable MySQL server from the pool of candidates that it knows about, and then connects to it. The cluster metadata is changed whenever the InnoDB Cluster is modified, such as adding or ... MySQL Router works by sitting in between applications and MySQL ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-server-logging.html
The logging feature can be handy for developing and testing your application and deployment of the MySQL Router. To use logging, enable the logging level option in the configuration file under the section named [logger]. For example: [logger] level ...
https://dev.mysql.com/doc/mysql-shell/9.7/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.7/en/adminapi-executing-sql.html
Timeout is only used for SELECT statements and locks originating from LOCK TABLE statements. Sessions are established to the target instances, ensuring they can be contacted. The execute() function enables you to execute SQL queries and statements ...
https://dev.mysql.com/doc/mysql-shell/9.7/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.7/en/command-line-help.html
You can access the MySQL Shell online help when calling commands from the command-line integration using the --help (-h) CLI argument. Note The built-in help CLI argument does not map to any API argument and is supported in all the objects and ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/configuring-production-instances.html
AdminAPI provides the dba.configureInstance() function that checks if an instance is suitably configured for InnoDB Cluster usage, and configures the instance if it finds any settings which are not compatible with InnoDB Cluster. Once ...You run ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/create-cluster.html
This instance reports its own address as ic-1 Instance configuration is suitable. To be able to administer a cluster, you must ensure that you have a suitable user which has the required privileges. Note This can only be set by MySQL Shell on MySQL ... 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 ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/creating-user-accounts-for-admin-api.html
The user accounts used to configure and administer a member server instance in an InnoDB Cluster, InnoDB ClusterSet, or InnoDB ReplicaSet deployment must have full read and write privileges on the metadata tables, in addition to full MySQL ...You ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-failover.html
When the connection is established, get the ClusterSet object from that member server using a dba.getClusterSet() or cluster.getClusterSet() command. A primary cluster that is functioning acceptably has the global status OK when you check it using ... An emergency failover makes a selected replica cluster into the primary InnoDB Cluster for the InnoDB ClusterSet ...