Percona Setup
=============

Reminder Notes on how you set this up.

### Digital Ocean

1. Spin up a new Droplet using a Docker image under “One Click Apps”
2. Shell into Droplet.

###  Add the Percona Server Container

1.  `docker run --name CONTAINER_NAME -e MYSQL_ROOT_PASSWORD=ROOT_PASSWORD -e MYSQL_USER=MYSQL_USER -e MYSQL_PASSWORD=MYSQL_PASSWORD -e MYSQL_DATABASE=MYSQL_DATABASE -p 3306:3306 -d percona/percona-server:5.6`

### Open the Firewall

This uses UFW and obviously these settings aren’t very restrictive.  Use at your own risk and customize as needed.

1. `sudo ufw allow mysql`
2. `sudo ufw enable`

### Grant Permissions to Remote User

1. Shell into Container
	* `docker run -it --link CONTAINER_NAME --rm percona sh -c 'exec mysql  -h CONTAINER_NAME -u root -pROOT_PASSWORD'`
2. Grant Permissions (customize for your needs)
	* `GRANT ALL PRIVILEGES ON *.* TO 'MYSQL_USER'@'CONNECTING_IP' IDENTIFIED BY 'MYSQL_USER_PASSWORD'`
	* `FLUSH PRIVILEGES`