Skip to content

WIP: patroni runbooks updates

Michal Wasilewski requested to merge michalw/patroni-runbooks-updates into master

This is a first iteration on improving procedures used for database related operations. For more context see: https://gitlab.com/gitlab-com/gl-infra/infrastructure/issues/7548

This MR should cover at least the following operations:

  • add a new node, see if we have all the steps working correctly.
  • in case of a minor failure, how can re-add a node.
  • Remove a node from receiving traffic.
  • Remove a node from the patroni possible failover.
  • How to apply a change of a parameter in patroni/pgbouncer.
  • how to restart/stop patroni.
  • How to change of a parameter in pgbouncer.
  • how to restart pgbouncer instance.
  • How to connect to the PostgreSQL terminal or pgbouncer.
  • how to execute a query on the variables of pgbouncer.
  • How to perform a SQL statement in the Postgresql database.
  • how to check-in Postgresql what queries are being executed on the moment ( pg_stat_activity view ) or during the last xxx seconds.
  • mermaid graph with pgbouncer, patroni, postgres
  • examples of EXPLAIN ANALYZE usage
  • provide learning materials (e.g. links to Deep Dives, RCAs, exercises, books, course, etc)
Edited by Pierre Guinoiseau

Merge request reports