SRE/Data Persistence/Databases/Runbooks

SRE Data Persistence technical documentation

Wikimedia infrastructure

Data centers

Networking

Global traffic routing

MediaWiki SRE

MediaWiki Engineering

Multimedia

Data Engineering

Search

SRE Data Persistence

• MariaDB architecture
  • MariaDB troubleshooting
  • MariaDB monitoring
  • MariaDB backups
  • Database Runbooks
• Bacula
  • Backup Runbooks
  • Offsite Backups
• Cassandra
• External storage
• Orchestrator
• Parser cache
• Swift
  • Media storage
  • Media backups

SRE Infra Foundations

SRE Observability

Wikimedia Performance

Event Platform

Release Engineering

[]

Depooling a replica

Depooling a replica in case of host failure or replication lag

Starting and stopping MariaDB

Steps to start or stop MariaDB.

Provisioning a host

Adding a racked host to configuration.

Reimaging a host

TBD.

Rebooting a host

Steps that need to be taken when rebooting (or booting) a DB host.

Decommissioning a host

Removing a host from configuration and preparing it for physical decommissioning.

Schema change

TBD.

DB sanitization

TBD.

Primary switchover

Steps to switchover a MariaDB primary.

Upgrading a section

Upgrading a section to a new OS and MariaDB version.

Orchestrator operations and troubleshooting

Orchestrator is a service for managing mysql cluster replication.

Database proxy failover

TBD

Changing user passwords

How to change user passwords

Database private information cleanup

How to trim private information