Re: [rt-users] What kind of hardware setup are you using?
On Dec 5, 2006, at 5:24 PM, John Arends wrote: 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. smime.p7s Description: S/MIME cryptographic signature ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] What kind of hardware setup are you using?
Hello John, 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. Joop ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] What kind of hardware setup are you using?
John Arends wrote: 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. ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] What kind of hardware setup are you using?
John Arends wrote: 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 www.up-south.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] What kind of hardware setup are you using?
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? ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com