Deployment and Backup Guide for MongoDB Database on Hostinger VPS

ssh root@your-vps-ip
sudo apt update && sudo apt upgrade -y

sudo apt-get install gnupg curl
curl -fsSL https://www.mongodb.org/static/pgp/server-8.0.asc | \
  sudo gpg -o /usr/share/keyrings/mongodb-server-8.0.gpg --dearmor

echo "deb [ arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-8.0.gpg ] https://repo.mongodb.org/apt/ubuntu noble/mongodb-org/8.0 multiverse" | \
  sudo tee /etc/apt/sources.list.d/mongodb-org-8.0.list

sudo apt-get update && sudo apt-get install -y mongodb-org
sudo systemctl start mongod && sudo systemctl enable mongod

mongosh
use admin
db.createUser({user: "admin", pwd: passwordPrompt(), roles: ["root"]})

use database_name
db.createUser({
  user: "appuser",
  pwd: passwordPrompt(),
  roles: [{role: "readWrite", db: "database_name"}]
})

exit

sudo nano /etc/mongod.conf

security:
  authorization: enabled

sudo systemctl restart mongod

sudo nano /etc/mongod.conf

bindIp: 127.0.0.1,vps_ip

sudo ufw enable
sudo ufw allow 'Nginx Full'
sudo ufw allow OpenSSH
sudo ufw deny 27017

mongosh admin -u admin -p --authenticationDatabase admin

#!/bin/bash
BACKUP_DIR=~/backups/mongodb
DB_NAME=database_name
TIMESTAMP=$(date +%F-%H-%M-%S)
BACKUP_NAME="backup-$DB_NAME-$TIMESTAMP.gz"

mongodump --db $DB_NAME \
  --authenticationDatabase database_name \
  -u database_user \
  -p your_secure_password \
  --archive=$BACKUP_DIR/$BACKUP_NAME --gzip

ls -t $BACKUP_DIR/backup-$DB_NAME-*.gz | tail -n +6 | xargs -I {} rm {}

chmod +x ~/backups/mongodb_backup_database_name.sh

aws s3 cp $BACKUP_DIR/$BACKUP_NAME s3://your-bucket-name/$BACKUP_NAME

crontab -e
0 * * * * ~/backups/mongodb_backup_database_name.sh

sudo ufw allow 27017

mongodb://admin:yourpassword@your_server_ip:27017/database_name?authSource=admin