- Initial Server Setup with Ubuntu 12.04
- How To Install Linux, nginx, MySQL, PHP (LEMP) stack on Ubuntu 12.04
- A Basic MySQL Tutorial
- How To Install phpMyAdmin on a LEMP server
- How To Install Git on Ubuntu 12.04
- Generating SSH Keys and connect with DigitalOcean
- Install Composer on DigitalOcean
- [Install php5-cli if you get stuck with installing Compos
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Workers | |
-- The following data definition defines an organization's employee hierarchy. An employee is a manager if any other employee has their managerId set to the first employees id. An employee who is a manager may or may not also have a manager. | |
-- TABLE employees | |
-- id INTEGER NOT NULL PRIMARY KEY | |
-- managerId INTEGER REFERENCES employees(id) | |
-- name VARCHAR(30) NOT NULL | |
-- Write a query that selects the names of employees who are not managers. | |
SELECT * | |
FROM employees | |
WHERE id IN (SELECT id FROM employees WHERE managerId IS NULL) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### Keybase proof | |
I hereby claim: | |
* I am mirzalazuardi on github. | |
* I am mirzalazuardi (https://keybase.io/mirzalazuardi) on keybase. | |
* I have a public key ASCzDoTqBV31bYSm2slkGSLd6XZFA5irVOtCS4xaihKFngo | |
To claim this, I am signing this object: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# User and group used by worker processes | |
user www-data; | |
# Ideally # of worker processes = # of CPUs or cores | |
# Set to auto to autodetect | |
# max_clients = worker_processes * worker_connections | |
worker_processes auto; | |
pid /run/nginx.pid; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# KILL THEM ETAGS | |
# http://www.askapache.com/htaccess/apache-speed-etags.html | |
FileETag none | |
# set expires header | |
<FilesMatch "\.(ico|jpg|jpeg|png|gif|js|css|swf|woff|eot|svg|ttf)$"> | |
Header set Expires "Tue, 16 Jun 2020 20:00:00 GMT" | |
</FilesMatch> | |
# turn on gzip compression |
NewerOlder