mongodb 存储shard

ゞ浴缸里的玫瑰 2022-07-12 23:13 120阅读 0赞

1. 安装

https://docs.mongodb.com/manual/tutorial/install-mongodb-on-ubuntu/

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 0C49F3730359A14518585931BC711F9BA15703C6
    echo "deb http://repo.mongodb.org/apt/ubuntu trusty/mongodb-org/3.4 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-3.4.list
    sudo apt-get update
    apt-get install -y mongodb-org

2. 配置

端口说明：

sharding   27018                        /etc/mongod\_d.conf

configsvr  27019                        /etc/mongod\_c.conf

mongos   27017                       /etc/mongod\_s.conf

存储说明：

sharding      dbpath  /opt/data/mongodbd   log /opt/log/mongodbd/mongod.log

configsvr      dbpath /opt/data/mongodbc  log  /opt/log/mongodbc/mongod.log

操作

mkdir -p /opt/data/mongodbd

mkdir -p /opt/data/mongodbc

mkdir -p /opt/log/mongodbd

mkdir -p /opt/log/mongodbc

mkdir -p /opt/log/mongodbs

修改配置

启动配置副本集
    /usr/bin/mongod -f /etc/mongod_c.conf
    启动sharding副本集
    /usr/bin/mongod -f /etc/mongod_d.conf
    启动mongos
    /usr/bin/mongos -f /etc/mongod_s.conf

2.1 配置config副本集以及sharding副本集

连接

mongo localhost:27019

初使化

rs.initiate()

cfg= rs.conf()

cfg.members[0].host="cluster6.l.com:27018"

rs.reconfig(cfg)

副本集添加节点

rs.add("cluster6.l.com:27019")

rs.add("cluster32.l.com:27018")

查看状态

rs.status()

2.2  shard 配置

https://docs.mongodb.com/manual/tutorial/deploy-sharded-cluster-hashed-sharding/

把sharding副本集添加到集群中

sh.addShard("<replSetName>/s1-mongo1.example.net:27017")

sh.addShard("rs0/cluster1.l.com:27018,cluster2.l.com:27018,cluster3.l.com:27018")

sh.addShard("rs0/cluster6.l.com:27018,cluster32.l.com:27018")

查看分片信息

use admin

db.runCommand({listshards:1})

开始分布存储数据库

sh.enableSharding("<database>")

生成集群节点通讯用的加密

openssl rand -base64 741 > /opt/data/mongodb-keyfile  
    chmod 600 /data/mongodb/mongodb-keyfile

复制到所有集群节点中

在不开启认证情况下面配置数据库用户

use admin
    db.createUser( {
        user: "admin",
        pwd: "abc123",
        roles: [ { role: "userAdminAnyDatabase", db: "admin" } ]
      });

配置文件备份说明：

mongd\_c.conf

# mongod.conf
    
    # for documentation of all options, see:
    #   http://docs.mongodb.org/manual/reference/configuration-options/
    
    # Where and how to store data.
    storage:
      dbPath: /opt/data/mongodbc
      journal:
        enabled: true
    #  engine:
    #  mmapv1:
    #  wiredTiger:
    
    # where to write logging data.
    systemLog:
      destination: file
      logAppend: true
      path: /opt/log/mongodbc/mongod.log
    
    # network interfaces
    net:
      port: 27019
     # bindIp: 127.0.0.1
      ipv6: true
    
    processManagement:
      fork: true
    
    #security:
      authorization: enabled
      keyFile: /opt/data/mongodb-keyfile
    #operationProfiling:
    
    replication:
      replSetName: mongodb_c
    sharding:
      clusterRole: configsvr
    ## Enterprise-Only Options:
    
    #auditLog:
    
    #snmp:

mongd\_d.conf

# mongod.conf
    
    # for documentation of all options, see:
    #   http://docs.mongodb.org/manual/reference/configuration-options/
    
    # Where and how to store data.
    storage:
      dbPath: /opt/data/mongodbd
      journal:
        enabled: true
    #  engine:
    #  mmapv1:
    #  wiredTiger:
    
    # where to write logging data.
    systemLog:
      destination: file
      logAppend: true
      path: /opt/log/mongodbd/mongod.logv
    
    # network interfaces
    net:
      port: 27018
    #  bindIp: 127.0.0.1
      ipv6: true
    
    processManagement:
      fork: true
    security:
      authorization: enabled
      keyFile: /opt/data/mongodb-keyfile
    #operationProfiling:
    
    replication:
      replSetName: rs0
    sharding:
      clusterRole: shardsvr
    ## Enterprise-Only Options:
    
    #auditLog:
    
    #snmp:

mongd\_s.conf

# mongod.conf
    
    # for documentation of all options, see:
    #   http://docs.mongodb.org/manual/reference/configuration-options/
    
    # Where and how to store data.
    
    # where to write logging data.
    systemLog:
      destination: file
      logAppend: true
      path: /opt/log/mongodbs/mongod.log
    
    # network interfaces
    net:
      port: 27017
    # bindIp: 127.0.0.1
      ipv6: true
    
    processManagement:
      fork: true
    security:
      keyFile: /opt/data/mongodb-keyfile
    #operationProfiling:
    
    #replication:
    
    sharding:
      configDB: mongodb_c/cluster6.l.com:27019,cluster32.l.com:27019
    
    ## Enterprise-Only Options:
    
    #auditLog:
    
    #snmp:

在second 副本集中 查看数据

db.getMongo().setSlaveOk();

认证命令行：

mongo -u admin -p abc123 -authencationDatabase admin

说明：

如果远程连接认证失败解决方案

http://www.aichengxu.com/os/11074020.htm

参考：http://blog.csdn.net/monkey\_four/article/details/50854410

https://my.oschina.net/u/2277929/blog/780328