Install Percona XtraDB Cluster on Amazon Elastic Kubernetes Service (EKS)¶
This quickstart shows you how to deploy the Operator and Percona XtraDB Cluster on Amazon Elastic Kubernetes Service (EKS). The document assumes some experience with Amazon EKS. For more information on the EKS, see the Amazon EKS official documentation.
Prerequisites¶
The following tools are used in this guide and therefore should be preinstalled:
-
AWS Command Line Interface (AWS CLI) for interacting with the different parts of AWS. You can install it following the official installation instructions for your system.
-
eksctl to simplify cluster creation on EKS. It can be installed along its installation notes on GitHub.
-
kubectl to manage and deploy applications on Kubernetes. Install it following the official installation instructions.
Also, you need to configure AWS CLI with your credentials according to the official guide.
Create the EKS cluster¶
To create your cluster, you will need the following data:
-
name of your EKS cluster,
-
AWS region in which you wish to deploy your cluster,
-
the amount of nodes you would like tho have,
Note
spot instances are not recommended for production environment, but may be useful e.g. for testing purposes.
The most easy and visually clear way is to describe the desired cluster in YAML
and to pass this configuration to the eksctl
command.
The following example configures a EKS cluster with one managed node group:
apiVersion: eksctl.io/v1alpha5
kind: ClusterConfig
metadata:
name: test-cluster
region: eu-west-2
nodeGroups:
- name: ng-1
minSize: 3
maxSize: 5
instancesDistribution:
maxPrice: 0.15
instanceTypes: ["m5.xlarge", "m5.2xlarge"] # At least two instance types should be specified
onDemandBaseCapacity: 0
onDemandPercentageAboveBaseCapacity: 50
spotInstancePools: 2
tags:
'iit-billing-tag': 'cloud'
preBootstrapCommands:
- "echo 'OPTIONS=\"--default-ulimit nofile=1048576:1048576\"' >> /etc/sysconfig/docker"
- "systemctl restart docker"
Note
preBootstrapCommands
section is used in the above example to increase the limits for the amount of opened files:
this is important and shouldn’t be omitted, taking into account the
default EKS soft limit of 65536 files.
When the cluster configuration file is ready, you can actually create your cluster by the following command:
$ eksctl create cluster -f ~/cluster.yaml
Install the Operator¶
-
Create a namespace and set the context for the namespace. The resource names must be unique within the namespace and provide a way to divide cluster resources between users spread across multiple projects.
So, create the namespace and save it in the namespace context for subsequent commands as follows (replace the
<namespace name>
placeholder with some descriptive name):$ kubectl create namespace <namespace name> $ kubectl config set-context $(kubectl config current-context) --namespace=<namespace name>
At success, you will see the message that namespace/
was created, and the context was modified. -
Use the following
git clone
command to download the correct branch of the percona-xtradb-cluster-operator repository:$ git clone -b v1.12.0 https://github.com/percona/percona-xtradb-cluster-operator
After the repository is downloaded, change the directory to run the rest of the commands in this document:
$ cd percona-xtradb-cluster-operator
-
Deploy the Operator with the following command:
$ kubectl apply -f deploy/bundle.yaml
The following confirmation is returned:
customresourcedefinition.apiextensions.k8s.io/perconaxtradbclusters.pxc.percona.com created customresourcedefinition.apiextensions.k8s.io/perconaxtradbclusterbackups.pxc.percona.com created customresourcedefinition.apiextensions.k8s.io/perconaxtradbclusterrestores.pxc.percona.com created customresourcedefinition.apiextensions.k8s.io/perconaxtradbbackups.pxc.percona.com created role.rbac.authorization.k8s.io/percona-xtradb-cluster-operator created serviceaccount/percona-xtradb-cluster-operator created rolebinding.rbac.authorization.k8s.io/service-account-percona-xtradb-cluster-operator created deployment.apps/percona-xtradb-cluster-operator created
-
The operator has been started, and you can create the Percona XtraDB cluster:
$ kubectl apply -f deploy/cr.yaml
The process could take some time. The return statement confirms the creation:
perconaxtradbcluster.pxc.percona.com/cluster1 created
-
During previous steps, the Operator has generated several secrets, including the password for the
root
user, which you will need to access the cluster.Use
kubectl get secrets
command to see the list of Secrets objects (by default Secrets object you are interested in hascluster1-secrets
name). Thenkubectl get secret cluster1-secrets -o yaml
will return the YAML file with generated secrets, including the root password which should look as follows:... data: ... root: cm9vdF9wYXNzd29yZA==
Here the actual password is base64-encoded, and
echo 'cm9vdF9wYXNzd29yZA==' | base64 --decode
will bring it back to a human-readable form (in this example it will be aroot_password
string). -
Now you can check wether you are able to connect to MySQL from the outside with the help of the
kubectl port-forward
command as follows:$ kubectl port-forward svc/example-proxysql 3306:3306 & $ mysql -h 127.0.0.1 -P 3306 -uroot -proot_password