# ------Installing MySQL 5.5 (low memory ~36M)------
sudo rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
sudo rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm
suo yum install mysql55w mysql55w-server
sudo vi /etc/my.cnf
sudo service mysqld start
sudo chkconfig --level 235 mysqld on
/usr/bin/mysqlsecureinstallation

# ------Installing MySQL 5.7 (memory usage ~124M)------
wget http://dev.mysql.com/get/mysql57-community-release-el6-11.noarch.rpm
sudo yum localinstall mysql57-community-release-el6-11.noarch.rpm
sudo yum repolist enabled | grep "mysql.*-community.*"
sudo yum install mysql-community-server
sudo vi /etc/my.cnf
sudo service mysqld start
sudo chkconfig --level 235 mysqld on
# -- check for errors in /var/log/messages
# -- check for errors and temp root password in /var/log/mysqld.log
/usr/bin/mysqlsecureinstallation
mysql -u root -p
    show plugins;
    uninstall plugin validate_password;
    set password for 'root'@'localhost' = 'new_pass'

# File: /etc/my.cnf
# --- Add config lines after [mysql_safe] block

# BSH: low memory for MySQL 5.5 (~36M)
character-set-server=utf8
collation-server=utf8_general_ci

# BSH: low memory for MySQL 5.7 (~124M)
explicit_defaults_for_timestamp = TRUE
table_open_cache=4
query_cache_limit=256K
query_cache_size=4M
max_allowed_packet=1M
sort_buffer_size=64K
read_buffer_size=256K
thread_stack=64K
innodb_buffer_pool_size = 56M
innodb_flush_neighbors=0
innodb_flush_log_at_trx_commit=2
character-set-server=utf8
collation-server=utf8_general_ci

#FILE: /etc/nginx/nginx.conf

user  nginx;
worker_processes  1;
error_log  /var/log/nginx/error.log warn;
pid        /var/run/nginx.pid;

events {
    worker_connections  1024;
}

http {
  include       /etc/nginx/mime.types;
  default_type  application/octet-stream;

  log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                    '$status $body_bytes_sent "$http_referer" '
                    '"$http_user_agent" "$http_x_forwarded_for"';

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

  sendfile on;
  keepalive_timeout 65;
  gzip on;
  server_tokens off;
  include /etc/nginx/conf.d/*.conf;
}

#FILE: /etc/nginx/conf.d/default.conf

server {
  listen       80;
  listen       [::]:80;
  server_name  localhost mydomain.com www.mydomain.com;
  root         /usr/share/nginx/html;

  #BSH: enable etag
  etag on;

  location / {
    index  index.html index.php;

    #BSH: redirect all non file, non dir requests to index.php
    try_files $uri $uri/ /index.php;
  }

  #BSH: ensure all /login requests use https
  location ^~ /login {
      return 301 https://$host$request_uri;
  }

  #BSH: ensure all /app requests use https
  location ^~ /app {
      return 301 https://$host$request_uri;
  }

  error_page   500 502 503 504  /50x.html;
  location = /50x.html {
    root   /usr/share/nginx/html;
  }

  # -----pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000-----
  location ~ \.php$ {
    root           /usr/share/nginx/html;
    fastcgi_pass   127.0.0.1:9000;
    fastcgi_index  index.php;
    fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
    include        fastcgi_params;
  }
}

server {
  listen       443 ssl;
  listen       [::]:443 ssl;
  server_name  localhost mydomain.com www.mydomain.com;
  root         /usr/share/nginx/html;

  #BSH: set ssl cert properties
  keepalive_timeout     70;
  ssl_certificate       /etc/ssl/certs/www_mydomain_com.pem;
  ssl_certificate_key   /etc/ssl/certs/www_mydomain_com_private.key;
  ssl_session_cache     shared:SSL:10m;
  ssl_session_timeout   10m;
  ...
}