Page MenuHomePhabricator

Followup for TLS MariaDB server roll-out
Open, MediumPublic

Description

After the main support for TLS was added on the db hosts (as pert of T134809).

This is more of a "decisions" ticket, specific actions decided should have its own subticket:

  • Pending, non-critical, to be decomm'ed hosts: T111654#3010354
  • Enforce TLS by all clients
  • Once it is enforced, which is the preferred cipher? size?
  • Renewal policy
  • Enforce TLS by MySQL as a client (replication user) and make sure it is verified
    • Do we have a plan in case of disaster?
  • Plans in case of a) 1 server/client private's key compromised b) CA gets fully compromised
  • Check validity/expiration of certificates on icinga
  • Add other names other than the public dns to the certs (s1-master, s1-replica, ip address, etc.)

Related Objects

Event Timeline

Change 337018 had a related patch set uploaded (by Jcrespo):
Install wmf-mariadb-client for client-only installs

https://gerrit.wikimedia.org/r/337018

Change 337018 merged by Jcrespo:
Install wmf-mariadb-client for client-only installs

https://gerrit.wikimedia.org/r/337018

Change 337022 had a related patch set uploaded (by Jcrespo):
Apply a3ded1b40909f9351 (mariadb client install) to production

https://gerrit.wikimedia.org/r/337022

Change 337022 merged by Jcrespo:
Apply a3ded1b40909f9351 (mariadb client install) to production

https://gerrit.wikimedia.org/r/337022

Change 338988 had a related patch set uploaded (by Jcrespo):
Remove old CA (ssl='on') and add a new option "socket"

https://gerrit.wikimedia.org/r/338988

m1 slave db1001 has been restarted and TLS enabled.

Change 338988 merged by jenkins-bot:
[operations/puppet/mariadb] Remove old CA (ssl='on') and add a new option "socket"

https://gerrit.wikimedia.org/r/338988

jcrespo added a subscriber: Vgutierrez.

CC @Vgutierrez pending work regarding TLS rollout FYI