Search Results
https://dev.mysql.com/doc/mysql-shell/9.4/en/force-replicaset-primary.html
If you cannot connect to the primary, and you cannot use ReplicaSet.setPrimaryInstance() to safely perform a switchover to a new primary as described at Section 10.7, “Changing the Primary Instance”, use the ReplicaSet.forcePrimaryInstance() ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset.html
If the primary cluster becomes unavailable due to the loss of the data center or the loss of network connectivity to it, you can make a replica cluster active instead to restore the availability of the service. You should therefore always make an ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-setting-options.html
replicationAllowedHost: string value to define strict subnet based filtering, so that internally managed replication accounts can only connect from allowed hosts. expelTimeout: integer value to define the time period in seconds that cluster members ... You can check and modify the settings in place for an InnoDB Cluster while the instances are ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-upgrade-rolling.html
Stop and quit MySQL Shell by issuing: \q Restart MySQL Shell from the command line, by issuing: mysqlsh Upgrade the InnoDB Cluster Metadata: To upgrade an InnoDB Cluster's metadata, connect MySQL Shell's global session to your cluster and use the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster.html
MySQL Router can automatically configure itself based on the cluster you deploy, connecting client applications transparently to the server instances. MySQL InnoDB Cluster provides a complete high availability solution for MySQL. By using AdminAPI, ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-batch-code-execution.html
If you need to create a MySQL Shell script that is independent of the protocol used for connecting to the MySQL server, MySQL Shell provides a session.runSql() function for X Protocol, which works in the same way as the runSql() function in classic ... As well as interactive code execution, MySQL Shell provides batch code execution from: A file loaded for ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-configuring.html
For example you can get online help, connect to servers, change the current language being used, run reports, use utilities, and so on. This section describes the commands which configure MySQL Shell from the interactive code editor. The commands ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-getting-started.html
This section describes how to get started with MySQL Shell, explaining how to connect to a MySQL server instance, and how to choose a session type. Important It is recommended that you always use the most recent version available. The latest ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-global-variables.html
db is available when the global session was established using an X Protocol connection with a default database specified, and represents that schema. MySQL Shell includes a number of built-in global objects that exist in both JavaScript and Python ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-install-starting.html
Open a terminal window (command prompt on Windows) and start MySQL Shell by issuing: > mysqlsh This opens MySQL Shell without connecting to a server, by default in SQL mode. When MySQL Shell is installed you have the mysqlsh command available.