docker mongodb 安装

docker run -v /home/mongodb/data:/data/db --memory 4g -p 27017:27017 --name mongodb-4.4.12 -d mongo:4.4.12
#远程配置
docker cp /etc/mongod.conf mongodb-4.4.12:/etc/mongod.conf.orig

#删除容器 docker stop mongodb-4.4.12
docker rm -f mongodb-4.4.12

docker exec -it mongodb-4.4.12 bash

mongo


use onestop_v3;

db.createUser(
{
user: "yxtp",
pwd: "yxtp@asd666",
roles: [{ role: "dbAdmin", db: "onestop_v3" }]
}
)

 

nginx 配置 stream 模块

upstream mongo46 {
server 192.168.2.46:27017;
}

server {
listen 27020;
proxy_connect_timeout 500s;
proxy_timeout 500s;
proxy_pass mongo46;
}

 

db.GpsInfoRealData.find({"sendTime" : {"$gte" : '2021-12-09 11:03:01'}}).sort({"sendTime":-1});
db.GpsInfoHistory.find({"plateNo":"湘HA0302",createTime:{"$gte":1645688946}}).count();
db.GpsInfoRealData.find({"plateNo":"湘H10005D"});
db.GpsInfoRealData.find({"plateNo":"湘H92862A"}).count();
db.auth('yxtp','yxtp@asd666');

db.GpsInfoHistory.createIndex({"createTime":1})
db.GpsInfoHistory.createIndex({"createTime":1,"plateNo":1})
db.GpsInfoHistory.createIndex({"plateNo":1})
db.GpsInfoHistory.getIndexes()