MongoDB登录

登录mongos

#超级管理员
/usr/local/mongodb/bin/mongo --host 127.0.0.1 --port 27011 -u uadm --authenticationDatabase "admin" -p 'bxcuIa7c00zjTOEz'
/usr/local/mongodb/bin/mongo --host 120.78.67.107 --port 27011 -u ukline --authenticationDatabase "admin" -p 'pKaMGhHkC8yZDrFh'



#公网登录，测试新加坡服务是否能连接深圳
/usr/local/mongodb/bin/mongo --host 39.108.195.15 --port 27011 -u uadm --authenticationDatabase "admin" -p 'bxcuIa7c00zjTOEz'
/usr/local/mongodb/bin/mongo --host 47.107.99.166 --port 27011 -u uadm --authenticationDatabase "admin" -p 'bxcuIa7c00zjTOEz'
/usr/local/mongodb/bin/mongo --host 39.108.17.53 --port 27011 -u uadm --authenticationDatabase "admin" -p 'bxcuIa7c00zjTOEz'

#超级管理员-交互模式下登录
mongos> db.auth("uadm", "bxcuIa7c00zjTOEz")

#数据库用户
/usr/local/mongodb/bin/mongo --host 127.0.0.1 --port 27011 -u ukline --authenticationDatabase "admin" -p 'pKaMGhHkC8yZDrFh'
/usr/local/mongodb/bin/mongo --host 39.108.17.53 --port 27011 -u ukline --authenticationDatabase "admin" -p 'pKaMGhHkC8yZDrFh'


use admin;
db.createUser({ user:"uadm", pwd:"bxcuIa7c00zjTOEz", roles:[{role: "root", db: "admin"}] });
db.createUser({user:'uklinedev',pwd:'devpKaMGhHkC8yZDrFh',roles:['readWriteAnyDatabase']});
db.createUser({user:'ukline',pwd:'pKaMGhHkC8yZDrFh',roles:['readWriteAnyDatabase']});
db.createUser({user:'aibv_im_user',pwd:'nspV9jbWlNDsWSUo',roles:[{ role: "readWrite", db: "aibv_im" }, "readWrite"]});


mongodump --host 127.0.0.1:27017 -u ukline -p pKaMGhHkC8yZDrFh --authenticationDatabase=admin --db=kline_hb -o /tmp/mongodb/
/usr/local/mongodb/tools/bin/mongorestore -h 127.0.0.1:27011 -u admin -p pKaMGhHkC8yZDrFh --authenticationDatabase admin /data/backup/lighthouses_mongodb/test/

#MongoDB Compass工具登录
mongodb://uadm:bxcuIa7c00zjTOEz@47.107.99.166:27011/admin
mongodb://uadm:bxcuIa7c00zjTOEz@39.108.195.15:27011/admin
mongodb://uadm:bxcuIa7c00zjTOEz@39.108.17.53:27011/admin

策略、指标访问（胡方东）
外网：39.108.195.15
内网：172.23.143.207
端口：27011
用户名：coec_stock_user
密码：nztDWh5khCCu0mWv
数据库：kline_hb、kline_ba、kline_okx
mongos> use admin;
mongos> db.createUser({user:'coec_stock_user',pwd:'nztDWh5khCCu0mWv',roles:['readAnyDatabase']});

#登录
/usr/local/mongodb/bin/mongo --host 120.78.67.107 --port 27011 -u coec_stock_user --authenticationDatabase "admin" -p 'nztDWh5khCCu0mWv'

ansible工具查看各服务器进程情况

ansible mg -m shell -a 'ps -ef | grep mongo | grep -v grep'

管理工具mongodb compass历史版本下载

https://www.mongodb.com/docs/compass/current/release-notes/#compass-1.28.4

停止MongoDB服务

# 连接到MongoDB并执行关闭命令
mongo --eval "db.adminCommand({shutdown: 1})"

# 或者先进入mongo shell再执行
mongo
> use admin
> db.shutdownServer()