#5365 Rewrite database SOP
Closed: Fixed None Opened 7 years ago by puiterwijk.

The database SOP (https://infrastructure.fedoraproject.org/infra/docs/database.rst) is quite outdated wrt server information.

This needs to be refreshed.


Hi all. I'd loke to work on this ticket. Which kind of informations are old?
I could change it then commit.

I just want to make sure is this is the right server information?

Thanks for working on this! :)

Some comments:

  • We don't have a db05. You can look at ansible repo inventory/inventory for the database servers groups:
    {{{
    [dbserver]
    db01.phx2.fedoraproject.org
    db03.phx2.fedoraproject.org
    db-fas01.phx2.fedoraproject.org
    db-datanommer02.phx2.fedoraproject.org
    db-koji01.phx2.fedoraproject.org
    db-s390-koji01.qa.fedoraproject.org
    db-arm-koji01.qa.fedoraproject.org
    db-ppc-koji01.ppc.fedoraproject.org
    db-qa01.qa.fedoraproject.org
    db-qastg01.qa.fedoraproject.org
    }}}

db01 is our main postgresql server for most anything. db03 is mariadb (wiki and paste).
The koji ones are for each of those secondary arch kojis. The qa ones are for taskotron and resultsdb.

The mirrormanager section is out of date (we no longer have app servers). Probibly just remove it.

Hope that helps!

Login to comment on this ticket.

Metadata