Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-gtid-repair.html
If you want to keep the extra transactions, an emergency failover can be carried out to make the InnoDB Cluster with those transactions into the primary cluster, following the procedure in Section 9.9, “InnoDB ClusterSet Emergency Failover”.
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-repair.html
A removed InnoDB Cluster cannot be added back into an InnoDB ClusterSet deployment. Use this information if you need to repair a cluster in an InnoDB ClusterSet deployment. You can use the information here in any of the following situations: A ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-user-accounts.html
You need to do this step before joining the instances into the replica cluster, so the account is available to configure the replica InnoDB Cluster and the InnoDB ClusterSet deployment metadata and replication. The member servers in an InnoDB ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/manage-sandbox-instances.html
If you do want to retain a sandbox instance after an upgrade, a workaround is to manually copy the upgraded mysqld binary into the bin directory of each sandbox. Once a sandbox instance is running, it is possible to change its status at any time ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/monitoring-innodb-cluster.html
When you carry out a rolling upgrade by removing instances from the cluster, upgrading them, and adding them back into the cluster, the communication protocol version is automatically upgraded when the last remaining instance at the old MySQL Server ... This section describes how to use AdminAPI to monitor an InnoDB ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-failover-consistency.html
Note Using the consistency option on a multi-primary InnoDB Cluster has no effect but is allowed because the cluster can later be changed into single-primary mode with the Cluster.switchToSinglePrimaryMode() operation. Group Replication provides ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-batch-code-execution.html
However, SQL query execution for classic MySQL protocol sessions uses the runSql() function, which takes an SQL statement and its parameters, binds the specified parameters into the specified query and executes the query in a single step, returning ... 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.7/en/mysql-shell-extension-objects-persist.html
The preferred way to persist an extension object is by adding it into a MySQL Shell plugin. A script to define and register extension objects must have a file extension of .js for JavaScript code, or .py for Python code, to match the language used ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-features.html
A parallel table import utility that splits up a single data file and uses multiple threads to load the chunks into a MySQL table. Important MySQL Shell is updated frequently with fixes and new features. It is strongly recommended that you always ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-ldap-kerberos-authentication.html
For example: CREATE USER 'sammy'@'localhost' IDENTIFIED WITH authentication_ldap_sasl BY 'uid=sammy_ldap,ou=People,dc=my-domain,dc=com'; The authentication_ldap_sasl_client client-side plugin ships with the MySQL Server packages rather than being ...