1. MongoDB BI Connector参考指南

2. 1. 概述

3. 2. 安装

• 系统: 本文档基于Centos 7.x安装
• mongodb bi connector版本: mongodb-bi-linux-x86_64-rhel70-v2.14.2.tgz

3.1. 2.1 安装要求

安装 mongodb bi connector 需要系统已经安装了 openssl，如未安装，可以使用 yum 命令安装

yum -y install openssl

3.2. 2.2 安装

安装mongodb，非常简单，执行下面的命令，解压即可:

tar -xzvf mongodb-bi-linux-x86_64-rhel70-v2.14.2.tgz

3.3. 2.3 配置

mongosqld 的配置文件使用了 yaml 格式，大部分参数也有对应的命令行参数。

3.3.1. 2.3.1 日志参数

systemLog:
  logAppend: <boolean>
  logRotate: "rename" 或 "reopen"
  path: <string>
  quiet: <boolean>
  verbosity: <integer>

参数说明:

3.3.2. 2.3.2 schema参数

schema:
  path: <string>
  maxVarcharLength: <integer>

参数说明:

3.3.3. 2.3.2 数据样例参数

schema:
  sample:
    size: <integer>
    prejoin: <boolean>
    namespaces: <array of strings>
    uuidSubtype3Encoding: <[old|csharp|java]>
  stored:
    mode: <[custom|auto]>
    source: <string>
    name: <db-name>
  refreshIntervalSecs: <integer>

参数说明:

3.3.4. 2.3.3 Runtime参数

runtime:
  memory:
    maxPerStage: <integer>
    maxPerServer: <integer>
    maxPerConnection: <integer>

参数说明:

3.3.5. 2.3.4 网络参数

net:
  bindIp: <string>
  port: <integer>
  unixDomainSocket:
    enabled: <boolean>
    pathPrefix: <string>
    filePermissions: <string>
  ssl:
    mode: <string>
    allowInvalidCertificates: <boolean>
    PEMKeyFile: <string>
    PEMKeyPassword: <string>
    CAFile: <string>
    minimumTLSVersion: <string>

参数说明:

3.3.6. 2.3.5 安全参数

security:
  enabled: <boolean>
  defaultMechanism: <string>
  defaultSource: <string>
  gssapi:
    hostname: <string>
    serviceName: <string>

参数说明:

3.3.7. 2.3.6 MongoDB主机参数

mongodb:
  versionCompatibility: <string>
  net:
    uri: <string>
    ssl:
      enabled: <boolean>
      allowInvalidCertificates: <boolean>
      allowInvalidHostnames: <boolean>
      PEMKeyFile: <string>
      PEMKeyPassword: <string>
      CAFile: <string>
      CRLFile: <string>
      FIPSMode: <boolean>
    auth:
      username: <username>
      password: <password>
      source: <auth-db-name>
      mechanism: <auth-mechanism>
      gssapiServiceName: <service>

参数说明:

3.3.8. 2.3.7 进程管理参数

processManagement:
  service:
    name: <string>
    displayName: <string>
    description: <string>

参数说明:

3.4. 2.4 配置文件示例

下面是一个配置文件的样例:

systemLog:
  logAppend: false
  path: "/var/log/mongosqld/mongosqld.log"
  verbosity: 2

security:
  enabled: true

mongodb:
  net:
    uri: "mongo.example.com:27017"
    auth:
      username: "root"
      password: "changeme"

net:
  bindIp: 192.0.2.14
  port: 3307
  ssl:
    mode: "allowSSL"
    PEMKeyFile: "/vagrant/certificates/mongosqld-server.pem"
    CAFile: "/vagrant/certificates/ca.crt"

schema:
  sample:
    namespaces: "inventory.*"

processManagement:
  service:
    name: mongosqld
    displayName: mongosqld
    description: "BI Connector SQL proxy server"

4. 3. 启动

1. 使用命令行参数的方式启动

   bin/mongosqld --mongo-uri "mongodb://127.0.0.1:27017" --auth  -u root -p 123456 --addr "0.0.0.0:3307"
   

2. 使用配置文件的方式启动

   bin/mongosqld --config <pathToConfigFile>/mongosqld.conf
   

5. 4. 容器化

5.1. 4.1 制作镜像

1. 编写dockerfile ```dockerfile FROM ubuntu:xenial

COPY mongo* /usr/local/bin/

RUN apt-get update \ && apt-get install -y --no-install-recommends ca-certificates numactl procps gnupg dirmngr gnupg-curl \ && apt-get install -y rsyslog \ && service rsyslog start

EXPOSE 3307

ENTRYPOINT ["mongosqld"]

2. 编写build.sh脚本
```bash
#! /bin/sh

cd $(dirname $0)


set -ex

DOCKER_FILE=mongodb-bi.Dockerfile

IMAGE_NAME=mongodb-bi-connector
IMAGE_VERSION=2.14.2


MONGODB_BI="mongodb-bi-linux-x86_64-ubuntu1604-v${IMAGE_VERSION}"
MONGODB_BI_URL="https://info-mongodb-com.s3.amazonaws.com/mongodb-bi/v2/${MONGODB_BI}.tgz"

wget -N ${MONGODB_BI_URL}

tar -xzvf ${MONGODB_BI}.tgz

docker build -f $DOCKER_FILE -t ${IMAGE_NAME}:${IMAGE_VERSION} ${MONGODB_BI}/bin/

1. 创建镜像 执行如下命令

   sh build.sh
   

5.2. 4.2 启动

假设已经安装了一个mongodb，其安装信息如下

则启动命令如下

docker run --name mongodb-bi -i -t -p 3307:3307 -d  mongodb-bi-connector:2.l4.2 --mongo-uri "mongodb://192.168.1.10:27017" --auth -u mongodb -p mongodb --addr "0.0.0.0:3307"

6. 附录

6.1. 官方网站

https://docs.mongodb.com/bi-connector/current/local-quickstart/