MongoDB 3.2.4 配置参考
$top
top - 13:00:41 up 2 days, 21:35,3 users,load average: 0.31, 0.23, 0.23
Tasks: 250 total, 1 running, 249 sleeping, 0 stopped, 0 zombie
%Cpu0:0.7 us,1.7 sy,0.0 ni, 97.7>
%Cpu1:5.0 us,7.3 sy,0.0 ni, 87.7>
%Cpu2:1.0 us,1.7 sy,0.0 ni, 97.3>
%Cpu3:0.7 us,1.0 sy,0.0 ni, 98.3>
%Cpu4:5.6 us,7.3 sy,0.0 ni, 87.0>
%Cpu5:0.0 us,0.7 sy,0.0 ni, 99.3>
%Cpu6:0.3 us,1.0 sy,0.0 ni, 98.7>
%Cpu7:5.3 us,7.9 sy,0.0 ni, 86.8>
%Cpu8:0.3 us,1.0 sy,0.0 ni, 98.7>
%Cpu9:1.0 us,2.0 sy,0.0 ni, 97.0>
%Cpu10 :5.3 us,7.0 sy,0.0 ni, 87.7>
%Cpu11 :1.3 us,2.0 sy,0.0 ni, 96.7> KiB Mem:41038580 total,1805648 used, 39232932 free, 319880 buffers
KiB Swap: 0 total, 0 used, 0 free. 469688 cached Mem
$free -m
total used free shared buffers cached
Mem: 40076 1762 38314 8 312 458
-/+ buffers/cache: 991 39085
Swap: 0 0 0
$df -h
Filesystem SizeUsed Avail Use% Mounted on
/dev/mapper/vg00-lv_root 19G3.5G 14G21% /
devtmpfs 20G 0 20G 0% /dev
tmpfs 20G 80K 20G 1% /dev/shm
tmpfs 20G8.9M 20G 1% /run
tmpfs 20G 0 20G 0% /sys/fs/cgroup
/dev/sda1 969M 95M809M11% /boot
/dev/mapper/vg00-lv_data 40G1.3G 80G 4% /data
/dev/mapper/vg00-lv_app 21G328M 19G 2% /app
echo -ne "
10.78.200.105 vq12stmsg01
10.78.200.106 vq12stmsg02
10.78.200.107 vq12stmsg03
" >>/etc/hosts
mkdir -p /app/logs/
105:
mkdir -p /data/mdb/{mdb1_1,mdb1_1/repair,mdb2_2,mdb2_2/repair,mdb3_3,mdb3_3/repair}
mkdir -p /data/configdb/configdb1_1/repair
106:
mkdir -p /data/mdb/{mdb1_3,mdb1_3/repair,mdb2_1,mdb2_1/repair,mdb3_2,mdb3_2/repair}
mkdir -p /data/configdb/configdb2_1/repair
107:
mkdir -p /data/mdb/{mdb1_2,mdb1_2/repair,mdb2_3,mdb2_3/repair,mdb3_1,mdb3_1/repair}
mkdir -p /data/configdb/configdb3_1/repair
systemctl stop firewalld.service
systemctl disable firewalld.service
openssl rand -base64 741 > /app/conf/keyfile
chmod 600 /app/mongodb/conf/keyfile
copy keyfile文件到各个节点
主机环境变量及参数,参考
$cat /etc/rc.local
.....
#####MongoDB#####
sleep 2
blockdev --setra 32 /dev/mapper/vg00-lv_data
sleep 2
echo '512' > /sys/block/sdb/queue/nr_requests
sleep 2
echo 0 > /proc/sys/vm/zone_reclaim_mode
#####blockdev --report /dev/mapper/vg00-lv_data
#chown mongo:dba -R /app/
#chown mongo:dba -R /data/
#####MongoDB#####
$cat /etc/fstab
#
# /etc/fstab
# Created by anaconda on Wed Mar 16 06:50:02 2016
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg00-lv_root / ext3 defaults 1 1
/dev/mapper/vg00-lv_app/app ext3 defaults 1 2
UUID=4f86d0d2-a559-4f07-8a91-a605e0005f5c /boot ext3 defaults 1 2
/dev/mapper/vg00-lv_data /data ext4 noatime 0 0
$cat /etc/security/limits.conf
mongo soft nofile65535
mongo hard nofile65535
mongo soft nproc 65535
mongo hard nproc 65535
关闭透明页
https://docs.mongodb.org/manual/tutorial/transparent-huge-pages/
https://docs.mongodb.org/manual/administration/production-checklist/
$cat .bash_profile
...
#####add by mongoDB#####
export LANG=en_US
export PATH=$PATH:/app/mongodb_3_2_4/bin
set -o vi
stty erase ^H
umask 022
export HISTTIMEFORMAT=`whoami`" : %h/%d - %H:%M:%S "
export PS1='\n\e\e[m\e[1;36m\e[m\n\$'
alias 'l=ls -altr'
alias 'cdm=cd /app/mongodb_3_2_4'
alias 'cdl=cd /app/logs'
alias 'cdc=cd /app/conf'
alias 'cddb=cd /data/'
alias 'mongosstart=numactl --interleave=all mongos --config=/app/conf/mongos1.conf'
alias 'configstart=numactl --interleave=all mongod --config=/app/conf/configsvr1_1.conf'
alias 'mongodstart1=numactl --interleave=all mongod --config=/app/conf/shardsvr1_1.conf'
alias 'mongodstart2=numactl --interleave=all mongod --config=/app/conf/shardsvr2_2.conf'
alias 'mongodstart3=numactl --interleave=all mongod --config=/app/conf/shardsvr3_3.conf'
alias "mongosstop=ps -ef | grep -v grep | grep mongos | cut -c 9-15 | xargs kill -2"
alias "mongodstop=ps -ef | grep -v grep | grep shardsvr | grep mongod | cut -c 9-15 | xargs kill -2"
alias "mongocfgstop=ps -ef | grep -v grep | grep configsvr | cut -c 9-15 | xargs kill -2"
#####add by mongoDB#####
$cat configsvr1_1.conf
systemLog:
destination: file
path: "/app/logs/configsvr1_1.log"
logAppend: true
storage:
dbPath: "/data/configdb/configdb1_1"
repairPath: "/data/configdb/configdb1_1/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 1
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.105
port: 20000
sharding:
clusterRole: configsvr
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 5000
$cat mongos1.conf
systemLog:
destination: file
path: /app/logs/mongos1.log
logAppend: true
net:
bindIp: 127.0.0.1,10.78.200.105
port: 10000
processManagement:
fork: true
replication:
localPingThresholdMs: 15
sharding:
configDB: 10.78.200.105:20000,10.78.200.106:20000,10.78.200.107:20000
chunkSize: 64
security:
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 5000
$cat shardsvr1_1.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr1_1.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb1_1/"
repairPath: "/data/mdb/mdb1_1/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.105
port: 30001
replication:
oplogSizeMB: 10240
replSetName: pns1
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
$cat shardsvr2_2.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr2_2.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb2_2/"
repairPath: "/data/mdb/mdb2_2/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.105
port: 30002
replication:
oplogSizeMB: 10240
replSetName: pns2
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
$cat shardsvr3_3.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr3_3.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb3_3/"
repairPath: "/data/mdb/mdb3_3/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.105
port: 30003
replication:
oplogSizeMB: 10240
replSetName: pns3
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
106主机环境变量及参数:
#####add by mongoDB#####
export LANG=en_US
export PATH=$PATH:/app/mongodb_3_2_4/bin
set -o vi
stty erase ^H
umask 022
export HISTTIMEFORMAT=`whoami`" : %h/%d - %H:%M:%S "
export PS1='\n\e\e[m\e[1;36m\e[m\n\$'
alias 'l=ls -altr'
alias 'cdm=cd /app/mongodb_3_2_4'
alias 'cdl=cd /app/logs'
alias 'cdc=cd /app/conf'
alias 'cddb=cd /data/'
alias 'mongosstart=numactl --interleave=all mongos --config=/app/conf/mongos2.conf'
alias 'configstart=numactl --interleave=all mongod --config=/app/conf/configsvr1_2.conf'
alias 'mongodstart1=numactl --interleave=all mongod --config=/app/conf/shardsvr1_3.conf'
alias 'mongodstart2=numactl --interleave=all mongod --config=/app/conf/shardsvr2_1.conf'
alias 'mongodstart3=numactl --interleave=all mongod --config=/app/conf/shardsvr3_2.conf'
alias "mongosstop=ps -ef | grep -v grep | grep mongos | cut -c 9-15 | xargs kill -2"
alias "mongodstop=ps -ef | grep -v grep | grep shardsvr | grep mongod | cut -c 9-15 | xargs kill -2"
alias "mongocfgstop=ps -ef | grep -v grep | grep configsvr | cut -c 9-15 | xargs kill -2"
#####add by mongoDB#####
# ll
total 24
-rw-r--r-- 1 mongo dba859 Mar 24 15:47 configsvr1_2.conf
-rw------- 1 mongo dba 1004 Mar 24 11:02 keyfile
-rw-r--r-- 1 mongo dba527 Mar 24 15:40 mongos2.conf
-rw-r--r-- 1 mongo dba930 Mar 24 15:47 shardsvr1_3.conf
-rw-r--r-- 1 mongo dba928 Mar 24 15:48 shardsvr2_1.conf
-rw-r--r-- 1 mongo dba930 Mar 24 15:48 shardsvr3_2.conf
# cat configsvr1_2.conf
systemLog:
destination: file
path: "/app/logs/configsvr2_1.log"
logAppend: true
storage:
dbPath: "/data/configdb/configdb2_1"
repairPath: "/data/configdb/configdb2_1/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 1
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.106
port: 20000
sharding:
clusterRole: configsvr
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 5000
# cat mongos2.conf
systemLog:
destination: file
path: /app/logs/mongos2.log
logAppend: true
net:
bindIp: 127.0.0.1,10.78.200.106
port: 10000
processManagement:
fork: true
replication:
localPingThresholdMs: 15
sharding:
configDB: 10.78.200.105:20000,10.78.200.106:20000,10.78.200.107:20000
chunkSize: 64
security:
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 5000
# cat shardsvr1_3.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr1_3.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb1_3/"
repairPath: "/data/mdb/mdb1_3/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.106
port: 30003
replication:
oplogSizeMB: 10240
replSetName: pns1
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
# cat shardsvr2_1.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr2_1.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb2_1/"
repairPath: "/data/mdb/mdb2_1/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.106
port: 30001
replication:
oplogSizeMB: 10240
replSetName: pns2
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
# cat shardsvr3_2.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr3_2.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb3_2/"
repairPath: "/data/mdb/mdb3_2/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.106
port: 30002
replication:
oplogSizeMB: 10240
replSetName: pns3
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
#
107主机环境变量及参数:
#####add by mongoDB#####
export LANG=en_US
export PATH=$PATH:/app/mongodb_3_2_4/bin
set -o vi
stty erase ^H
umask 022
export HISTTIMEFORMAT=`whoami`" : %h/%d - %H:%M:%S "
export PS1='\n\e\e[m\e[1;36m\e[m\n\$'
alias 'l=ls -altr'
alias 'cdm=cd /app/mongodb_3_2_4'
alias 'cdl=cd /app/logs'
alias 'cdc=cd /app/conf'
alias 'cddb=cd /data/'
alias 'mongosstart=numactl --interleave=all mongos --config=/app/conf/mongos3.conf'
alias 'configstart=numactl --interleave=all mongod --config=/app/conf/configsvr1_3.conf'
alias 'mongodstart1=numactl --interleave=all mongod --config=/app/conf/shardsvr1_2.conf'
alias 'mongodstart2=numactl --interleave=all mongod --config=/app/conf/shardsvr2_3.conf'
alias 'mongodstart3=numactl --interleave=all mongod --config=/app/conf/shardsvr3_1.conf'
alias "mongosstop=ps -ef | grep -v grep | grep mongos | cut -c 9-15 | xargs kill -2"
alias "mongodstop=ps -ef | grep -v grep | grep shardsvr | grep mongod | cut -c 9-15 | xargs kill -2"
alias "mongocfgstop=ps -ef | grep -v grep | grep configsvr | cut -c 9-15 | xargs kill -2"
#####add by mongoDB#####
# ll
total 24
-rw-r--r-- 1 mongo dba861 Mar 24 15:45 configsvr1_3.conf
-rw------- 1 mongo dba 1004 Mar 24 11:02 keyfile
-rw-r--r-- 1 mongo dba526 Mar 24 15:46 mongos3.conf
-rw-r--r-- 1 mongo dba930 Mar 24 15:46 shardsvr1_2.conf
-rw-r--r-- 1 mongo dba930 Mar 24 15:47 shardsvr2_3.conf
-rw-r--r-- 1 mongo dba930 Mar 24 15:47 shardsvr3_1.conf
# cat configsvr1_3.conf
systemLog:
destination: file
path: "/app/logs/configsvr3_1.log"
logAppend: true
storage:
dbPath: "/data/configdb/configdb3_1"
repairPath: "/data/configdb/configdb3_1/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 1
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.107
port: 20000
sharding:
clusterRole: configsvr
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 5000
# cat mongos3.conf
systemLog:
destination: file
path: /app/logs/mongos3.log
logAppend: true
net:
bindIp: 127.0.0.1,10.78.200.107
port: 10000
processManagement:
fork: true
replication:
localPingThresholdMs: 15
sharding:
configDB: 10.78.200.105:20000,10.78.200.106:20000,10.78.200.107:20000
chunkSize: 64
security:
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 5000
# cat shardsvr1_2.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr1_2.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb1_2/"
repairPath: "/data/mdb/mdb1_2/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.107
port: 30002
replication:
oplogSizeMB: 10240
replSetName: pns1
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
# cat shardsvr2_3.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr2_3.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb2_3/"
repairPath: "/data/mdb/mdb2_3/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.107
port: 30003
replication:
oplogSizeMB: 10240
replSetName: pns2
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
# cat shardsvr3_1.conf
systemLog:
destination: file
path: "/app/logs/sharedsvr3_1.log"
logAppend: true
storage:
dbPath: "/data/mdb/mdb3_1/"
repairPath: "/data/mdb/mdb3_1/repair"
journal:
enabled: true
commitIntervalMs: 100
directoryPerDB: true
syncPeriodSecs: 60
engine: wiredTiger
wiredTiger:
engineConfig:
cacheSizeGB: 10
journalCompressor: snappy
directoryForIndexes: true
collectionConfig:
blockCompressor: snappy
indexConfig:
prefixCompression: true
processManagement:
fork: true
net:
bindIp: 127.0.0.1,10.78.200.107
port: 30001
replication:
oplogSizeMB: 10240
replSetName: pns3
sharding:
clusterRole: shardsvr
archiveMovedChunks: false
security:
authorization: disabled
clusterAuthMode: keyFile
keyFile: /app/conf/keyfile
setParameter:
enableLocalhostAuthBypass: true
authenticationMechanisms: SCRAM-SHA-1
connPoolMaxShardedConnsPerHost: 200
connPoolMaxConnsPerHost: 15000
分片/副本集配置:
mongo 127.0.0.1:30001
rs.initiate()
rs.add("10.78.200.107:30002")
rs.add("10.78.200.106:30003")
rs.conf()
mongo 127.0.0.1:30001
rs.initiate()
rs.add("10.78.200.105:30002")
rs.add("10.78.200.107:30003")
rs.conf()
mongo 127.0.0.1:30001
rs.initiate()
rs.add("10.78.200.106:30002")
rs.add("10.78.200.105:30003")
rs.conf()
mongo 127.0.0.1:10000
use admin
sh.addShard( "pns1/10.78.200.105:30001,10.78.200.107:30002,10.78.200.106:30003" )
sh.addShard( "pns2/10.78.200.106:30001,10.78.200.105:30002,10.78.200.107:30003" )
sh.addShard( "pns3/10.78.200.107:30001,10.78.200.106:30002,10.78.200.105:30003" )
db.runCommand({listshards:1})
用户及权限:
use admin
db.createUser(
{
user: "admin",
pwd: "xxxxxx",
roles: [ { role: "root", db: "admin" },{ role: "clusterManager", db: "admin" } ,{ role: "clusterMonitor", db: "admin" },{ role: "hostManager", db: "admin" } ]
}
)
db.updateUser( "admin",
{
roles: [ { role: "root", db: "admin" },{ role: "dbAdminAnyDatabase", db: "admin" },{"role" : "readWriteAnyDatabase",db: "admin" }, { role: "userAdminAnyDatabase", db: "admin" },{ role: "clusterManager", db: "admin" } ,{ role: "clusterMonitor", db: "admin" },{ role: "hostManager", db: "admin" } ]
}
);
mongo 10.78.200.107:10000/admin -u admin -p xxxxxx
--db.auth("admin","xxxxxx")
mongo 10.78.200.107:10000/mdb -u pns -p xxxxxx
mongostat -h 10.78.200.107:30001 -u admin -p xxxxxx --discover --authenticationDatabase admin 1
mongotop -h 10.78.200.107:30001 -u admin -p xxxxxx --authenticationDatabase admin
mongo 10.78.200.107:30001-u pns -p xxxxxx --eval "printjson(db.printSlaveReplicationInfo())"
mongo 127.0.0.1:10000
use admin
db.runCommand({"enablesharding":"mdb"})
db.runCommand({"shardcollection":"mdb.mcUser293","key":{"_id":"hashed"}})
db.runCommand({shardcollection:"mdb.mcUser293", key:{_id:1}})
use mdb
for(var i=1;i
页:
[1]