Egret - Traven Mir Database Server

Work schedule

A quick checklist... I may have missed something though:

  1. Get the crossover network configured. My last attempt at this resulted in the ethernet driver hanging (on egret fortunately, not on traven).
  2. Ensure the external network interface is sensibly firewalled.
  3. Optionally install a vserver kernel and set up a vserver within which to run postgres. Personally I'm not sure that we gain a lot from this added complexity.
  4. Set up an encrypted partition for the database.
  5. Install postgres, configured as on traven but with network access via (only) the crossover interface.
  6. One at a time, take Mir sites down, dump their databases and restore them into postgres on egret, modify the database options in to point at egret and restart them.
  7. Move the nightly db dump cronjob(s) onto egret.

I think that's basically it.

Current status, in the rack at riseup, with a gigabit crossover to traven.

It's running Debian (sarge), and already has postgres listening on the crossover interface. It hasn't had any particular tuning done, but then neither really has the postgres on traven (as none of us are experienced postgres admins...)

Traven documents

-- GarconDuMonde - 13 May 2006
Topic revision: r1 - 13 May 2006, GarconDuMonde
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback