Pradeep Chauhan neophyt3

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

MongoDB cheat sheet

Overview

MongoDB is a document database that provides high performance, high availability, and easy scalability.

Document Database

Nginx FastCGI cache

Example /etc/nginx/nginx.conf using FastCGI (e.g. to PHP-FPM) with FastCGI cache enabled. This will capture returned data and persist it to a disk based cache store for a configurable amount of time, great for robust full page caching.

Will need to create a directory to hold cache files, for the example given here that would be:

$ sudo mkdir -p /var/cache/nginxfastcgi
$ chown www-data: /var/cache/nginxfastcgi

#Download Sorce PHP

mkdir /opt/php-5.6.0
mkdir /usr/local/src/php5-build
cd /usr/local/src/php5-build
wget http://de.php.net/get/php-5.6.0.tar.bz2/from/this/mirror -O php-5.6.0.tar.bz2
tar jxf php-5.6.0.tar.bz2
cd php-5.6.0/

#Comprehensive Introduction to @ngrx/store By: @BTroncone

Also check out my lesson @ngrx/store in 10 minutes on egghead.io!

Update: Non-middleware examples have been updated to ngrx/store v2. More coming soon!

	var mongoose = require('mongoose');

	var hitSchema = mongoose.Schema({
	text: String,
	music: String
	});
	hitSchema.statics.bulkInsert = function(models, fn) {
	if (!models \|\| !models.length)
	return fn(null);

	#!/bin/sh

	#Src: https://www.linode.com/docs/databases/mysql/tuning-your-mysql-database
	echo [PID] [MEM] [PATH] && ps aux \| awk '{print $2, $4, $11}' \| sort -k2rn \| head -n 20
	ps -eo pcpu,pid,user,args \| sort -k 1 -r \| head -20

	# Building static nginx for teh lulz
	#
	# basic dependencies

	sudo apt-get install libxslt1-dev libxml2-dev zlib1g-dev libpcre3-dev libbz2-dev libssl-dev

	# download nginx and openssl

	wget http://nginx.org/download/nginx-1.5.6.tar.gz
	tar xf nginx-1.5.6.tar.gz; cd nginx-1.5.6