README.md

Multi-Machine Vagrant from SQLite3 database

This is a multi-machine Vagrant system that dynamically configures four systems from SQLite3 database.

Notes

Provisioning scripts will make changes to /etc/hosts and /etc/ssh/ssh_config for easy access between systems. After entering one system, e.g. vagrant ssh client, you can easily get to another system using just the host name, e.g. ssh master.

Prerequisites

vagrant plugin install sqlite3

Nerd Notes

Difficulty in running arbitrary SQL file into the database with sqlite3 ruby library, so used sqlite3 command-line tool to run this.

Instructions

vagrant up          # start and provision all systems
vagrant provision   # provision or re-provision all systems
vagrant ssh         # ssh into master
vagrant ssh client  # ssh into client
vagrant halt client # shutdown client
vagrant halt        # shutdown all systems
vagrant reload      # restart all systems
vagrant destroy     # delete all systems

Ansible Inventory

Prerequisites

The database must be generated, which should be handled by vagrant up. With active systems running, the database will be available.

If you just wanted to see the output of the inventory script, then you need to create the database manually. You can run cd config && ./create_db.sh to create the database, and type ./inventory.py

Testing with Ansible

A sample Python script is available for testing an Ansible dynamic inventory file. With Ansible installed on a Linux or Mac OS X host, you can run:

vagrant up          # bring systems up
export ANSIBLE_HOST_KEY_CHECKING=False
ansible all -i "config/inventory.py" -m ping
# run a single command
ansible all -i "config/inventory.py" -a 'lsb_release -a'