Step 1: Create a MySQL Workload
WordPress must be used together with MySQL. WordPress runs the content management program while MySQL serves as a database to store data.
Prerequisites
A CCE cluster with running nodes has been created. For details on how to create a cluster, see Creating a Kubernetes Cluster.
Creating a MySQL Workload
- Log in to the CCE console.
- Choose the target cluster.
- In the navigation pane, choose Workloads. Then, click Create from Image.
- Set workload parameters.
Basic Info
- Workload Type: Select Deployment.
- Workload Name: Set it to mysql.
- Namespace: Select default.
- Pods: Change the value to 1 in this example.
Figure 1 Basic information about the MySQL workload
Container Settings
In the Basic Info area, click Select Image. In the dialog box displayed, select Open Source Images, search for mysql, and select the mysql image.
Figure 2 Selecting the MySQL image
Select 5.7 for Image Version.
Figure 3 Selecting an image tag
Add the following four environment variables (details available in MySQL):
- MYSQL_ROOT_PASSWORD: password of the root user of MySQL.
- MYSQL_DATABASE: name of the database created during image startup.
- MYSQL_USER: name of the database user.
- MYSQL_PASSWORD: password of the database user.
Figure 4 Setting environment variables
Service Settings
Click the plus sign (+) to create a Service for accessing MySQL from WordPress.
Select ClusterIP for Access Type, set Service Name to mysql, set both the Container Port and Service Port to 3306, and click OK.
The default access port in the MySQL image is 3306. In this example, both the container port and Service port are set to 3306 for convenience. The access port can be changed to another port.
In this way, the MySQL workload can be accessed through Service name:Access port (mysql:3306 in this example) from within the cluster.
Figure 5 Creating a Service
- Click Create Workload.
Wait until the workload is created.
The created Deployment will be displayed on the Deployments page.
Figure 6 Workload created successfully
Last Article: Overview
Next Article: Step 2: Create a WordPress Workload
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.