巨杉Tech | 使用 SequoiaDB + Docker + Nodejs 搭建 Web 服务器

叁歲伎倆 2021-12-01 12:10 281阅读 0赞

容器化技术的出现大大简化了应用开发人员在构建底层基础设施的工作。SequoiaDB 巨杉数据库于3.2.1版本正式推出了 Docker 容器化部署方案，本文将会基于 SequoiaDB 巨杉数据库与Nodejs的 Docker 镜像搭建一个简易的 Web 服务器。

# 1、规划部署 #

我们将会搭建一个三分区三副本的高可用 SequoiaDB 巨杉数据库。同时，我们将会创建一个 SequoiaDB 巨杉数据库的 MySQL 实例，用以提供 Nodejs 作为数据源。

<table style="width:557px;"> 
 <thead> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 容器角色 </td> 
 <td style="border-color:#dfe2e5;width:127.6pt;"> 容器名/IP:端口 </td> 
 <td style="border-color:#dfe2e5;width:63.8pt;"> 分区组 </td> 
 <td style="border-color:#dfe2e5;width:134.7pt;"> 镜像版本 </td> 
 </tr> 
 </thead> 
 <tbody> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据库协调节点 </td> 
 <td style="width:127.6pt;"> coord_catalog/172.17.0.2:11810 </td> 
 <td style="width:63.8pt;"> SYSCoord </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据库编目节点 </td> 
 <td style="width:127.6pt;"> coord_catalog/172.17.0.2:11800 </td> 
 <td style="width:63.8pt;"> SYSCatalog </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区1副本1 </td> 
 <td style="width:127.6pt;"> sdb_data1/172.17.0.3:11820 </td> 
 <td style="width:63.8pt;"> group1 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区1副本2 </td> 
 <td style="width:127.6pt;"> sdb_data2/172.17.0.4:11820 </td> 
 <td style="width:63.8pt;"> group1 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区1副本3 </td> 
 <td style="width:127.6pt;"> sdb_data3/172.17.0.5:11820 </td> 
 <td style="width:63.8pt;"> group1 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区2副本1 </td> 
 <td style="width:127.6pt;"> sdb_data2/172.17.0.4:11830 </td> 
 <td style="width:63.8pt;"> group2 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区2副本2 </td> 
 <td style="width:127.6pt;"> sdb_data3/172.17.0.5:11830 </td> 
 <td style="width:63.8pt;"> group2 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区2副本3 </td> 
 <td style="width:127.6pt;"> sdb_data1/172.17.0.3:11830 </td> 
 <td style="width:63.8pt;"> group2 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区3副本1 </td> 
 <td style="width:127.6pt;"> sdb_data3/172.17.0.5:11840 </td> 
 <td style="width:63.8pt;"> group3 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区3副本2 </td> 
 <td style="width:127.6pt;"> sdb_data1/172.17.0.3:11840 </td> 
 <td style="width:63.8pt;"> group3 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据分区3副本3 </td> 
 <td style="width:127.6pt;"> sdb_data2/172.17.0.4:11840 </td> 
 <td style="width:63.8pt;"> group3 </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> 数据库 MySQL实例 </td> 
 <td style="width:127.6pt;"> mysql/172.17.0.6:3306 </td> 
 <td style="width:63.8pt;"> - </td> 
 <td style="width:134.7pt;"> sequoiadb/sequoiasql-mysql:v3.2.1 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#dfe2e5;width:91.75pt;"> Nodejs Web 服务器 </td> 
 <td style="width:127.6pt;"> nodetest/172.17.0.7:3000 </td> 
 <td style="width:63.8pt;"> - </td> 
 <td style="width:134.7pt;"> node:latest </td> 
 </tr> 
 </tbody> 
</table>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NlcXVvaWFEQl9PZmZpY2lhbA_size_16_color_FFFFFF_t_70][]

# 2、安装 Docker 环境 #

对于已经安装了 Docker 环境的读者可以跳过本章节。对于之前没有使用过 Docker 的读者可以通过本章节安装本地 Docker 环境。

Docker 可以运行在绝大部分主流操作系统上，包括常用的 Windows、Mac 以及 Linux 的多个版本均可支持。

对于 Mac 用户可以安装 Docker Desktop for Mac，下载地址在：

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> <a href="https://hub.docker.com/editions/community/docker-ce-desktop-mac" rel="nofollow">https://hub.docker.com/editions/community/docker-ce-desktop-mac</a> </td> 
 </tr> 
 </tbody> 
</table>

对于 Windows 用户可以安装 Docker Deskop for Windows，下载地址在：

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> <a href="https://docs.docker.com/docker-for-windows/install/" rel="nofollow">https://docs.docker.com/docker-for-windows/install/</a> </td> 
 </tr> 
 </tbody> 
</table>

对于 Linux 用户则可以直接使用 yum 或 apt-get 进行安装：

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> <a href="https://docs.docker.com/install/linux/docker-ce/centos/" rel="nofollow">https://docs.docker.com/install/linux/docker-ce/centos/</a> <a href="https://docs.docker.com/install/linux/docker-ce/ubuntu/" rel="nofollow">https://docs.docker.com/install/linux/docker-ce/ubuntu/</a> </td> 
 </tr> 
 </tbody> 
</table>

# 3、搭建 SequoiaDB 巨杉数据库集群 #

3.1、将 SequoiaDB 引擎与 SequoiaSQL-MySQL 数据库实例下载至本地

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker pull sequoiadb/sequoiadb:v3.2.1 docker pull sequoiadb/sequoiasql-mysql:v3.2.1 </td> 
 </tr> 
 </tbody> 
</table>

3.2、启动数据库引擎容器

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker run -it -d --name coord_catalog sequoiadb/sequoiadb:v3.2.1 docker run -it -d --name sdb_data1 sequoiadb/sequoiadb:v3.2.1 docker run -it -d --name sdb_data2 sequoiadb/sequoiadb:v3.2.1 docker run -it -d --name sdb_data3 sequoiadb/sequoiadb:v3.2.1 </td> 
 </tr> 
 </tbody> 
</table>

3.3、验证各个容器的 IP 地址

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker inspect --format '{ { .NetworkSettings.IPAddress}}' coord_catalog docker inspect --format '{ { .NetworkSettings.IPAddress}}' sdb_data1 docker inspect --format '{ { .NetworkSettings.IPAddress}}' sdb_data2 docker inspect --format '{ { .NetworkSettings.IPAddress}}' sdb_data3 </td> 
 </tr> 
 </tbody> 
</table>

预期输出结果为：

3.4、部署 SequoiaDB 巨杉数据库引擎集群

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker exec coord_catalog "/init.sh" \ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --coord='172.17.0.2:11810' \ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --catalog='172.17.0.2:11800' \ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --data='group1=172.17.0.3:11820,172.17.0.4:11820,172.17.0.5:11820;group2=172.17.0.4:11830,172.17.0.5:11830,172.17.0.3:11830;group3=172.17.0.5:11840,172.17.0.3:11840,172.17.0.4:11840' </td> 
 </tr> 
 </tbody> 
</table>

预期输出结果为：

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> Begin generating SequoiaDB conf file Finish generating SequoiaDB conf file Restarting sdbcm process, it will take 10 seconds Deploy... Execute command: /opt/sequoiadb/tools/deploy/../../bin/sdb -f /opt/sequoiadb/tools/deploy/quickDeploy.js -e '' &nbsp; ************ Deploy SequoiaDB ************************ Create catalog: 172.17.0.2:11800 Create coord:&nbsp;&nbsp; 172.17.0.2:11810 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.3:11820 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.4:11820 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.5:11820 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.4:11830 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.5:11830 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.3:11830 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.5:11840 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.3:11840 Create data:&nbsp;&nbsp;&nbsp; 172.17.0.4:11840 </td> 
 </tr> 
 </tbody> 
</table>

3.5、启动 MySQL 实例容器

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker run -it -d -p 3306:3306 --name mysql sequoiadb/sequoiasql-mysql:v3.2.1 </td> 
 </tr> 
 </tbody> 
</table>

3.6、验证 IP 地址

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker inspect --format '{ { .NetworkSettings.IPAddress}}' mysql </td> 
 </tr> 
 </tbody> 
</table>

预期输出结果为：

3.7、创建 MySQL 实例

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker exec mysql "/init.sh" --port=3306 --coord='172.17.0.2:11810' </td> 
 </tr> 
 </tbody> 
</table>

其中 coord 参数填写协调节点所在的 IP 地址与监听端口。

预期输出结果为：

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> Creating SequoiaSQL instance: MySQLInstance Modify configuration file and restart the instance: MySQLInstance Restarting instance: MySQLInstance Opening remote access to user root Restarting instance: MySQLInstance Instance MySQLInstance is created on port 3306, default user is root </td> 
 </tr> 
 </tbody> 
</table>

# 4、登录 MySQL 并创建一个测试表 #

4.1、得到 MySQL 实例的容器 ID

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker ps --filter name=mysql --format { {.ID}} </td> 
 </tr> 
 </tbody> 
</table>

预期结果为 MySQL 实例容器所在的 Container ID：

4.2、登录 MySQL 实例命令行

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker exec -it cc17df22a908 "/opt/sequoiasql/mysql/bin/mysql" -h 127.0.0.1 -u root </td> 
 </tr> 
 </tbody> 
</table>

其中 \-it 参数为 MySQL 实例的容器 ID，预期结果为：

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> Welcome to the MySQL monitor.&nbsp; Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.25 Source distribution &nbsp; Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. &nbsp; Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. &nbsp; No entry for terminal type "xterm"; using dumb terminal settings. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. &nbsp; mysql&gt; </td> 
 </tr> 
 </tbody> 
</table>

4.3、创建数据库与表，并创建一条测试数据

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> create database sample; use sample; create table t1 ( c1 varchar(100)); insert into t1 values ("SequoiaDB"); select * from t1; </td> 
 </tr> 
 </tbody> 
</table>

预期输出结果为：

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> +-----------+ | c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | +-----------+ | SequoiaDB | +-----------+ 1 row in set (0.02 sec) </td> 
 </tr> 
 </tbody> 
</table>

# 5、创建 Nodejs 服务 #

5.1、创建 **app.js** 文件

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> var express = require('express');&nbsp;&nbsp; //引入express模块 var mysql = require('mysql');&nbsp;&nbsp;&nbsp;&nbsp; //引入mysql模块 var app = express();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //创建express的实例 &nbsp; var connection = mysql.createConnection({&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //创建mysql实例 &nbsp;&nbsp;&nbsp; host:'172.17.0.6', &nbsp;&nbsp;&nbsp; port:'3306', &nbsp;&nbsp;&nbsp; user:'root', &nbsp;&nbsp;&nbsp; password:'', &nbsp;&nbsp;&nbsp; database:'sample' }); var sql = 'SELECT * FROM t1'; connection.connect(); &nbsp; app.get('/',function (req,res) { &nbsp;&nbsp;&nbsp; connection.query(sql, function (err,result) { &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if(err){ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; console.log('[SELECT ERROR]:',err.message); &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; res.send('Hello: ' + result[0].c1 ) ; &nbsp;&nbsp;&nbsp; }); }); app.listen(3000,function () {&nbsp;&nbsp;&nbsp; 监听3000端口 &nbsp;&nbsp;&nbsp; console.log('Server running at 3000 port'); }); </td> 
 </tr> 
 </tbody> 
</table>

代码中的 host 使用 MySQL 实例的 IP 地址。

5.2、创建 **package.json** 文件

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> { &nbsp; "name": "nodetest", &nbsp; "version": "1.0.0", &nbsp; "description": "", &nbsp; "main": "index.js", &nbsp; "scripts": { &nbsp;&nbsp;&nbsp; "test": "echo \"Error: no test specified\" &amp;&amp; exit 1" &nbsp; }, &nbsp; "author": "", &nbsp; "license": "ISC", &nbsp; "dependencies": { &nbsp;&nbsp;&nbsp; "express": "^4.17.1", &nbsp;&nbsp;&nbsp; "mysql": "^2.17.1" &nbsp; } } </td> 
 </tr> 
 </tbody> 
</table>

5.3、创建 **Dockerfile** 文件

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> FROM node:latest RUN mkdir -p /usr/src/ &nbsp; COPY package.json /usr/src/ COPY app.js /usr/src/ WORKDIR /usr/src/ &nbsp; RUN npm install #定义程序默认端口 EXPOSE 3000 #运行程序命令 CMD ["node","app.js"] </td> 
 </tr> 
 </tbody> 
</table>

5.4、当前目录中应仅包含三个文件

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> $ ls -la total 24 drwxr-xr-x&nbsp;&nbsp; 5 sequoiadb&nbsp; staff&nbsp;&nbsp; 160&nbsp; 7 16 15:22 . drwxr-xr-x&nbsp; 94 sequoiadb&nbsp; staff&nbsp; 3008&nbsp; 7 16 10:50 .. -rw-r--r--&nbsp;&nbsp; 1 sequoiadb&nbsp; staff&nbsp;&nbsp; 206&nbsp; 7 16 12:24 Dockerfile -rw-r--r--&nbsp;&nbsp; 1 sequoiadb&nbsp; staff&nbsp;&nbsp; 766&nbsp; 7 16 12:27 app.js -rw-r--r--&nbsp;&nbsp; 1 sequoiadb&nbsp; staff&nbsp;&nbsp; 278&nbsp; 7 16 12:03 package.json </td> 
 </tr> 
 </tbody> 
</table>

5.5、创建 Nodejs 服务镜像

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker build -t nodetest . </td> 
 </tr> 
 </tbody> 
</table>

5.6、运行 Nodejs 服务容器

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> docker run -d -p 3000:3000 nodetest </td> 
 </tr> 
 </tbody> 
</table>

5.7、打开浏览器，连接本地的 3000 端口

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NlcXVvaWFEQl9PZmZpY2lhbA_size_16_color_FFFFFF_t_70 1][]

5.8、更改数据库中的记录，可以看到浏览器显示的内容随之发生调整

<table> 
 <tbody> 
 <tr> 
 <td style="width:414.5pt;"> $ docker exec -it cc17df22a908 "/opt/sequoiasql/mysql/bin/mysql" -h 127.0.0.1 -u root Welcome to the MySQL monitor.&nbsp; Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.25 Source distribution &nbsp; Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. &nbsp; Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. &nbsp; No entry for terminal type "xterm"; using dumb terminal settings. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. &nbsp; mysql&gt; use sample; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A &nbsp; Database changed mysql&gt; update t1 set c1="Node" where c1="SequoiaDB"; Query OK, 1 row affected (0.04 sec) Rows matched: 1&nbsp; Changed: 1&nbsp; Warnings: 0 </td> 
 </tr> 
 </tbody> 
</table>

刷新浏览器后显示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NlcXVvaWFEQl9PZmZpY2lhbA_size_16_color_FFFFFF_t_70 2][]

# 6、小结 #

本文展示了如何通过 SequoiaDB 巨杉数据库的 Docker 容器，结合 Nodejs 快速搭建一个 Web 应用。灵活将分布式数据库结合容器使用，能够使用户快速构建开发测试环境，大幅度降低开发过程中的基础设施维护成本。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NlcXVvaWFEQl9PZmZpY2lhbA_size_16_color_FFFFFF_t_70]: /images/20211201/76b3b7740ee74bfab90bfe9a6a8623da.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NlcXVvaWFEQl9PZmZpY2lhbA_size_16_color_FFFFFF_t_70 1]: /images/20211201/a9e2b297443b46d9966cf60459d29618.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1NlcXVvaWFEQl9PZmZpY2lhbA_size_16_color_FFFFFF_t_70 2]: /images/20211201/5a38d67c70ec49f389d8c45192ecec00.png