I’m curious what type of machine people here using to run RT as well as
what sort of database, and if the machines have anything else running on
them.
At the moment I’m thinking about running the RT instance in a VMWare
server pointing the database to our departmental MySQL server.
I’m looking xen instead of VMWare server because it might allow for
quicker disaster recovery.
Either way I figure we’d be covered by a once a day snapshot of the
virtual machine and we can use our current database backup schemes so
nothing new would have to be done for RT on the db server.
How do you all handle backups/DR? Is anyone else running RT in a virtual
machine?
I’m curious what type of machine people here using to run RT as well
as what sort of database, and if the machines have anything else
running on them.
How do you all handle backups/DR? Is anyone else running RT in a
virtual machine?
i run rt on a real host (non virt) mysql resides on a netapp filer which
gets mirrored 3000 miles away every 30 minutes,
in addition i dump full db nightly.
we do DR testing once a month, and so far have not had any issues, we
tend to rely on the mysql dump though, the netapp mirror will only be
used for reading the tickets opened within the past 12 -/+ hours
because the mysql db is pretty much always in a constant state of
writing, i would not rely on a snapshot too much, the *.FYI files
usually get a bit messed up…
eats the blues for breakfast,
does unix for rent,
plays harp for food,
will play the flute for kicks
rides for the freedom
I’m curious what type of machine people here using to run RT as well
as what sort of database, and if the machines have anything else
running on them.
At the moment I’m thinking about running the RT instance in a VMWare
server pointing the database to our departmental MySQL server.
I’ve built a pair of MySQL servers configured for circular replication
as VMware images, and have both my production and development RT systems
running as VMware images also. It works just peachy, though I will
admit that I don’t have a very large database.
I’m curious what type of machine people here using to run RT as well as
what sort of database, and if the machines have anything else running on
them.
At the moment in a VM running as on one cpu on a Tyan B4882T46U2H with
dual core AMD Opterons at 2Ghz with 4Gb memory.
The RT VM has 768Mb memory. We are running RT-3.6.1 using Oracle XE with
RTFM-2.2RC2 and AT-1.2.3
Number of tickets is about 33000 with a couple of groups and about 20
priviledged users.
This machine has multiple RT VM’s (prod 2x/test/demo/) and further a
couple of small and big test/production linux/MS installations.
CPU usage is rarely over 15% and memory usage around 2Gb.
At the moment I’m thinking about running the RT instance in a VMWare
server pointing the database to our departmental MySQL server.
I’m looking xen instead of VMWare server because it might allow for
quicker disaster recovery.
Either way I figure we’d be covered by a once a day snapshot of the
virtual machine and we can use our current database backup schemes so
nothing new would have to be done for RT on the db server.
We make snapshots everyday of the complete VM but might switch to a
dedicated database server VM with multiple RT VM’s pointing to it and
then the backup of the RT VM’s will probably change to once a week or
only when
upgrading RT or one of its components because I don’t mind loosing
things like rt session info.
How do you all handle backups/DR? Is anyone else running RT in a
virtual machine?
We use a live replication system to keep the DB up-to-the-second on
another DB server. If the main DB dies, we just “failover” and point
RT at the backup. We also take nightly snapshots of the database on
yet another machine dedicated to that purpose on our network. Once
per month, a set of snapshots is archived off to DVD and tossed into
a safe. That pretty much covers our DB back up for RT…
As for system backup, the only thing we backup of our RT installation
is the etc/RT*Config.pm files and httpd+mailserver config files. To
recover the RT installation, just re-install the software and copy
those handful of configs files back in place. I suppose having a
snapshot of the VM would be faster to recover
Our primary RT instance runs on a dedicated Dell 1950 with a hardware-
mirrored drive and a local Postgres database. The replica runs on a
dedicated ‘backup’ db server which also backs up several other
databases.
