New to KubeDB? Please start here.

Reconfiguring TLS of MSSQLServer Database

This guide will give an overview on how KubeDB Ops-manager operator reconfigures TLS configuration i.e. add TLS, remove TLS, update issuer/cluster issuer or Certificates and rotate the certificates of a MSSQLServer database.

Before You Begin

• You should be familiar with the following KubeDB concepts:
  • MSSQLServer
  • MSSQLServerOpsRequest

How Reconfiguring MSSQLServer TLS Configuration Process Works

The following diagram shows how KubeDB Ops-manager operator reconfigures TLS of a MSSQLServer database. Open the image in a new tab to see the enlarged version.

  

The Reconfiguring MSSQLServer TLS process consists of the following steps:

1. At first, a user creates a MSSQLServer Custom Resource Object (CRO).

2. KubeDB Provisioner operator watches the MSSQLServer CRO.

3. When the operator finds a MSSQLServer CR, it creates required number of PetSets and related necessary stuff like secrets, services, etc.

4. Then, in order to reconfigure the TLS configuration of the MSSQLServer database the user creates a MSSQLServerOpsRequest CR with desired information.

5. KubeDB Ops-manager operator watches the MSSQLServerOpsRequest CR.

6. When it finds a MSSQLServerOpsRequest CR, it pauses the MSSQLServer object which is referred from the MSSQLServerOpsRequest. So, the KubeDB Provisioner operator doesn’t perform any operations on the MSSQLServer object during the reconfiguring TLS process.

7. Then the KubeDB Ops-manager operator will add, remove, update or rotate TLS configuration based on the Ops Request yaml.

8. Then the KubeDB Ops-manager operator will restart all the Pods of the database so that they restart with the new TLS configuration defined in the MSSQLServerOpsRequest CR.

9. After the successful reconfiguring of the MSSQLServer TLS, the KubeDB Ops-manager operator resumes the MSSQLServer object so that the KubeDB Provisioner operator resumes its usual operations.

In the next docs, we are going to show a step-by-step guide on reconfiguring TLS configuration of a MSSQLServer database using MSSQLServerOpsRequest CRD.