Monday, February 22, 2016

How to recover from disasters with Barman

Disaster recovery for PostgreSQL databases.
  1. Knowledge
    1. Barman is a database recovery tool.
  2. Strategy
    1. Install Barman with yum on the backup server.
    2. Verify the barman user has ssh access to the postgres user on the main server.
    3. Verify the postgres user has ssh access to the barman user on the backup server.
    4. Verify the barman user can connect to the database on the main server.
    5. Configure Barman with default settings, noting the incoming_wals_directory.
    6. Configure Barman to enable continuous WAL archiving.
    7. Restart the server.
    8. Test new backup and restore functionality.
  3. Execution

Thursday, February 18, 2016

How to virtualize a private network with Azure

A growing collection of integrated cloud services.
  1. Knowledge
    1. Azure is Microsoft's cloud PaaS.
  2. Strategy
    1. Call support, those portals are a mess.
  3. Execution

Friday, January 29, 2016

How to monitor logs with Splunk

Operational intelligence and log management.
  1. Knowledge
    1. Splunk is a log monitoring solution.
  2. Strategy
    1. Install Splunk as host server.
    2. Configure host to listen to clients on the default port.
    3. Install the Universal Forwarder as a rpm on client machines.
    4. Configure the forwarders to send to the host.
    5. Verify it all works.
  3. Execution

Friday, December 18, 2015

How to base data with PostgreSQL

The world's most advanced open source database.
  1. Knowledge
    1. PostgreSQL is an open-source database.
  2. Strategy
    1. Install on AWS EC2 Ubuntu.
    2. Configure the database.
    3. A example Python script is provided.
  3. Execution

Thursday, December 17, 2015

How to store data with Druid

Fast column-oriented distributed datastore.
  1. Knowledge
    1. Druid is an open-source distributed data store, currently utilized by Netflix, Yahoo and others.
  2. Strategy
    1. Download the tarball.
    2. Dependencies
      1. Apache Derby
        1. Install the tarball.
        2. Configuration.
      2. Zookeeper
        1. Install by tutorial instructions.
    3. Run the server.
    4. Execute a simple query.
    5. Execute a complex query, fast.
  3. Execution

Friday, December 11, 2015

How to contain software with Docker

Lightweight. Open. Secure.
  1. Knowledge
    1. Docker allows you to package an application with all its dependencies into a standardized unit for software deployment.
  2. Strategy
    1. Linux
      1. Tutorial
    2. Mac OS X
    3. Windows
  3. Execution

Thursday, December 10, 2015

How to teach a machine to learn

Machine learning in Python.
  1. Knowledge
    1. Scikit-learn is a toolkit for machine learning in Python.
    2. It explains how it solves machine learning problems
  2. Strategy
    1. Scikit-learn provides a tutorial for getting started.
    2. Although, where do we even start if our application is huge, nuanced and complex? Let's use nearest-neighbor thinking to build off a similar solution! (a quick google search found it)
  3. Execution