mongodb安装后的初始化操作

1

./mongobd -f /etc/mongodb.conf

1

./mongo 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

use admin

db.createUser({user:"adminuser",pwd:"12345678",roles:["userAdminAnyDatabase"]})

## 4、用超级管理账号创建业务账号
db.auth('adminuser', '12345678')

use testdb

db.createUser({user:"testuser",pwd:"12345678",roles: [{role:"readWrite", db:"testdb"}]})

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21

systemLog:
    destination: file
    logAppend: true
    path: /usr/local/mongodb/logs/mongodb.log

storage:
    dbPath: /usr/local/mongodb/data/db
    journal:
        enabled: true

processManagement:
    fork:        
    pidFilePath: /var/run/mongodb/mongod.pid
    timeZoneInfo: /usr/share/zoneinfo

net:
    port: 27017
    bindIp: 0.0.0.0

security:
    authorization: enabled

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

systemLog:
  destination: file//指定是一个文件
  path: /data/logs/mongod.log//日志存放位置
  logAppend: true//产生日志内容追加到文件
#  quiet: true//在quite模式下会限制输出信息
#  timeStampFormat: iso8601-utc //默认是iso8601-local，日志信息中还有其他时间戳格式：ctime,iso8601-utc,iso8601-local

processManagement:
  fork: true//以守护进程的方式运行MongoDB，创建服务器进程
  pidFilePath: "/data/mongo-data/mongod.pid"//pid文件路径
net:
# bindIp: 192.168.33.131//绑定ip地址访问mongodb，多个ip逗号分隔
  port: 27017//端口
  maxIncomingConnections：10000//默认65535，mongodb实例接受的最多连接数，如果高于操作系统接受的最大线程数，设置无效。
#  http:
#    enabled: true//http端口最好关闭
#RESTInterfaceEnabled: false//即使http接口选项关闭，如果这个选项打开后会有更多的不安全因素

storage:
  dbPath: "/data/mongo-data"//数据文件存放路径
  engine: wiredTiger//数据引擎
  wiredTiger:
    engineConfig://wt引擎配置
      cacheSizeGB: 1//看服务器情况来进行设置
      directoryForIndexes: true//索引是否按数据库名进行单独存储
    collectionConfig:
      blockCompressor: zlib//压缩配置
    indexConfig:
      prefixCompression: true//索引配置
  journal:
    enabled: true//记录操作日志，防止数据丢失。
  directoryPerDB: true//指定存储每个数据库文件到单独的数据目录。如果在一个已存在的系统使用该选项，需要事先把存在的数据文件移动到目录。
operationProfiling:
  slowOpThresholdMs: 100 //指定慢查询时间，单位毫秒，如果打开功能，则向system.profile集合写入数据
  mode: "slowOp"//off、slowOp、all，分别对应关闭，仅打开慢查询，记录所有操作。
security:
  keyFile: "/data/mongodb-keyfile"//指定分片集或副本集成员之间身份验证的key文件存储位置
  clusterAuthMode: "keyFile"//集群认证模式，默认是keyFile
  authorization: "disabled"//访问数据库和进行操作的用户角色认证

1
2

db.userInfo.find();
相当于：select* from userInfo;

1
2
3

db.userInfo.distinct("name");
会过滤掉name中的相同数据
相当于：select distinct name from userInfo;

1
2

db.userInfo.find({"age": 22});
相当于： select * from userInfo where age = 22;

1
2

db.userInfo.find({age: {$gt: 22}});
相当于：select * from userInfo where age >22;

1
2

db.userInfo.find({age: {$lt: 22}});
相当于：select * from userInfo where age <22;

1
2

db.userInfo.find({age: {$gte: 25}});
相当于：select * from userInfo where age >= 25;

1

db.userInfo.find({age: {$lte: 25}});

1

db.userInfo.find({age: {$gte: 23, $lte: 26}});

1
2
3

db.userInfo.find({name: /mongo/});
//相当于%%
select * from userInfo where name like ‘%mongo%';

1
2

db.userInfo.find({name: /^mongo/});
select * from userInfo where name like ‘mongo%';

1
2

db.userInfo.find({}, {name: 1, age: 1});
相当于：select name, age from userInfo;

1
2

db.userInfo.find({age: {$gt: 25}}, {name: 1, age: 1});
相当于：select name, age from userInfo where age >25;

1
2

升序：db.userInfo.find().sort({age: 1});
降序：db.userInfo.find().sort({age: -1});

1
2

db.userInfo.find({name: 'zhangsan', age: 22});
相当于：select * from userInfo where name = ‘zhangsan' and age = ‘22';

1
2

db.userInfo.find().limit(5);
相当于：select top 5 * from userInfo;

1
2
3
4

db.userInfo.find().skip(10);
相当于：select * from userInfo where id not in (
select top 10 * from userInfo
);

1

db.userInfo.find().limit(10).skip(5);

1
2

db.userInfo.find({$or: [{age: 22}, {age: 25}]});
相当于：select * from userInfo where age = 22 or age = 25;

1
2
3

db.userInfo.findOne();
相当于：select top 1 * from userInfo;
db.userInfo.find().limit(1);

1
2

db.userInfo.find({age: {$gte: 25}}).count();
相当于：select count(*) from userInfo where age >= 20;

1
2

db.userInfo.find({sex: {$exists: true}}).count();
相当于：select count(sex) from userInfo;

1
2

db.userInfo.ensureIndex({name: 1});
db.userInfo.ensureIndex({name: 1, ts: -1});

1

db.userInfo.getIndexes();

1

db.userInfo.totalIndexSize();

1

db.users.reIndex();

1

db.users.dropIndex("name_1");

1

db.users.dropIndexes();

1

db.users.save({name: ‘zhangsan', age: 25, sex: true});

1
2
3
4
5
6

db.users.update({age: 25}, {$set: {name: 'changeName'}}, false, true);
相当于：update users set name = ‘changeName' where age = 25;
db.users.update({name: 'Lisi'}, {$inc: {age: 50}}, false, true);
相当于：update users set age = age + 50 where name = ‘Lisi';
db.users.update({name: 'Lisi'}, {$inc: {age: 50}, $set: {name: 'hoho'}}, false, true);
相当于：update users set age = age + 50, name = ‘hoho' where name = ‘Lisi';

1

db.users.remove({age: 132});

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

db.users.findAndModify({
    query: {age: {$gte: 25}},
    sort: {age: -1},
    update: {$set: {name: 'a2'}, $inc: {age: 2}},
    remove: true
});
db.runCommand({ findandmodify : "users",
    query: {age: {$gte: 25}},
    sort: {age: -1},
    update: {$set: {name: 'a2'}, $inc: {age: 2}},
    remove: true
});