Skip to content

Latest commit

 

History

History
199 lines (119 loc) · 7.51 KB

deploy_radondb-mysql_operator_on_rancher.md

File metadata and controls

199 lines (119 loc) · 7.51 KB
Raw

English | 简体中文

Contents

Deploy a RadonDB MySQL cluster on Rancher

Introduction

RadonDB MySQL is an open-source, high-availability, and cloud-native database cluster solution based on MySQL. It supports the high-availability architecture of one leader node and multiple replicas, with a set of management functions for security, automatic backup, monitoring and alarming, automatic scaling, and so on. RadonDB MySQL has been widely used in production by banks, insurance enterprises, and other traditional large enterprises.

RadonDB MySQL can be deployed and managed on Rancher to automate tasks relevant to RadonDB MySQL clusters.

This tutorial demonstrates how to deploy RadonDB MySQL Operator and a RadonDB MySQL cluster on Rancher.

Prerequisites

Procedure

Step 1: Add a Helm repository.

  1. Log in to the Rancher console.

  2. Select a cluster to open the cluster management page.

  3. Select App&Marketplace > Repositories to go to the application repository management page.

  4. Click Create to create a repository for RadonDB MySQL.

    • Name: User-defined repository name.

    • Target: Select the HTTP(S) mode and set Index URL to https://radondb.github.io/radondb-mysql-kubernetes/.

  5. Click Create and return to the repository management page.

    If the State of the repository changes to Active, the repository is running properly.

Step 2: Install Operator.

You only need to install RadonDB MySQL Operator once for a Rancher cluster.

  1. On the cluster management page, select App&Marketplace > Charts to go to the chart list page.

  2. Locate mysql-operator to install RadonDB MySQL Operator.

    You can select a version of the mysql-operator chart.

  3. Click Install and configure the application basic information.

    You can select Customize Helm options before install.

  4. (Optional) Click Next to customize the YAML settings of the application.

  5. Click Next to configure the deployment options.

  6. Click Install to go to the Installed App page.

    You can view the installation progress and status in the pane below the list. After the application installation process is complete, you can view the installed application in the list.

Step 3: Deploy a RadonDB MySQL cluster.

Use the CLI

  1. On the cluster management page, click the kubectl command icon in the upper-right corner.

  2. In the command pane, enter the command to deploy a cluster.

    The following command deploys a three-node cluster.

    # Run kubectl commands inside here
# e.g. kubectl get all
$ cat <<EOF | kubectl apply -f-
apiVersion: mysql.radondb.com/v1alpha1
kind: MysqlCluster
metadata:
   name: sample
spec:
   replicas: 3
EOF

  3. Press Enter. If created is displayed in the command output, the deployment is successful.

    The following is an example of the command output:

    mysqlcluster.mysql.radondb.com/sample created

Import a YAML File

  1. Download the RadonDB MySQL Cluster Configuration Sample and modify the parameter values in the YAML file.

    For details about the parameters, see Configuration Parameters.

  2. On the cluster management page of Rancher, click the YAML import icon in the upper-right corner. In the displayed dialog box, import the modified YAML file.

Verification

  1. On the cluster management page, select Service Discovery > Service to go to the service list page.

  2. Locate the installed cluster and check the service status.

    If the status of a service is Active, the service is running properly.

  3. Click the service name to open the service details page and check the pod status.

    If the status of a pod is Active, the pod is running properly.

  4. On the right of an active pod, click Execute Shell to open the command pane of the pod.

    Run the following command and enter the password to verify the database connection status.

    $ mysql -u root -p

    The following figure shows the command output of a database with normal connections:

Access RadonDB MySQL

Note

You need to prepare a client used to connect to MySQL.

  • If the client is installed in a different Rancher cluster from the database, you need to set the load balancer and ingress controller on Rancher.

    For more information about how to access a database from a different cluster, see Access Applications in a Cluster.

  • If the client is installed in the same Rancher cluster as the database, you can access RadonDB MySQL by using a service name or cluster IP address.

    Note

    RadonDB MySQL provides a leader service and a follower service, which are used to access the leader node and follower nodes respectively. The leader service always points to the leader node that supports read and write, and the follower service always points to the follower nodes that are read-only.

The following demonstrates how to access RadonDB MySQL by using a client in the same Rancher cluster as the database.

Use a Cluster IP Address

The HA read-and-write IP address of RadonDB MySQL points to the cluster IP address of the leader service, and the HA read-only IP address points to the IP address of the follower service.

$ mysql -h <clusterIP> -P <mysql_Port> -u <user_name> -p

For example, run the following command to access the leader service, where the username is radondb_usr and the cluster IP address of the leader service is 10.10.128.136:

$ mysql -h 10.10.128.136 -P 3306 -u radondb_usr -p

Use a Service Name

Pods in the Rancher cluster can access RadonDB MySQL by using a service name.

Note

Service names cannot be used to access RadonDB MySQL from the host machines of the Rancher cluster.

  • Access the leader service (RadonDB MySQL leader node)

    mysql -h <leader_service_name>.<namespace> -u <user_name> -p

    For example, run the following command to access the leader service, where the username is radondb_usr, the release name is sample, and the namespace of RadonDB MySQL is default:

    mysql -h sample-leader.default -u radondb_usr -p

  • Access the follower service (RadonDB MySQL follower nodes)

    mysql -h <follower_service_name>.<namespace> -u <user_name> -p

    For example, run the following command to access the leader service, where the username is radondb_usr, the release name is sample, and the namespace of RadonDB MySQL is default:

    mysql -h sample-follower.default -u radondb_usr -p