Ticket #705 (closed outage: fixed)

Opened 6 years ago

Last modified 6 years ago

DB upgrade (db1 db2)

Reported by: mmcgrath Owned by: mmcgrath
Priority: major Milestone:
Component: Systems Version:
Severity: High Keywords:
Cc: Blocked By:
Blocking: Sensitive:

Description

We'll be moving db1 and db2/koji to new hardware. Koji will be on db3, a dedicated database server just for koji. db1 is just newer hardware, etc.

This will take koji down the longest for a minimum of 8 hours, likely 9.

It will take smolt and the wiki down for less then an hour.

============= Message to FIL ================== So next week will be an interesting week regarding our databases. It just so happened this way but db1 and db3 will be ready at about the same time. The new db1 will replace the old db1 exactly. We'd already migrated to it a couple of weeks ago but had to revert after some memory issues came up. I believe that has been resolved.

db3 is a little different. db2 will remain as the primary database for all databases except for koji. Koji will get moved to db3 which will also have Postgresql 8.3 on it. I'd like to leave db2 at 8.1 for the immediate future, after we've determined db3 is a success we'll schedule a time to update db2 to 8.3 as well.

Initial, very basic tests (db import) showed that with koji at least, postgresql 8.3 was significantly faster. 8.5 hours instead of 14.4 hours to import the koji database.

-Mike

Change History

comment:1 Changed 6 years ago by ricky

  • Status changed from new to closed
  • Resolution set to fixed

Looks like everything went well. If you see this when you get back, maybe it's a good time to officially announce that it's over :-)

Note: See TracTickets for help on using tickets.