AWS RDS是否支持MySQL作为文档存储 [英] Does AWS RDS supports MySQL as document store

问题描述

我能够连接普通的AWS RDS MySQL实例(5.7.16).但是，由于必须将MySQL用作文档存储，因此我通过安装mysqlx插件配置了MySQL实例，这对于文档存储是必需的.

I am able to connect normal AWS RDS MySQL instance (5.7.16). But, as I have to use MySQL as document store, I have configured MySQL instance by installing mysqlx plugin, Which is required for document store.

此后，我试图在同一实例上的端口33060上连接MySQL文档存储，但无法连接.我正在使用lambda进行连接，该连接导入了xdevapi(@ mysql/xdevapi)程序包，并尝试在端口33060上与MySQL RDS实例进行连接.

After this, I am trying to connect MySQL document store on port 33060 on same instance but unable to connect. I am using lambda for connection which imports xdevapi (@mysql/xdevapi) package and tries to connect with MySQL RDS instance on port 33060.

但是，我看不到任何错误，因此我只是想知道AWS RDS是否支持MySQL文档存储.

But, there is no error which I can see for, therefore I am just wondering does AWS RDS has support for MySQL document store.

代码:

 xdevapi.getSession({
   host: process.env.HOSTNAME, 
   port:  process.env.PORT,
   dbUser: process.env.DB_USER, 
   dbPassword:  process.env.DB_PASSWORD
 }).then(function (session) {
    console.log("Connected");
    session.close();
    return callback(null, {'responsne':'connected', statusCode: 200});
 }).catch(function (err) {
     console.log(err.stack);
     return callback(null, {'responsne':err.stack, statusCode: 400});
 });

请帮我找到这个.

推荐答案

由于MySQL 8.0.11现在在AWS上普遍可用，因此我们一直在研究通过x-plugin的文档存储功能.

Since MySQL 8.0.11 is now generally available on AWS, we've been looking at the Document Store functionality via x-plugin.

浏览示例数据库( https://dev.mysql.com/doc/refman/8.0/zh-CN/mysql-shell-tutorial-javascript-download.html )，它会创建架构并将其导入，但是似乎没有将db对象暴露给mysqlsh.

Following through the sample DB (https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-download.html) it creates the schema and imports it OK, but doesn't seem to expose the db object to mysqlsh.

例如，当我运行

\use world_x  

连接到它输出的本地主机实例

connected to a local host instance it outputs

Default schema set to `world_x`.
Fetching table and column names from `world_x` for auto-completion... Press ^C to stop.

当连接到RDS实例时，我只会得到

whereas when connected to an RDS instance I only get

Default schema set to `world_x`.

此外，根据 https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.VersionMgmt 不支持X插件，据我了解，这意味着不支持文档存储功能

Additionally, according to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.VersionMgmt the X Plugin isn't supported which, as I understand it, means Document Store functionality isn't supported.

这篇关于AWS RDS是否支持MySQL作为文档存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！