MySql 中文参考指南

Chapter 21 MySQL Shell

MySQL Shell 是适用于 MySQL Server 的高级客户端和代码编辑器。除了提供的 SQL 功能外，类似于 mysql ，MySQL Shell 还提供 JavaScript 和 Python 的脚本编写功能，并包括用于处理 MySQL 的 API。MySQL Shell 是可单独安装的组件。

MySQL Shell is an advanced client and code editor for MySQL Server. In addition to the provided SQL functionality, similar to mysql, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. MySQL Shell is a component that you can install separately.

以下讨论简要介绍了 MySQL Shell 的功能。有关更多信息，请参阅 MySQL Shell 手册，地址为 [role="bare"[role="bare"]https://dev.mysql.com/doc/mysql-shell/en/]。

The following discussion briefly describes MySQL Shell’s capabilities. For more information, see the MySQL Shell manual, available at [role="bare"https://dev.mysql.com/doc/mysql-shell/en/].

MySQL Shell 包含以 JavaScript 和 Python 实现的以下 API，您可以使用它们来开发与 MySQL 交互的代码。

MySQL Shell includes the following APIs implemented in JavaScript and Python which you can use to develop code that interacts with MySQL.

  1. The X DevAPI enables developers to work with both relational and document data when MySQL Shell is connected to a MySQL server using the X Protocol. This enables you to use MySQL as a Document Store, sometimes referred to as “using NoSQL”. For more information, see Chapter 22, Using MySQL as a Document Store. For documentation on the concepts and usage of X DevAPI, which is implemented in MySQL Shell, see X DevAPI User Guide.

  2. The AdminAPI enables database administrators to work with InnoDB Cluster, which provides an integrated solution for high availability and scalability using InnoDB based MySQL databases, without requiring advanced MySQL expertise. The AdminAPI also includes support for InnoDB ReplicaSet, which enables you to administer a set of MySQL instances running asynchronous GTID-based replication in a similar way to InnoDB Cluster. Additionally, the AdminAPI makes administration of MySQL Router easier, including integration with both InnoDB Cluster and InnoDB ReplicaSet. See MySQL AdminAPI.

MySQL Shell 提供两个版本，Community Edition 和 Commercial Edition。Community Edition 可免费获得。Commercial Edition 以低成本提供额外的企业级功能。

MySQL Shell is available in two editions, the Community Edition and the Commercial Edition. The Community Edition is available free of charge. The Commercial Edition provides additional Enterprise features at low cost.