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.
Demo uses ProxySQL to create read/write splitting in front of UpCloud DBaaS services.
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"
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
Initiate the project and install providers.
make init
Demo can now be created with Terraform. Creation takes around 10 minutes.
make create
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.
After testing things around its good to free the resources. Tearing the thing down is also just one command.
make destroy