Install Percona XtraDB Cluster on OpenShift¶
First of all, clone the percona-xtradb-cluster-operator repository:
git clone -b v1.6.0 https://github.com/percona/percona-xtradb-cluster-operator cd percona-xtradb-cluster-operator
It is crucial to specify the right branch with the-b option while cloning the code on this step. Please be careful.
Now Custom Resource Definition for PXC should be created from the
deploy/crd.yamlfile. Custom Resource Definition extends the standard set of resources which Kubernetes “knows” about with the new items (in our case ones which are the core of the operator).
This step should be done only once; it does not need to be repeated with the next Operator deployments, etc.
$ oc apply -f deploy/crd.yaml
Setting Custom Resource Definition requires your user to have cluster-admin role privileges.
If you want to manage your PXC cluster with a non-privileged user, necessary permissions can be granted by applying the next clusterrole:
$ oc create clusterrole pxc-admin --verb="*" --resource=perconaxtradbclusters.pxc.percona.com,perconaxtradbclusters.pxc.percona.com/status,perconaxtradbclusterbackups.pxc.percona.com,perconaxtradbclusterbackups.pxc.percona.com/status,perconaxtradbclusterrestores.pxc.percona.com,perconaxtradbclusterrestores.pxc.percona.com/status $ oc adm policy add-cluster-role-to-user pxc-admin <some-user>
If you have a cert-manager installed, then you have to execute two more commands to be able to manage certificates with a non-privileged user:
$ oc create clusterrole cert-admin --verb="*" --resource=issuers.certmanager.k8s.io,certificates.certmanager.k8s.io $ oc adm policy add-cluster-role-to-user cert-admin <some-user>
The next thing to do is to create a new
$ oc new-project pxc
Now RBAC (role-based access control) for PXC should be set up from the
deploy/rbac.yamlfile. Briefly speaking, role-based access is based on specifically defined roles and actions corresponding to them, allowed to be done on specific Kubernetes resources (details about users and roles can be found in OpenShift documentation).
$ oc apply -f deploy/rbac.yaml
Finally, it’s time to start the operator within OpenShift:
$ oc apply -f deploy/operator.yaml
Now that’s time to add the PXC Users secrets to OpenShift. They should be placed in the data section of the
deploy/secrets.yamlfile as logins and base64-encoded passwords for the user accounts (see Kubernetes documentation for details).
The following command can be used to get base64-encoded password from a plain text string:
$ echo -n 'plain-text-password' | base64
After editing is finished, users secrets should be created (or updated with the new passwords) using the following command:
$ oc apply -f deploy/secrets.yaml
More details about secrets can be found in Users.
Now certificates should be generated. By default, the Operator generates certificates automatically, and no actions are required at this step. Still, you can generate and apply your own certificates as secrets according to the TLS instructions.
After the operator is started and user secrets are added, Percona XtraDB Cluster can be created at any time with the following command:
$ oc apply -f deploy/cr.yaml
Creation process will take some time. The process is over when both operator and replica set pod have reached their Running status:
$ oc get pods NAME READY STATUS RESTARTS AGE cluster1-haproxy-0 1/1 Running 0 5m cluster1-haproxy-1 1/1 Running 0 5m cluster1-haproxy-2 1/1 Running 0 5m cluster1-pxc-0 1/1 Running 0 5m cluster1-pxc-1 1/1 Running 0 4m cluster1-pxc-2 1/1 Running 0 2m percona-xtradb-cluster-operator-dc67778fd-qtspz 1/1 Running 0 6m
Check connectivity to newly created cluster
$ oc run -i --rm --tty percona-client --image=percona:8.0 --restart=Never -- bash -il percona-client:/$ mysql -h cluster1-haproxy -uroot -proot_password
This command will connect you to the MySQL monitor.
mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1976 Server version: 8.0.19-10 Percona XtraDB Cluster (GPL), Release rel10, Revision 727f180, WSREP version 26.4.3 Copyright (c) 2009-2020 Percona LLC and/or its affiliates Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.