[rt-users] data replication RT server to RT server

[Parish, Brent]

If using MySQL you can do circular replication, I was keeping a “live” backup of our database for disaster recovery/failover using Tungsten.
But the point Ken made about database differences between versions is a HUGE thing to consider!!!

I run all RT upgrades in a test environment before moving to prod.
I got really tired of flattening and rebuilding test by hand so I hacked together this:  http://parishnetworks.blogspot.com/2014/10/a-script-to-flatten-rt-devtest-and.html

It’s pretty ugly so I wouldn’t use it as-is, but it may serve as a starting point for you.


-          Brent



From: rt-users [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Boris Epstein
Sent: Friday, April 08, 2016 3:02 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] data replication RT server to RT server

Hello listmates,

Here is what I have in mind.

Let us say I have a production RT instance. Let us call it rt_prod. Let us also say I want to run a staging instance on which I would be testing new versions, extensions, etc. Let us call is rt_stag.

Is there a way to synchronize the to with regard to actual ticket data - i.e., make it so that once any modification is made on the production one (rt_prod), for instance, the same is reflected on staging (rt_stag). I may even want to do it both ways.

Any way to do something like this - or am I just dreaming?

Thanks.

Boris.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20160408/6d35e3cd/attachment.htm>