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

https://hub.docker.com/editions/community/docker-ce-desktop-mac

https://docs.docker.com/docker-for-windows/install/

https://docs.docker.com/install/linux/docker-ce/centos/

https://docs.docker.com/install/linux/docker-ce/ubuntu/

docker   pull sequoiadb/sequoiadb :v3.2.1

docker pull sequoiadb/sequoiasql-mysql:v3.2.1

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

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

172.17.0.2

172.17.0.3

172.17.0.4

172.17.0.5

docker   exec coord_catalog "/init.sh" \

        --coord='172.17.0.2:11810' \

        --catalog='172.17.0.2:11800' \

        --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'

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 ''

************ Deploy SequoiaDB   ************************

Create catalog: 172.17.0.2:11800

Create coord:   172.17.0.2:11810

Create data:    172.17.0.3:11820

Create data:    172.17.0.4:11820

Create data:    172.17.0.5:11820

Create data:    172.17.0.4:11830

Create data:    172.17.0.5:11830

Create data:    172.17.0.3:11830

Create data:    172.17.0.5:11840

Create data:    172.17.0.3:11840

Create data:    172.17.0.4:11840

docker   run -it -d -p 3306:3306 --name mysql sequoiadb/sequoiasql-mysql:v3.2.1

docker   inspect --format '{{ .NetworkSettings.IPAddress}}' mysql

172.17.0. 6

docker   exec mysql "/init.sh" --port=3306 --coord='172.17.0.2:11810'

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

docker ps   --filter name=mysql --format {{.ID}}

cc17df22a908

docker   exec -it cc17df22a908 "/opt/sequoiasql/mysql/bin/mysql" -h   127.0.0.1 -u root

Welcome   to the MySQL monitor.  Commands end   with ; or \g.

Your MySQL connection id is 4

Server version: 5.7.25 Source   distribution

Copyright (c) 2000, 2019, Oracle and/or   its affiliates. All rights reserved.

Oracle is a registered trademark of   Oracle Corporation and/or its

affiliates. Other names may be   trademarks of their respective

owners.

No entry for terminal type   "xterm";

using dumb terminal settings.

Type 'help;' or '\h' for help. Type   '\c' to clear the current input statement.

mysql>

create   database sample;

use sample;

create table t1 ( c1 varchar(100));

insert into t1 values ("SequoiaDB");

select * from t1;

+-----------+

| c1        |

+-----------+

| SequoiaDB |

+-----------+

1 row in set (0.02 sec)

var express =   require('express');   // 引入 express 模块

var mysql = require('mysql');       // 引入 mysql 模块

var app = express();        // 创建 express 的实例

var connection = mysql.createConnection({      // 创建 mysql 实例

    host:'172.17.0.6',

    port:'3306',

    user:'root',

    password:'',

    database:'sample'

});

var sql = 'SELECT * FROM t1';

connection.connect();

app.get('/',function (req,res) {

    connection.query(sql, function   (err,result) {

        if(err){

            console.log('[SELECT   ERROR]:',err.message);

        }

        res.send('Hello: ' +   result[0].c1 ) ;

    });

});

app.listen(3000,function () {      //// 监听 3000 端口

    console.log('Server running   at 3000 port');

});

{

    "name": "nodetest",

    "version": "1.0.0",

    "description": "",

    "main": "index.js",

    "scripts": {

      "test": "echo \"Error: no test specified\"   && exit 1"

    },

    "author": "",

    "license": "ISC",

    "dependencies": {

      "express": "^4.17.1",

      "mysql": "^2.17.1"

    }

}

FROM   node:latest

RUN mkdir -p /usr/src/

COPY package.json /usr/src/

COPY app.js /usr/src/

WORKDIR /usr/src/

RUN npm install

# 定义程序默认端口

EXPOSE 3000

# 运行程序命令

CMD   ["node","app.js"]

$ ls -la

total 24

drwxr-xr-x   5 sequoiadb  staff     160  7 16 15:22 .

drwxr-xr-x  94 sequoiadb  staff    3008  7 16 10:50 ..

-rw-r--r--   1 sequoiadb  staff     206  7 16 12:24 Dockerfile

-rw-r--r--   1 sequoiadb  staff     766  7 16 12:27 app.js

-rw-r--r--   1 sequoiadb  staff     278  7 16 12:03 package.json

docker   build -t nodetest .

docker   run -d -p 3000:3000 nodetest

$ docker   exec -it cc17df22a908 "/opt/sequoiasql/mysql/bin/mysql" -h   127.0.0.1 -u root

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 7

Server version: 5.7.25 Source   distribution

Copyright (c) 2000, 2019, Oracle and/or   its affiliates. All rights reserved.

Oracle is a registered trademark of   Oracle Corporation and/or its

affiliates. Other names may be   trademarks of their respective

owners.

No entry for terminal type   "xterm";

using dumb terminal settings.

Type 'help;' or '\h' for help. Type   '\c' to clear the current input statement.

mysql> 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

Database changed

mysql> update t1 set   c1="Node" where c1="SequoiaDB";

Query OK, 1 row affected (0.04 sec)

Rows matched: 1  Changed: 1    Warnings: 0