Search Results
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-faq.html
MySQL Router 2.0 was the initial version and is meant for MySQL Fabric users. Can I run more than one instance of the router application? A.3. Please explain the different MySQL Router versions, especially why Router went from 2.1.4 to 8.0.3. What ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-general-features-connection-sharing.html
and SQL_CALC_FOUND_ROWS User variables Temporary tables Prepared statements Note Transactions and LOCK TABLES also block connection sharing until the transaction is closed, or the lock released. MySQL Router enables server connections to be pooled ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-general-using-developing.html
As an administrator, I want to be able to run a connection routing service on port 3306 so it is more transparent to a user or application. MySQL Router usage does not require specific libraries or interfaces. Aside from managing the MySQL Router ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/add-instances-cluster.html
You need a minimum of three instances in an InnoDB Cluster to make it tolerant to the failure of one instance. Adding further instances increases the tolerance to failure of an InnoDB Cluster. Group Replication implements compatibility policies ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-routing-guidelines.html
Routing sessions based on application or user role, and automatically route client sessions to the appropriate Cluster based on the schema being used, simplifying configuration and ensuring data and application-specific needs are met. Routing ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-dissolve.html
This section describes how to dissolve a ClusterSet using ClusterSet.dissolve(). ClusterSets are dissolved in the following way: Replication accounts are dropped from all contactable members. If any instance is unreachable, the operation fails, ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-upgrade.html
All the existing user connections are maintained, and any new connections are routed according to the cached metadata. Much of the process of upgrading an InnoDB Cluster consists of upgrading the instances in the same way as documented at Upgrading ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster.html
Advanced users can also configure a cluster to have multiple primaries. MySQL InnoDB Cluster provides a complete high availability solution for MySQL. By using AdminAPI, which is included with MySQL Shell, you can easily configure and administer a ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-plugins.html
You can extend MySQL Shell with user-defined plugins that are loaded at startup. Plugins can be written in either JavaScript or Python, and the functions they contain are available in MySQL Shell in both JavaScript and Python modes.
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-prompt-themes.html
The user configuration path for the mysqlsh directory where the prompt.json is located can be overridden on all platforms by defining the environment variable MYSQLSH_USER_CONFIG_HOME. The MySQL Shell prompt can be customized using prompt theme ...