+1 from sysadmin-main smoogen

On Wed, 15 Sept 2021 at 12:13, Mark O'Brien <markobri(a)redhat.com&gt; 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 > > > Thanks, > Mark > _______________________________________________ > infrastructure mailing list -- infrastructure(a)lists.fedoraproject.org > To unsubscribe send an email to infrastructure-leave(a)lists.fedoraproject.org > Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ > List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines > List Archives: https://lists.fedoraproject.org/archives/list/infrastructure@lists.fedora... > Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure -- Stephen J Smoogen. I've seen things you people wouldn't believe. Flame wars in sci.astro.orion. I have seen SPAM filters overload because of Godwin's Law. All those moments will be lost in time... like posts on a BBS... time to shutdown -h now.

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...

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)

Also, is this something worth also doing in staging?

kevin

On Wed, Sep 15, 2021 at 10:15:22PM +0100, Mark O'Brien wrote: > > 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. Yeah, thats not freeze breaking, I just thought it would be handy to see that info also. :) > > 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. Well, then what happens to db-datanommer01.stg long term? it will be the old install? Don't we need to convert it someday?

kevin