Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/command-line-integration-overview.html
db: represents the default database for the global session, if that session was established using an X Protocol connection with a default database specified. As a result, if you connect to a MySQL Server which uses an option file, it will be used, ... This section provides an overview of the command-line integration and some basic usage ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/configuring-cluster-instance-ports.html
Instances that belong to a cluster use different ports for different types of communication. This port is configured by the localAddress option, which configures the group_replication_local_address system variable, and this port must be open so ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/configuring-replicaset-instances.html
MySQL Shell can either connect to an instance and then configure it, or you can pass in an instance name to configure a specific remote instance. When you connect to the instance for administration tasks, you require a user with suitable privileges.
https://dev.mysql.com/doc/mysql-shell/9.4/en/creating-a-replicaset.html
Once you have configured your instances, create an InnoDB ReplicaSet by completing the following steps: Connect to an instance and use dba.createReplicaSet() to create a managed ReplicaSet that uses MySQL asynchronous replication, rather than MySQL ...The dba.createReplicaSet() operation performs several checks to ensure that the instance state and configuration are compatible with a managed ReplicaSet, and if so, a metadata schema is initialized on the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/deploy-sandbox-instances.html
The port_number argument is the TCP port number where the MySQL Server instance listens for connections. The following options are supported by the dba.deploySandboxInstance() operation: allowRootFrom configures which host the root user can connect ... Rather than using a production setup, where each instance runs on a separate host, AdminAPI provides the dba.deploySandboxInstance(port_number) ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/deploying-production-innodb-cluster.html
To pass a server's connection information to AdminAPI, use URI-like connection strings or a data dictionary; see Connecting to the Server Using URI-Like Strings or Key-Value Pairs. This section assumes that you have: installed the MySQL components ... When working in a production environment, the MySQL server instances which make up an InnoDB Cluster run on multiple host machines as part of a network rather than on single machine as described in Section 6.8, “AdminAPI MySQL ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-cluster-user-accounts.html
One or more MySQL Router accounts can be created for MySQL Router instances to connect to the cluster. 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 InnoDB Cluster - ... Configuring InnoDB Cluster Administrator Accounts Manually Internal User Accounts Created by InnoDB Cluster Resetting Recovery Account Passwords The member servers in an InnoDB Cluster make use of three types of user ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-user-accounts.html
One or more MySQL Router accounts can be created for MySQL Router instances to connect to the cluster. 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 InnoDB Cluster - ... The member servers in an InnoDB Cluster make use of three types of user ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-upgrade-troubleshoot.html
Handling Host Name Changes MySQL Shell uses the host value of the provided connection parameters as the target hostname used for AdminAPI operations, namely to register the instance in the metadata (for the dba.createCluster() and ...When the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-dba-upgrade-metadata.html
To upgrade a ClusterSet, ReplicaSet, or Cluster's metadata, connect MySQL Shell's global session to your ClusterSet, ReplicaSet, or Cluster and use the dba.upgradeMetadata() operation to upgrade the ClusterSet, ReplicaSet, or Cluster's metadata to ... As AdminAPI evolves, some releases might require you to upgrade the metadata of existing ClusterSets, ReplicaSets, and Clusters to ensure they are compatible with newer versions of MySQL ...