On Wed, Sep 15, 2021 at 6:55 PM Kevin Fenzi <kevin@scrye.com> wrote:
On Wed, Sep 15, 2021 at 05:13:16PM +0100, Mark O'Brien wrote:
> Hi All,
>
> I have a dns patch for review.
>
> We would like to add a second datanommer db server
> so that we can migrate the current database to it and
> make some changes such as adding the timescaledb
> plugin to improve performance. This second server would
> allow the migration to happen without affecting the main
> prod server.
>
> The patch is available to view here:
> https://gist.github.com/markobrien1/1b242fb8e27da07253550abf328a5e8e
>
> Please chime in with comments or +1's

+1 with a few comments...

Thank you 

You could also do a PR with the ansible changes. ;)

Should be adding to inventory/inventory and
inventory/host_vars/db-datanommer02.iad.fedoraproject.org
and
playbooks/groups/postgresql-server.yml
(unless this deployment isn't using that role/playbook, I don't know if
it is)

The PR is here https://pagure.io/fedora-infra/ansible/pull-request/795 
I didn't add it here because I thought (incorrectly?) an FBR wasn't needed 
as this is all new. 

Also, is this something worth also doing in staging?

I don't think we need it for staging as it's only a temporary measure for the migration.
 

kevin

Mark