Install Percona XtraDB Cluster on Amazon Elastic Kubernetes Service (EKS)¶
This quickstart shows you how to deploy Percona XtraDB cluster operator 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.
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,
- the amount of on-demand and spot instances to use.
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
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"
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/<namespace name> was created, and the context was modified.
Use the following
git clonecommand to download the correct branch of the percona-xtradb-cluster-operator repository:
git clone -b v1.7.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:
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:
During previous steps, the Operator has generated several secrets, including the password for the
rootuser, which you will need to access the cluster.
kubectl get secretscommand to see the list of Secrets objects (by default Secrets object you are interested in has
kubectl get secret my-cluster-secrets -o yamlwill 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 --decodewill bring it back to a human-readable form (in this example it will be a
Now you can check wether you are able to connect to MySQL from the outside with the help of the
kubectl port-forwardcommand as follows:
kubectl port-forward svc/example-proxysql 3306:3306 & mysql -h 127.0.0.1 -P 3306 -uroot -proot_password