How to migrate MySQL to Redis Database in Spinnaker.

MySQL for Orca and Clouddriver on Openshift environment

In this blog, we are going to demonstrate how to configure MySQL as the datastore for Orca and Clouddriver microservices on Openshift environment pods without any downtime. This is also applicable to any Kubernetes environment.

Spinnaker has been using Redis as the data store for all its microservices.
We have been maintaining a number of enterprise Spinnaker infrastructure footprint over time exposed to a number of scaling challenges with Clouddriver and Orca’s original Redis-backed caching implementation. For example, with time we realized with a large number of applications & pipelines deployed we need to rely on a database built for persistence and indexing for faster access to data structures. Additionally, MySQL knowledge is fairly ubiquitous and checks our core requirements and also has the added benefit of query flexibility.

Goals:

Running MySQL pod on Openshift has its own challenges as one needs to run them as a non-root user. We are going to configure two MySQL deployments along with its service and configMap for Clouddriver and Orca.

The cloud driver deployment won’t have any persistence storage for it, but the Orca which is responsible for maintaining all the active and history of pipeline execution will be assigned a  PV.

Clouddriver would be switched over to MySQL as we don’t have any dependencies on it.
For Orca we would be using Dual-Task Repository i.e. all the new executions would be going to MySQL and all the historical executions would be fetched from Redis.MySQL 5.7 has been tested with Orca and Clouddriver.

Openshift Image: “ docker pull registry.access.redhat.com/rhscl/mysql-57-rhel7”

Kubernetes Image: “docker pull mysql:5.7”

These are the steps that we would be following in the blog:

Step 1: Configure MySQL deployment with service, ConfigMap & PVC for cloud driver and Orca (PVC would be configured only for orca for data persistence).

Step 2: Configure the Database and users for cloud driver and orca respectively.

Step 3: Configure the cloud driver-local.yml and orca-local.yml  with the updated MySQL settings and do a “hal deploy apply” with the service names.

Configuring MySQL deployment for cloud driver

This is how the deployment for cloud driver looks like, we don’t use a PVC for it. We are not interested in storing the data for cloud driver:

The service and Config Map would look like this:

 

Configuring MySQL deployment for Orca:

We configure the MySQL deployment of Orca similar to Clouddriver but we are going to use a PVC to store the Database to avoid data loss. We do backup the MySQL DB to ensure we don’t incur any data loss.

The service, PVC and the configMap:


Configure the MySQL Database and Users for cloud driver

Once the pod is up and running, you need to execute the following commands:

Login via root as one needs to create the user via root :

# MySQL -u root -p$MYSQL_PASSWORD -h $HOSTNAME $MYSQL_DATABASE

Once you are in the prompt, the first step is to create a Database called “cloud driver” and then create two users the clouddriver_service & clouddriver_migrate which would be given the permissions to access it.

# mysql> CREATE SCHEMA `cloud driver` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# mysql> CREATE USER ‘clouddriver_service’@'%' IDENTIFIED BY 'password';
# mysql> CREATE USER ‘clouddriver_migrate’@'%' IDENTIFIED BY 'password';
# mysql>  GRANT  SELECT, INSERT, UPDATE, CREATE, DELETE, EXECUTE, SHOW VIEW ON `cloud driver`.*   TO 'clouddriver_service'@'%';
# mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, LOCK TABLES, EXECUTE, SHOW VIEW  ON `cloud driver`.* TO 'clouddriver_migrate'@'%';


You can see that the user’s cloud driver-service & clouddriver_migrate has been created with their passwords. Also, you can view the Database “cloud driver” being also configured

Configure the MySQL Database and Users for Orca:

# mysql> CREATE SCHEMA `orca` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# mysql> CREATE USER ‘orca_service’@'%' IDENTIFIED BY 'password';
# mysql> CREATE USER ‘orca_migrate’@'%' IDENTIFIED BY 'password';
# mysql>  GRANT  SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW ON `orca`.*   TO 'orca_service'@'%';
# mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, LOCK TABLES, EXECUTE, SHOW VIEW  ON `orca`.* TO 'orca_migrate'@'%';


You can see that the users orca_service & orca_migrate has been created with their passwords. Also, you can view the Database “orca” being also configured

Configuring the cloud driver-local.yml to point to MySQL from Redis:

Once you have configured the MySQL Database and the users we need to edit the cloud driver-local.yml to point to MySQL and switch over from Redis. Since we had running cloud driver instances in HA mode, we updated in the   ~/.hal/default/profiles/cloud driver-local.yml


Configuring the orca-local.yml to apply Dual Execution Repository:

Once you have configured the MySQL Database and the users we need to edit the orca-local.yml to point to both MySQL and Redis as we are using Dual Execution Repository.

So, all the newer executions would go to MySQL and all historical executions can be retrieved from Redis.

The next step similar to cloud driver, for orca we updated in the   ~/.hal/default/profiles/orca-local.yml

Once you have configured the cloud driver-local.yml and orca-local.yml you need to do a “hal deploy apply” with the service names of cloud driver and orca.

Verification that new pipelines are going to the MySQL:

Login into the MySQL orca pod and then in the terminal you verify that on the pipelines tables on the orca DB we have the recent 9 pipelines we had triggered:

Conclusion:

We have shown how to configure MySQL backend for Orca and Clouddriver. As you can see it is fairly simple. Stay tuned on how to migrate existing DB in Redis for Orca to MySQL with no downtime.

Leave a Reply

Your email address will not be published. Required fields are marked *