Deploy MySQL on KubeSphere

This tutorial walks you through an example of deploying MySQL from the App Store of KubeSphere.

• Please make sure you enable the OpenPitrix system.

Hands-on Lab

1. On the Overview page of the project , click App Store in the upper-left corner.

2. Find MySQL and click Install on the App Information page.

3. Set a name and select an app version. Make sure MySQL is deployed in demo-project and click Next.

4. In App Settings, uncomment the field and customize the password. Click Install to continue.

5. Wait until MySQL is up and running.

2. In the terminal, execute mysql -uroot -ptesting to log in to MySQL as the root user.

To access MySQL outside the cluster, you need to expose the app through a NodePort first.

1. Go to Services and click the service name of MySQL.

2. Click More and select Edit External Access from the drop-down list.

4. Under Ports, you can see the port is exposed. The port and public IP address will be used in the next step to access the MySQL database.

5. To access your MySQL database, you need to use the MySQL client or install a third-party application such as SQLPro Studio for the connection. The following example demonstrates how to access the MySQL database through SQLPro Studio.

   

   Note

   You may need to open the port in your security groups and configure related port forwarding rules depending on where your Kubernetes cluster is deployed.