Recreate patroni-ci and patroni-ci1 clusters on GPRD
During production#7250 (closed) the patroni-ci and patroni-ci1 clusters got out of sync with patroni-v12-10 on gprd.
Due to this they need to be re-initialized.
Currently both primary nodes of patroni-ci and patroni-ci1 are being initialized, and we have removed all secondary replicas on those clusters:
root@patroni-ci-01-db-gprd.c.gitlab-production.internal:~# gitlab-patronictl list
+ Cluster: gprd-patroni-ci (initializing) -----------+---------------+---------+------------------+----+-----------+
| Member | Host | Role | State | TL | Lag in MB |
+----------------------------------------------------+---------------+---------+------------------+----+-----------+
| patroni-ci-01-db-gprd.c.gitlab-production.internal | 10.220.23.101 | Replica | creating replica | | unknown |
+----------------------------------------------------+---------------+---------+------------------+----+-----------+
root@patroni-ci1-01-db-gprd.c.gitlab-production.internal:~# gitlab-patronictl list
+ Cluster: gprd-patroni-ci1 (initializing) -----------+---------------+---------+------------------+----+-----------+
| Member | Host | Role | State | TL | Lag in MB |
+-----------------------------------------------------+---------------+---------+------------------+----+-----------+
| patroni-ci1-01-db-gprd.c.gitlab-production.internal | 10.220.25.101 | Replica | creating replica | | unknown |
+-----------------------------------------------------+---------------+---------+------------------+----+-----------+
Once these nodes are fully initialized and actively replicating from patroni-v12-10-db-gprd.c.gitlab-production.internal
we will proceed with increasing the node count in Terraform to add new replica nodes to the clusters.