Search Results
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-deploying-sandbox.html
This uses the metadata cache plugin to securely store the credentials. Test a MySQL Router installation by setting up a Router sandbox with InnoDB Cluster. In this case, Router acts as an intermediate node redirecting client connections to a list ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-general-features-connection-routing.html
The first part, routing, is the section name used internally to determine which plugin to load. Connection routing means redirecting MySQL connections to an available MySQL server. For an example deployment using basic connection routing, see ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-general-metadata.html
The cluster metadata is changed whenever the InnoDB Cluster is modified, such as adding or removing a MySQL server using the MySQL Shell, and the performance_schema tables are updated in real-time by the MySQL server's Group Replication plugin ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-installation-source-code.html
Developer Related Notes Notes related to using and testing a locally compiled MySQL Router version for development purposes: To run a local build without make install, configure Router to find the newly built plugin_folder as compiling generates a ... MySQL Router is part of the MySQL Server source code tree; compiling MySQL Server also compiles MySQL ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-routing-guidelines-syntax.html
$.router.routeName: matches the name of the Routing plugin used by the Router. The top-level properties of a routing guideline document are: destinations: groupings of MySQL servers using pattern-matching expressions. Only online topology members ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/command-line-integration-overview.html
This is because in addition to the standard objects bundled with MySQL Shell, additional objects from plugins might also be exposed. This section provides an overview of the command-line integration and some basic usage examples. For more detailed ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-cluster-binary-log-purging.html
Instances running 8.0.17 and later support the MySQL Clone plugin, which resolves this issue by providing an automatic provisioning solution which does not rely on incremental recovery, see Section 8.4.6, “Using MySQL Clone with InnoDB Cluster”.
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-cluster-user-accounts.html
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 accounts. One InnoDB Cluster ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-adminapi-reset-replication-account-credentials.html
This option can migrate existing accounts using deprecated or obsolete authentication plugins, such as mysql_native_password, which was removed in MySQL 9.0. reset_replication_accounts_password() enables you to reset, or recreate, the credentials ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-autocompletion.html
MySQL Shell supports autocompletion of text preceding the cursor by pressing the Tab key. The Section 3.1, “MySQL Shell Commands” can be autocompleted in any of the language modes. For example typing \con and pressing the Tab key autocompletes ...