Mahendran Kathirvel astromahi

## goi.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              12 stars
            
          
                icholy
                / goi.md
            
            
              Last active
              August 31, 2017 03:17
            
          
    Interfaces

Let's imagine a very simple table
CREATE TABLE people {
  id bigserial,
  name character varying
}

  
## remove_documents_mongodb.js
var date = new Date();
var daysToDeletion = 120;
var deletionDate = new Date(date.setDate(date.getDate() - daysToDeletion));

printjson(deletionDate);

var db = db.getSiblingDB('db')
db.getMongo().setSlaveOk();

printjson(db.messages.find({insertDate : {$lt : deletionDate}}).count());

## nginx-websocket-proxy.conf
upstream websocket {
    server localhost:3000;
}

server {
    listen       80;
    server_name  localhost;

    access_log  /var/log/nginx/websocket.access.log  main;

## backup-mongodb-to-s3.sh
#!/bin/sh
set -e
HOST=localhost
DB=test-entd-products
COL=asimproducts

S3PATH="s3://mongodb-backups-test1-entd/$DB/$COL/"
S3BACKUP=$S3PATH`date +"%Y%m%d_%H%M%S"`.dump.gz
S3LATEST=$S3PATH"latest".dump.gz
/usr/bin/aws s3 mb $S3PATH
	var date = new Date();
	var daysToDeletion = 120;
	var deletionDate = new Date(date.setDate(date.getDate() - daysToDeletion));

	printjson(deletionDate);

	var db = db.getSiblingDB('db')
	db.getMongo().setSlaveOk();

	printjson(db.messages.find({insertDate : {$lt : deletionDate}}).count());
	upstream websocket {
	server localhost:3000;
	}

	server {
	listen 80;
	server_name localhost;

	access_log /var/log/nginx/websocket.access.log main;
	#!/bin/sh
	set -e
	HOST=localhost
	DB=test-entd-products
	COL=asimproducts

	S3PATH="s3://mongodb-backups-test1-entd/$DB/$COL/"
	S3BACKUP=$S3PATH`date +"%Y%m%d_%H%M%S"`.dump.gz
	S3LATEST=$S3PATH"latest".dump.gz
	/usr/bin/aws s3 mb $S3PATH