Greenplum provisioning Ansible role.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
Maxim Likhachev 6af6404c63 Greenplum provisioning Ansible role 2 months ago
files Greenplum provisioning Ansible role 2 months ago
inventory/sample Greenplum provisioning Ansible role 2 months ago
roles Greenplum provisioning Ansible role 2 months ago
.ansible-lint Greenplum provisioning Ansible role 2 months ago
Makefile Greenplum provisioning Ansible role 2 months ago
README.md Greenplum provisioning Ansible role 2 months ago
add-users.yml Greenplum provisioning Ansible role 2 months ago
ansible.cfg Greenplum provisioning Ansible role 2 months ago
site.yml Greenplum provisioning Ansible role 2 months ago

README.md

Deploy a Greenplum Cluster

Greenplum Logo


Description

This repository contains Ansible the following roles which could be used to provision Greenplum Database cluster:

Requirements

Hardware

It is possible to install Greenplum cluster on one server which will be used as master and segment.

Greenplum distributive and extensions

Greenplum installation package

Greenplum RPM files should be placed into files/rpm/ directory. A new Greenplum version can be downloaded from the official website (it requires registration).

Greenplum modules and extensions

All additional modules supported by default are listed on the Greenplum website.

By default this Ansible role installs and adds them to default database template the following extensions.

hstore

It provides a data type for storing sets of key/value pairs within a single PostgreSQL value.

PostGIS.

PostGIS is a spatial database extension for PostgreSQL that allows GIS (Geographic Information Systems) objects to be stored in the database. The Greenplum Database PostGIS extension includes support for GiST-based R-Tree spatial indexes and functions for analysis and processing of GIS objects.


Usage

0. Make an inventory

Sample inventory may be used as a sample cluster manifest. To make a new cluster just copy this directory to another one and adjust variables and hosts IP addresses:

$ copy -r inventory/sample inventory/new-cluster
$ vim inventory/new_cluster/hosts.ini
$ vim inventory/new_cluster/group_vars/all/all.yml

1. Make the SSH key for a new user and upload it to remote servers

$ ssh-keygen -C new_user@new_cluster -f inventory/new_cluster/files/ssh/new_user

$ make users PROVISION_USER=new_user

This command creates user on remote servers, configures sudoers file and uploads the SSH key. All further Ansible playbooks will be executed under this user.

2. Provision the Greenplum cluster

$ make provision CLUSTER=new_cluster SSH_USER=new_user SSH_KEY=inventory/new_cluster/files/ssh/new_user