Vertica and puppet

For the last couple of weeks I have been working on a puppet manifest to enable more resilience and build of vertica nodes on AWS.

Using automation tools has allowed the fast prototyping and development of many software solutions. Using puppet and Jenkins, a full environment is provided for the Data Analysts to use within about 1 hour.

Part of what I've been working on is to build vertica nodes whilst retaining the data. In addition to this, building in the logic to enable a node to fail, recover and join the cluster with next to no manual work.

Monitoring and detection is useful in this phase, so the database admins can double check the health of the data during and after the failure. Part of the solution includes automatically configuring the Vertica Management Console ready for use.

More progress is expected in the next month as I build auto scaling on top of this resiliency.