aboutsummaryrefslogtreecommitdiffstats
path: root/docs/meeting_notes/2023-08-01.rst
diff options
context:
space:
mode:
Diffstat (limited to 'docs/meeting_notes/2023-08-01.rst')
-rw-r--r--docs/meeting_notes/2023-08-01.rst66
1 files changed, 66 insertions, 0 deletions
diff --git a/docs/meeting_notes/2023-08-01.rst b/docs/meeting_notes/2023-08-01.rst
new file mode 100644
index 0000000..925417a
--- /dev/null
+++ b/docs/meeting_notes/2023-08-01.rst
@@ -0,0 +1,66 @@
+DevOps Meeting Notes
+====================
+
+Agenda
+------
+
+Infrastructure migration
+~~~~~~~~~~~~~~~~~~~~~~~~
+
+The vote is tied. Chris and Johannes decided that we should test out
+migrating the PostgreSQL database at the very least. We then have more
+freedom about our data. What we need to do:
+
+- Allow PostgreSQL connections from LKE’s static IPs in the firewall
+- Whitelist the static IPs from Linode via ``pg_hba.conf``
+- Schedule downtime for the PostgreSQL database
+- **At downtime**
+
+ - Take writers offline
+ - Dump database from Linode into Netcup
+ - Update all the client’s database URLs to point to netcup
+ - Restart writers
+
+We want to rely on the restore to create everything properly, but will
+need to test run this beforehand. The following ``pg_virtualenv``
+command has showcased that it works properly:
+
+.. code:: sh
+
+ kubectl exec -it postgres-... -- pg_dumpall -U pythondiscord \
+ | pg_virtualenv psql -v ON_ERROR_STOP=1
+
+Note however that the database extension ``pg_repack`` needs to be
+installed.
+
+Before we can get started, we need to allow the PostgreSQL role to
+configure ``pg_hba.conf`` and ``postgresql.conf`` entries.
+
+Meeting notes
+~~~~~~~~~~~~~
+
+We’re using GitHub at the moment. Some are left in Notion. We should
+migrate these to GitHub to have a uniform interface: Johannes will pick
+up
+`python-discord/infra#108 <https://github.com/python-discord/infra/issues/108>`__
+to merge them together into Git, as its more open than Notion.
+
+Ansible lint failures in the infra repository
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+Excluding the vault was found as the working solution here, as
+implemented by Chris.
+
+Kubernetes repository pull requests
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+These were cleaned up thanks to Chris.
+
+Roadmap review & planning
+-------------------------
+
+- Chris will prepare the PostgreSQL configuration mentioned above.
+
+.. raw:: html
+
+ <!-- vim: set textwidth=80 sw=2 ts=2: -->