[rt-users] 2 RT instances pointing to a single database instance

[Bob Goldstein]

>Hi,
>
>Lots of great stuff on this list and the wiki about multiple instances 
>pointing to different database instances (rt_math, rt_english). However, 
>I interested to know if anyone has set up multiple instances pointing to 
>the same db instance?

   I have.  I might have a production 3.4.2 instance, and a test 3.6.1 instance.
   (Sometimes this is ok if the database schema is the same, otherwise not.)
   Makes it easy to try out 3.6.1 in a real situation, without requiring
   eveyone to upgrade at the same time.

   Anyway, your scenario is exactly what I planned on, if I need
   extra performance.  I don't think there would be a locking issue,
   since you'd have the same issue between multiple fcgi processes
   on the "same" RT instance.

      bobg


>
>Why?
>
>Out support office in the UK is seeing very slow response times, we'd 
>like to try hosting an instance in the UK, which connects to the same 
>database that the instance here in California uses. Hopefully, serving 
>the pages locally will improve page load speed.
>
>My biggest concern is around database locking -- does RT 3.2.1 do 
>database level locking or application level locking. Not worth 
>corrupting my database!
>
>thanks,
>
>Chris
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Community help: http://wiki.bestpractical.com
>Commercial support: sales at bestpractical.com
>
>
>Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>Buy a copy at http://rtbook.bestpractical.com
>