Mongodb: Difference between revisions

From Halfface
Jump to navigation Jump to search
 
Line 17: Line 17:
  db.copyDatabase("dbname", "dbname-oldprod-date");> use dbname;
  db.copyDatabase("dbname", "dbname-oldprod-date");> use dbname;
  db.dropDatabase();
  db.dropDatabase();
  mongorestore --ssl --host database/mongo.inter.net -u username -p P@ssw0rd --authenticationDatabase admin --gzip  --db dbname /opt/redbridge/backup-date/dbname
  mongorestore --ssl --host database/mongo.inter.net -u username -p P@ssw0rd --authenticationDatabase admin --gzip  --db dbname /<path>/dbname


=Login as ldap user=
=Login as ldap user=

Latest revision as of 10:50, 3 May 2024

connect

mongo

run command(list cluster information)

mongo --ssl --host mongo.inter.net --quiet -u admin -p P@ssW0rd --authenticationDatabase admin --eval 'rs.status();'

list databases

show dbs

Via script

rs.slaveOk();db.adminCommand('listDatabases')

mongodump

Dump database

mongodump --ssl --host "database/mongo.inter.net" -u username -p P@ssw0rd --authenticationDatabase admin --db "database" --out=/tmp/database_2020-10-20"

restore database

mongo -ssl --host database/mongo.inter.net -u username -p P@ssw0rd --authenticationDatabase admin
db.copyDatabase("dbname", "dbname-oldprod-date");> use dbname;
db.dropDatabase();
mongorestore --ssl --host database/mongo.inter.net -u username -p P@ssw0rd --authenticationDatabase admin --gzip  --db dbname /<path>/dbname

Login as ldap user

mongo --ssl --sslCAFile /etc/ssl/mongodb-ca.crt -u username --host mongodb.inter.net --port 27017 --authenticationDatabase '$external' --authenticationMechanism 'PLAIN' -pP@ssW0rd --eval 'rs.status();'
mongo --ssl -u $username --host $(hostname -f) --port 27017 --authenticationDatabase '$external' --authenticationMechanism 'PLAIN' -p $PASSWORD

Look at database status

mongo --ssl --host mongodb.inter.net --quiet -u username -p P@ssW0rd --authenticationDatabase admin --eval 'rs.status();' | head

Put db i state 2

rs.stepDown(120);

Look at connections

'db.currentOp()'

List databases.

'db.getMongo().getDBNames();'

List users

echo -e 'use $external \n db.getUsers();' | mongo --ssl --host mongodb.inter.net --quiet -u username -p P@ssW0rd --authenticationDatabase admin --eval 'rs.status();'

Create user

mongo << END
/// setup authentication
use admin;
db.addUser({"pwd" : "yO9HUQiuLIMfzHK6sBJF0DdwZKiwAq9X", "roles" : [  "userAdminAnyDatabase",  "readWrite" ], "user" : "admin" });
use mathem
//db.addUser("mathem", "Q0Nay1xeY9zq");
db.addUser({"pwd" : "Q0Nay1xeY9zq", "roles" : [  "userAdminAnyDatabase",  "readWrite" ], "user" : "admin" })
END

Which version

db.version()

show process list

Show all operations

db.currentOp( { "$all": true } )