Terraform 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 ProxySQL 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"
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 Terraform scripts can SSH into VMs using agent forwarding

Creating services with basic configuration

Initiate 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

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

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@<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