Skip to content

This is a demo that uses terraform to create UpCloud DBaaS service and SQL query splitting using Pgpool-II

License

Notifications You must be signed in to change notification settings

UpCloudLtd/sample-dbaas-pgpool-demo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Terraform Pgpool-II-DBaaS demo

Please note that this is just an example on how you can use Terraform with UpCloud and should not be used in production as is. Please see LICENSE for details.

Service Topology

Usage

Demo uses Pgpool-II to create read/write splitting in front of UpCloud DBaaS services.

Prerequisites

Project uses Terraform and it needs to be installed. We're also using UpCloud's Terraform provider, but it should be automatically installed by running terraform init or with make init.

To create the resources with Terraform, you'll need your API credentials exported.

export UPCLOUD_USERNAME=your_username
export UPCLOUD_PASSWORD=your_password

You must also create config.tfvars file with your own settings:

zone = "pl-waw1"
dbaas_plan = "2x2xCPU-4GB-50GB"
pgpool_proxy_plan = "1xCPU-1GB"
ssh_key_public = "ssh-rsa AAAA_YOUR_SSH_PUBLIC_KEY"

Quickstart

IMPORTANT: Make sure your SSH-agent is running (execute this if not: eval$(ssh-agent) && ssh-add <path_to_private_key> && ssh-add -L), so Terraform scripts can SSH into VMs using agent forwarding

Creating services with basic configuration

Initate the project and install providers.

make init

Demo can now be created with Terraform. Creation takes around 10 minutes.

make create

Testing stuff

After demo has been created you should log in to sql-client server with SSH and test the setup. You can print out the relevant IP addresses by running:

make print

Log in by running ssh root@<sql_client_ip_address>

You can ping the DBaaS with bash ping-psql.sh

You can prepare DBaaS for benchmarking with bash prepare-benchmark and you can run the benchmarks with bash run-benchmark.

You can use bash show-servers.sh to view DBaaS backends and how many select queries have been processed by which backend.

Destroying stuff

After testing things around its good to free the resources. Tearing the thing down is also just one command.

make destroy

About

This is a demo that uses terraform to create UpCloud DBaaS service and SQL query splitting using Pgpool-II

Resources

License

Security policy

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published