Sandbox Environment

Introduction to pigsty Sandbox, a pre-defined environment for demonstration purpose.


There’s a standard 4-node demo env for pigsty, named ‘Sandbox’. You can create a sandbox on your laptop with Vagrant, or create them on public cloud with Terraform. The same deployment procedure could apply to production deployment.

Take sandbox as an example, install pigsty on meta node with:

. /infra.yml     # install pigsty on meta node

Nodes Init

Now add 3 more nodes,, into pigsty nodes.yml

./nodes.yml -l pg-test        # init 3 nodes of cluster pg-test

After that, these 3 nodes are set with DCS service, node exporter & promtail logger. And can be used for subsequent database deployment. check Config: Nodes & Playbook: Nodes for details.

PostgreSQL Deploy

Create a classic 1 primary & 2 replicas HA PostgreSQL cluster with pgsql.yml playbook.

./pgsql.yml -l pg-test  # init pgsql cluster pg-test

Once complete, you can check the newly created PostgreSQL cluster from Monitoring Dashboards.

Check Config: PGSQL, Customize: PGSQL, and Playbook: PGSQL for more details.

Redis Deployment

In addition to the PostgreSQL cluster, you can deploy various other types of clusters and even other types of databases.

For example, to deploy Redis:

. /configure -m redis    # use redis config template
. /nodes.yml             # init nodes for redis cluster
. /redis.yml             # create redis on those nodes

Check Config: REDIS and Playbook: REDIS for more details.

MatrixDB Deployment

To deploy the open-source time-series data warehouse MatrixDB (Greenplum7):

./configure -m mxdb   # Use the sandbox environment MatrixDB configuration file template
./download matrix     # Download the MatrixDB package and build the local source
./infra.yml -e no_cmdb=true # If meta node is part of it, add no_cmdb var to skip CMDB creation
./nodes.yml           # configure all nodes for MatrixDB installation
./pigsty-matrixdb.yml   # Install MatrixDB on those nodes

Last modified 2022-06-04: fill en docs (5a858d3)