Skip to main content
Version: v0.14 🚧

Deliver the WordPress Application with Cloud RDS

This tutorial will demonstrate how to deploy a WordPress application with Kusion, which relies on both Kubernetes and IaaS resources provided by cloud vendors. We can learn how to declare the Relational Database Service (RDS) to provide a cloud-based database solution with Kusion for our application from this article.

Prerequisites

  • Install Kusion.
  • Install kubectl CLI and run a Kubernetes or k3s or k3d or MiniKube cluster.
  • Prepare a cloud service account and create a user with at least VPCFullAccess and RDSFullAccess related permissions to use the Relational Database Service (RDS). This kind of user can be created and managed in the Identity and Access Management (IAM) console of the cloud vendor.
  • The environment that executes kusion needs to have connectivity to terraform registry to download the terraform providers.

Additionally, we also need to configure the obtained AccessKey and SecretKey as well as the cloud resource region as environment variables for specific cloud provider:

export AWS_ACCESS_KEY_ID="AKIAQZDxxxx" # replace it with your AccessKey
export AWS_SECRET_ACCESS_KEY="oE/xxxx" # replace it with your SecretKey
export AWS_REGION=us-east-1 # replace it with your region

aws iam account

Init Workspace

To deploy the WordPress application with cloud rds, we first need to initiate a Workspace for the targeted stack (here we are using dev). Please copy the following example YAML file to your local workspace.yaml.

workspace.yaml

# MySQL configurations for AWS RDS
modules:
mysql:
path: oci://ghcr.io/kusionstack/mysql
version: 0.2.0
configs:
default:
cloud: aws
size: 20
instanceType: db.t3.micro
privateRouting: false
databaseName: "wordpress-mysql"

If you would like to try creating the Alicloud RDS instance, you should replace the [your-subnet-id] of modules.kusionstack/mysql@0.1.0.default.subnetID field with the Alicloud vSwitchID to which the database will be provisioned in. After that, you can execute the following command line to initiate the configuration for dev workspace.

kusion workspace create dev -f workspace.yaml

Since Kusion by default use the default workspace, we can switch to the dev workspace with the following cmd:

kusion workspace switch dev

If you have already created and used the configuration of dev workspace, you can append the MySQL module configs to your workspace YAML file and use the following command line to update the workspace configuration.

kusion workspace update dev -f workspace.yaml

We can use the following command lines to show the current workspace configurations for dev workspace.

kusion workspace show

The workspace.yaml is a sample configuration file for workspace management, including MySQL module configs. Workspace configurations are usually declared by Platform Engineers and will take effect through the corresponding stack.

info

More details about the configuration of Workspace can be found in Concepts of Workspace.

Create Project And Stack

We can create a new project named wordpress-rds-cloud with the kusion project create command.

# Create a new directory and navigate into it. 
mkdir wordpress-rds-cloud && cd wordpress-rds-cloud

# Create a new project with the name of the current directory.
kusion project create

After creating the new project, we can create a new stack named dev with the kusion stack create command.

# Create a new stack with the specified name under current project directory. 
kusion stack create dev

The created project and stack structure looks like below:

tree
.
├── dev
│   ├── kcl.mod
│   ├── main.k
│   └── stack.yaml
└── project.yaml

2 directories, 4 files

Update And Review Configuration Codes

The configuration codes in the created stack are basically empty, thus we should replace the dev/kcl.mod and dev/main.k with the below codes:

# dev/kcl.mod
[dependencies]
kam = { git = "https://github.com/KusionStack/kam.git", tag = "0.2.0" }
service = { oci = "oci://ghcr.io/kusionstack/service", tag = "0.1.0" }
network = { oci = "oci://ghcr.io/kusionstack/network", tag = "0.2.0" }
mysql = { oci = "oci://ghcr.io/kusionstack/mysql", tag = "0.2.0" }
# dev/main.k 
import kam.v1.app_configuration as ac
import service
import service.container as c
import network as n
import mysql

# main.k declares customized configurations for dev stacks.
wordpress: ac.AppConfiguration {
workload: service.Service {
containers: {
wordpress: c.Container {
image: "wordpress:6.3"
env: {
"WORDPRESS_DB_HOST": "$(KUSION_DB_HOST_WORDPRESS_MYSQL)"
"WORDPRESS_DB_USER": "$(KUSION_DB_USERNAME_WORDPRESS_MYSQL)"
"WORDPRESS_DB_PASSWORD": "$(KUSION_DB_PASSWORD_WORDPRESS_MYSQL)"
"WORDPRESS_DB_NAME": "mysql"
}
resources: {
"cpu": "500m"
"memory": "512Mi"
}
}
}
replicas: 1
}
accessories: {
"network": n.Network {
ports: [
n.Port {
port: 80
}
]
}
"mysql": mysql.MySQL {
type: "cloud"
version: "8.0"
}
}
}

Application Delivery

You can complete the delivery of the WordPress application in the folder of wordpress-cloud-rds/dev using the following command line. Kusion will enable the watching of the application resource creation and automatic port-forwarding of the specified port (80) from local to the Kubernetes Service.

cd dev && kusion apply --watch
info

During the first apply, the models and modules as well as the Terraform CLI (if not exists) that the application depends on will be downloaded, so it may take some time (usually within two minutes). You can take a break and have a cup of coffee.

apply the wordpress application with aws rds

After all the resources reconciled, we can port-forward our local port (e.g. 12345) to the WordPress frontend service port (80) in the cluster:

kubectl port-forward -n wordpress-cloud-rds svc/wordpress-cloud-rds-dev-wordpress-private 12345:80

kubectl port-forward for wordpress

Verify WordPress Application

Next, we will verify the WordPress site service we just delivered, along with the creation of the RDS instance it depends on. We can start using the WordPress site by accessing the link of local-forwarded port (http://localhost:12345) we just configured in the browser.

wordpress site page

In addition, we can also log in to the cloud service console page to view the RDS instance we just created.

aws rds instance

Delete WordPress Application

You can delete the WordPress application and related RDS resources using the following command line.

kusion destroy --yes

kusion destroy wordpress with aws rds