公司的实战mongodb Replica Sets+Sharding方案采用配置文件2

来源：互联网发布：苹果手机美颜软件编辑：程序博客网时间：2024/05/16 11:20

公司mongo集群分片实战

服务器三台

主机1（172.16.0.115）主机2（172.16.0.114）主机3（172.16.0.103）

第一片(11731) 主副本仲裁

第二片(11732) 仲裁主副本

第三片(11733) 副本仲裁主

30000 config Server config Server config Server

60000 Route Process Route Process Route Process

创建数据库目录

主机1（172.16.0.115）配置文件

[root@mongodb115 ~]# mkdir -p /home/data/shard1_1

[root@mongodb115 ~]# mkdir -p /home/data/shard2_1

[root@mongodb115 ~]# mkdir -p /home/data/shard3_1

[root@mongodb115 ~]# mkdir -p /home/data/config #config server目录

[root@mongodb115 ~]# mkdir -p /home/config #放配置文件

[root@mongodb115 ~]# mkdir -p /home/data/logs

分片1

[root@mongodb115 config]# cat shard1_1.conf

port=11731

dbpath=/home/data/shard1_1

logpath=/home/data/logs/shard1_1.log

directoryperdb=true

logappend=true

replSet=shard1

#bind_ip=172.16.0.115

shardsvr=true

fork=true

pidfilepath=/home/data/shard1_1.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

分片2

[root@mongodb115 config]# cat shard2_1.conf

port=11732

dbpath=/home/data/shard2_1

logpath=/home/data/logs/shard2_1.log

directoryperdb=true

logappend=true

replSet=shard2

#bind_ip=172.16.0.115

shardsvr=true

fork=true

pidfilepath=/home/data/shard2_1.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

分片3

[root@mongodb115 config]# cat shard3_1.conf

port=11733

dbpath=/home/data/shard3_1

logpath=/home/data/logs/shard3_1.log

directoryperdb=true

logappend=true

replSet=shard3

#bind_ip=172.16.0.115

shardsvr=true

fork=true

pidfilepath=/home/data/shard3_1.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

config server 配置文件

[root@mongodb115 config]# cat config.conf

port=30000

dbpath=/home/data/config

logpath=/home/data/logs/config.log

directoryperdb=true

configsvr=true

logappend=true

#bind_ip=172.16.0.115

fork=true

pidfilepath=/home/data/config.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

Route Proces配置文件

[root@mongodb115 config]# cat mongos.conf

port=60000

logpath=/home/data/logs/mongos.log

logappend=true

configdb=172.16.0.115:30000,172.16.0.114:30000,172.16.0.103:30000

#bind_ip=172.16.0.115

fork=true

pidfilepath=/home/data/mongos.pid

chunkSize=100

maxConns=20000

nohttpinterface=true

主机2（172.16.0.114）配置文件

[root@mongodb114 ~]# mkdir -p /home/data/shard1_2

[root@mongodb114 ~]# mkdir -p /home/data/shard2_2

[root@mongodb114 ~]# mkdir -p /home/data/shard3_2

[root@mongodb114 ~]# mkdir -p /home/data/config #config server目录

[root@mongodb114 ~]# mkdir -p /home/config #放配置文件

[root@mongodb114 ~]# mkdir -p /home/data/logs

分片1

[root@mongodb114 config]# cat shard1_2.conf

port=11731

dbpath=/home/data/shard1_2

logpath=/home/data/logs/shard1_2.log

directoryperdb=true

logappend=true

replSet=shard1

#bind_ip=172.16.0.114

shardsvr=true

fork=true

pidfilepath=/home/data/shard1_2.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

分片2

[root@mongodb114config]# cat shard2_2.conf

port=11732

dbpath=/home/data/shard2_2

logpath=/home/data/logs/shard2_2.log

directoryperdb=true

logappend=true

replSet=shard2

#bind_ip=172.16.0.114

shardsvr=true

fork=true

pidfilepath=/home/data/shard2_2.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

分片3

[root@mongodb114 config]# cat shard3_2.conf

port=11733

dbpath=/home/data/shard3_2

logpath=/home/data/logs/shard3_2.log

directoryperdb=true

logappend=true

replSet=shard3

#bind_ip=172.16.0.114

shardsvr=true

fork=true

pidfilepath=/home/data/shard3_2.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

config server 配置文件

[root@mongodb114 config]# cat config.conf

port=30000

dbpath=/home/data/config

logpath=/home/data/logs/config.log

directoryperdb=true

configsvr=true

logappend=true

#bind_ip=172.16.0.114

fork=true

pidfilepath=/home/data/config.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

Route Proces配置文件

[root@mongodb114 config]# cat mongos.conf

port=60000

logpath=/home/data/logs/mongos.log

logappend=true

configdb=172.16.0.115:30000,172.16.0.114:30000,172.16.0.103:30000

#bind_ip=172.16.0.114

fork=true

pidfilepath=/home/data/mongos.pid

chunkSize=100

maxConns=20000

nohttpinterface=true

主机3（172.16.0.103）配置文件

[root@mongodb103 ~]# mkdir -p /home/data/shard1_3

[root@mongodb103 ~]# mkdir -p /home/data/shard2_3

[root@mongodb103 ~]# mkdir -p /home/data/shard3_3

[root@mongodb103 ~]# mkdir -p /home/data/config #config server目录

[root@mongodb103 ~]# mkdir -p /home/config #放配置文件

[root@mongodb103 ~]# mkdir -p /home/data/logs

分片1

[root@mongodb103 config]# cat shard1_3.conf

port=11731

dbpath=/home/data/shard1_3

logpath=/home/data/logs/shard1_3.log

directoryperdb=true

logappend=true

replSet=shard1

#bind_ip=172.16.0.103

shardsvr=true

fork=true

pidfilepath=/home/data/shard1_3.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

分片2

[root@mongodb103 config]# cat shard2_3.conf

port=11732

dbpath=/home/data/shard2_3

logpath=/home/data/logs/shard2_3.log

directoryperdb=true

logappend=true

replSet=shard2

#bind_ip=172.16.0.103

shardsvr=true

fork=true

pidfilepath=/home/data/shard2_3.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

分片3

[root@mongodb103 config]# cat shard3_3.conf

port=11733

dbpath=/home/data/shard3_3

logpath=/home/data/logs/shard3_3.log

directoryperdb=true

logappend=true

replSet=shard3

#bind_ip=172.16.0.103

shardsvr=true

fork=true

pidfilepath=/home/data/shard3_3.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

config server 配置文件

[root@mongodb103 config]# cat config.conf

port=30000

dbpath=/home/data/config

logpath=/home/data/logs/config.log

directoryperdb=true

configsvr=true

logappend=true

#bind_ip=172.16.0.103

fork=true

pidfilepath=/home/data/config.pid

maxConns=20000

oplogSize=5000

noprealloc=true

nohttpinterface=true

Route Proces配置文件

[root@mongodb103 config]# cat mongos.conf

port=60000

logpath=/home/data/logs/mongos.log

logappend=true

configdb=172.16.0.115:30000,172.16.0.114:30000,172.16.0.103:30000

#bind_ip=172.16.0.103

fork=true

pidfilepath=/home/data/mongos.pid

chunkSize=100

maxConns=20000

nohttpinterface=true

解压mongodb文件

主机1

[root@mongodb115 ~]# tar zxvf mongodb-linux-x86_64-2.4.7.tgz

[root@mongodb115 ~]# mv mongodb-linux-x86_64-2.4.7 /home/mongodb

主机2

[root@mongodb114 ~]# tar zxvf mongodb-linux-x86_64-2.4.7.tgz

[root@mongodb114 ~]# mv mongodb-linux-x86_64-2.4.7 /home/mongodb

主机3

[root@mongodb103 ~]# tar zxvf mongodb-linux-x86_64-2.4.7.tgz

[root@mongodb103 ~]# mv mongodb-linux-x86_64-2.4.7 /home/mongodb

启动shard1,shard2,shard3

主机1

[root@mongodb115 ~]# /home/mongodb/bin/mongod -f /home/config/shard1_1.conf

[root@mongodb115 ~]# /home/mongodb/bin/mongod -f /home/config/shard2_1.conf

[root@mongodb115 ~]# /home/mongodb/bin/mongod -f /home/config/shard3_1.conf

主机2

[root@mongodb114 ~]# /home/mongodb/bin/mongod -f /home/config/shard1_2.conf

[root@mongodb114 ~]# /home/mongodb/bin/mongod -f /home/config/shard2_2.conf

[root@mongodb114 ~]# /home/mongodb/bin/mongod -f /home/config/shard3_2.conf

主机3

[root@mongodb103 ~]# /home/mongodb/bin/mongod -f /home/config/shard1_3.conf

[root@mongodb103 ~]# /home/mongodb/bin/mongod -f /home/config/shard2_3.conf

[root@mongodb103 ~]# /home/mongodb/bin/mongod -f /home/config/shard3_3.conf

配置Replica Sets

配置分片1 在172.16.0.115上配置

[root@mongodb115 ~]# /home/mongodb/bin/mongo --port 11731

MongoDB shell version: 2.4.7

connecting to: 127.0.0.1:11731/test

>config={_id:'shard1',members:[{_id:0,host:'172.16.0.115:11731',priority:2},{_id:1,host:'172.16.0.114:11731'},{_id:2,host:'172.16.0.103:11731',arbiterOnly:true}]}

rs.initiate(config)

配置分片2 在172.16.0.114上配置

[root@mongodb114 ~]# /home/mongodb/bin/mongo --port 11732

MongoDB shell version: 2.4.7

connecting to: 127.0.0.1:11732/test

>config={_id:'shard2',members:[{_id:0,host:'172.16.0.115:11732',arbiterOnly:true},{_id:1,host:'172.16.0.114:11732',priority:2},{_id:2,host:'172.16.0.103:11732' }]}

rs.initiate(config)

配置分片3 在172.16.0.103上配置 members里面的优先级priority值高的为主节点，对于仲裁点一定要加上arbiterOnly:true

[root@mongodb103 ~]# /home/mongodb/bin/mongo --port 11733

MongoDB shell version: 2.4.7

connecting to: 127.0.0.1:11733/test

>config={_id:'shard3',members:[{_id:0,host:'172.16.0.115:11733'},{_id:1,host:'172.16.0.114:11733',arbiterOnly:true },{_id:2,host:'172.16.0.103:11733',priority:2 }]}

rs.initiate(config)

启动3台config server

主机1

[root@mongodb115 ~]# /home/mongodb/bin/mongod -f /home/config/config.conf

主机2

[root@mongodb114 ~]# /home/mongodb/bin/mongod -f /home/config/config.conf

主机3

[root@mongodb103 ~]# /home/mongodb/bin/mongod -f /home/config/config.conf

启动3台 Route Process

主机1

[root@mongodb115 ~]# /home/mongodb/bin/mongos -f /home/config/mongos.conf

主机2

[root@mongodb114 ~]# /home/mongodb/bin/mongos -f /home/config/mongos.conf

主机3

[root@mongodb103 ~]# /home/mongodb/bin/mongos -f /home/config/mongos.conf

配置shard Cluser

[root@mongodb115 ~]# /home/mongodb/bin/mongo --port 60000

MongoDB shell version: 2.4.7

connecting to: 127.0.0.1:60000/test

mongos> use admin

switched to db admin

mongos>db.runCommand({addshard:"shard1/172.16.0.115:11731, 172.16.0.114:11731, 172.16.0.103:11731", name:"shard1",maxsize:2048});

mongos>db.runCommand({addshard:"shard2/172.16.0.115:11732, 172.16.0.114:11732, 172.16.0.103:11732", name:"shard2",maxsize:2048});

mongos> db.runCommand({addshard:"shard3/172.16.0.115:11733, 172.16.0.114:11733, 172.16.0.103:11733", name:"shard3",maxsize:2048});

接下来激活分片，如下面的代码所示：采用hash分片

db.runCommand({enablesharding:"test"})

db.runCommand({shardcollection:"test.users",key:{id:"hashed"}})

强调服务时间必须要同步，否则有问题

0 0