Jonathan Le jonathanhle

Installing SSHPASS

SSHPass is a tiny utility, which allows you to provide the ssh password without using the prompt. This will very helpful for scripting. SSHPass is not good to use in multi-user environment. If you use SSHPass on your development machine, it don't do anything evil.

Installing on Ubuntu

apt-get install sshpass

Installing on OS X

Install the netcat nc command with Homebrew (otherwise Mac OS X version is really old and the interface is different):

brew install netcat

Use netcat to listen for incoming TCP connections on port 3000:

nc -l -p 3000

An introduction to DynamoDB

DynamoDB is a powerful, fully managed, low latency, NoSQL database service provided by Amazon. DynamoDB allows you to pay for dedicated throughput, with predictable performance for "any level of request traffic". Scalability is handled for you, and data is replicated across multiple availability zones automatically. Amazon handles all of the pain points associated with managing a distributed datastore for you, including replication, load balancing, provisioning, and backups. All that is left is for you to take your data, and its access patterns, and make it work in the denormalized world of NoSQL.

Modeling your data

The single most important part of using DynamoDB begins before you ever put data into it: designing the table(s) and keys. Keys (Amazon calls them primary keys) can be composed of one attribute, called a hash key, or a compound key called the hash and range key. The key is used to uniquely identify an item in a table. The choice of the primary key is particularl

	# taken from http://www.piware.de/2011/01/creating-an-https-server-in-python/
	# generate server.xml with the following command:
	# openssl req -new -x509 -keyout server.pem -out server.pem -days 365 -nodes
	# run as follows:
	# python simple-https-server.py
	# then in your browser, visit:
	# https://localhost:4443

	import BaseHTTPServer, SimpleHTTPServer
	import ssl

	Use TCPDUMP to Monitor HTTP Traffic
	1. To monitor HTTP traffic including request and response headers and message body:

	tcpdump -A -s 0 'tcp port 80 and (((ip[2:2] - ((ip[0]&0xf)<<2)) - ((tcp[12]&0xf0)>>2)) != 0)'

	2. To monitor HTTP traffic including request and response headers and message body from a particular source:

	tcpdump -A -s 0 'src example.com and tcp port 80 and (((ip[2:2] - ((ip[0]&0xf)<<2)) - ((tcp[12]&0xf0)>>2)) != 0)'

	3. To monitor HTTP traffic including request and response headers and message body from local host to local host:

	To terminate user sessions or queries on DB instances, Amazon RDS provides the following commands:

	PROMPT> CALL mysql.rds_kill(thread-ID)
	PROMPT> CALL mysql.rds_kill_query(thread-ID)

	For example, to kill the session that is running on thread 99, you would type the following:

	PROMPT> CALL mysql.rds_kill(99);

	To kill the query that is running on thread 99, you would type the following:

	#!/bin/bash

	# (optional) You might need to set your PATH variable at the top here
	# depending on how you run this script
	#PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin

	# Hosted Zone ID e.g. BJBK35SKMM9OE
	ZONEID="enter zone id here"

	# The CNAME you want to update e.g. hello.example.com

	-- randomise a column's values using a list of specified values

	IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'ShuffleTable')
	DROP TABLE [ShuffleTable];
	IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'InsertDataListTable')
	DROP TABLE [InsertDataListTable];

	GO

	CREATE TABLE [InsertDataListTable] ([TargetColumn] NVARCHAR(50));

	#!/bin/bash

	sudo kextunload -b com.apple.iokit.BroadcomBluetoothHostControllerUSBTransport
	sudo kextload -b com.apple.iokit.BroadcomBluetoothHostControllerUSBTransport

	console.log('Loading event');

	var Q = require('q');
	var aws = require('aws-sdk');
	var cloudfront = new aws.CloudFront();

	exports.handler = function (event, context) {
	//_log('Received event: ', event);

	var bucket = event.Records[0].s3.bucket.name;