MongoDB 基础操作方法及每日备份

vim /etc/yum.repos.d/mongodb-org-4.0.repo

[mongodb-org-4.0]name=MongoDB Repositorybaseurl=https://repo.mongodb.org/yum/redhat/$releasever/mongodb-org/4.0/x86_64/gpgcheck=1enabled=1gpgkey=https://www.mongodb.org/static/pgp/server-4.0.asc

yum install -y mongodb-org

mongod --dbpath=/path --logpath=/path --logappend --port=27017 --fork

mongod --auth --bind_ip_all

mango

mongo admin -u username -p password

use admindb.auth(‘username’, ‘password’)

show dbs

use dbname

show collections

db.help()

vi /etc/mongod.conf

security:  authorization: enabled

db.dropDatabase()

show users

db.createUser({  user: 'username',  pwd: 'password',  roles:[{    role:'readWrite',    db:'dbname'  }]})

db.changeUserPassword('username', 'password')

db.updateUser('username', {  pwd: 'password'})

db.dropUser('username')

use admin

db.createUser({        user: 'backup',        pwd: 'password',        roles:[{                role:'backup',                db:'admin'        }]})

db.createUser({        user: 'restore',        pwd: 'password',        roles:[{                role:'restore',                db:'admin'        }]})

mongodump -u backup -p password --authenticationDatabase admin -o /data/backup/mongodb/

mongorestore -u restore -p password   /data/backup/mongodb/

vim /data/shell/monitor/mongodb_backup.sh

#!/bin/bash#auth=wujiang#PRO Mongodb Full Backup
#Mongo Settingdbhost="10.0.0.1"   #服务器ipuser="backup"userpwd='password'
#Backup Dirdb_bashdir="/data/backup/mongodb_bk"dbdirdate=`date +"%Y.%m.%d"`db_backupdir=$db_bashdir/$dbdirdateif [ ! -d $db_backupdir ]then        mkdir -p $db_backupdirfi
#Backup Logbackup_log="$db_bashdir/mongodb_bk.log"
#Timedbbackdate=`date +"%Y%m%d_%H%M%S"`
echo "########Start time: `date +"%Y-%m-%d_%H:%M:%S"`########" >> $backup_logecho "Backup Starting ..." >> $backup_logmongodump -h $dbhost -u $user -p $userpwd --authenticationDatabase admin -o $db_backupdir/$dbbackdate/if [ $? -eq 0 ]then        echo "备份到文件: $db_backupdir/$dbbackdate" >> $backup_log        echo "开始压缩文件..." >> $backup_log        cd $db_backupdir;/usr/bin/tar zcf $dbbackdate.tar.gz $dbbackdate        if [ $? -eq 0 ]        then                TAR=1        else                TAR=0        fi
        Tar_filesize=`du -b $db_backupdir/$dbbackdate.tar.gz |awk '{print $1}'`        echo "Tar File Size: $Tar_filesize" >> $backup_log        if [ "$Tar_filesize" -ge 100 ] && [ $TAR -eq 1 ]        then                echo "Tar to File Success:$db_backupdir/$dbbackdate.tar.gz" >> $backup_log                rm -rf $db_backupdir/$dbbackdate        else                echo -e "Tar to File Failed:$db_backupdir/$dbbackdate.tar.gz !!! \n Please to check it." >> $backup_log        fielse        echo -e "$db_backupdir/$dbbackdate\nBackup Fail!!! Please to check it." >> $backup_log        rm -rf $db_backupdir/$dbbackdatefiecho -e "########End time: `date +"%Y-%m-%d_%H:%M:%S"`########\n" >> $backup_log
echo -e "\n||||||################################################################################||||||\n" >> $backup_log

echo ""echo "数据库已备份,路径为：$db_backupdir"du -sh $db_backupdir/*echo ""

crontal -e 

#mongodb正式库58 23 * * *   /bin/sh /data/shell/monitor/mongodb_backup.sh   >>/data/mongod/mongodb_backup.log 2>&1 &