Terraform LBaaS-ProxySQL-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.

Usage

Demo uses UpCloud LBaaS and ProxySQL to create HA read/write splitting in front of UpCloud DBaaS services.

Prerequisites

Project uses Terraform and should be installed. We're also using UpCloud's Terraform provider but it should be automatically installed by running terraform 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 = "3x2xCPU-4GB-100GB"
sqlproxy_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 Ansible and 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-mysql.sh <LBaaS hostname> <MySQL port>

You can prepare DBaaS for benchmarking with bash prepare-benchmark <LBaaS/DBaaS hostname> <MySQL port>

You can run ReadWrite benchmarking with bash run-readwrite-benchmark <LBaaS/DBaaS hostname> <MySQL port>

You can run ReadOnly benchmarking with bash run-readonly-benchmark <LBaaS/DBaaS hostname> <MySQL port>

You can cleanup DBaaS for benchmarking with bash cleanup-benchmark <LBaaS/DBaaS hostname> <MySQL port>

After running benchmarks you should log in to sql-proxy-server with SSH and check how SQL queries are split.

Log in by running ssh root@<one of proxy_ip_addresses>

You can use bash show-servers.sh to view DBaaS servers and server groups in ProxySQL.

You can use bash show-rules.sh to view SQL splitting rules in ProxySQL.

You can use bash show-query-digest.sh to view how different queries have been allocated to different server groups.

Destroying stuff

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

make destroy