Search Results
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-user-accounts.html
The account needs full read and write privileges on the InnoDB Cluster metadata tables, in addition to full MySQL administrator privileges. The member servers in an InnoDB Cluster make use of three types of user accounts. One InnoDB Cluster server ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-clone-deployment.html
By default, the cluster automatically chooses the most suitable method, but you can optionally configure this behavior, for example to force cloning, which replaces any transactions already processed by the joining instance. InnoDB Cluster ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-requirements.html
Convert any tables in other storage engines to use InnoDB before using the instance with Group Replication and InnoDB Cluster. But AdminAPI does not configure the transaction_isolation system variable, which means that it defaults to REPEATABLE READ. This does not impact a single-primary cluster, but if you are using a multi-primary cluster then unless you rely on REPEATABLE READ semantics in your applications, we recommend using the READ COMMITTED isolation ...
https://dev.mysql.com/doc/mysql-shell/9.7/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 ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-application-log-introduction.html
The available logging levels are as listed in Table 13.1, “Logging levels in MySQL Shell”. The location of the MySQL Shell application log file is the user configuration path and the file is named mysqlsh.log. By default, MySQL Shell sends ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-application-log-verbose.html
The available settings are as listed in Table 13.1, “Logging levels in MySQL Shell”. You can send MySQL Shell logging information to the console to help with debugging. Logging messages sent to the console are given the verbose: prefix. When ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-application-log.html
You can use MySQL Shell's logging feature to verify the state of MySQL Shell while it is running and to troubleshoot any issues. By default, MySQL Shell sends logging information at logging level 5 (error, warning, and informational messages) to an ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-cloud-service-configuration.html
The following cloud services are supported: Section 4.8.1, “Oracle Cloud Infrastructure Object Storage” Section 4.8.2, “S3-compatible Storage” Section 4.8.3, “Azure Blob Storage” For information on exporting MySQL data to cloud storage, ... MySQL Shell supports exporting of MySQL data to cloud service storage and import of that data from cloud storage to a MySQL ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-global-variables.html
The built-in MySQL Shell global objects are as follows: session is available when a global session is established, and represents the global session. db is available when the global session was established using an X Protocol connection with a ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-ldap-kerberos-authentication.html
SASL-Based LDAP Authentication MySQL Server is able to accept connections from users defined outside the MySQL grant tables in LDAP directories. CREATE USER 'lucy@MYSQL.LOCAL' IDENTIFIED WITH authentication_ldap_sasl BY '#krb_grp=proxied_krb_user'; ... MySQL Enterprise Edition supports authentication methods that enable MySQL Server to use LDAP (Lightweight Directory Access Protocol), LDAP with Kerberos, or native Kerberos to authenticate MySQL ...