I had an idea to cluster RT, using postgres to synchronize the different
The only issue I have, is if the DB’s stop talking to eachother, then
there would be a problem with the ticket sequencing. (you would get
duplicate tickets for the same id).
I’ve tried to look around for something like modifying the ticket id. I
know it’s numeric only, but haven’t found much to do something like have
one server do odd numbers, the other even or some such…
Any ideas of a way to do this, or is it simply not possible at this
Also, any other reasons or possible problems anyone could see with this?
My secondary step, is just to run 1 instance, but use the postgres
replication and probably rsync for a hot standby.