This is possibly more of a feature request, but its more to see what
people make of it.
My current setup has two SQL servers (SQL-1 and SQL-2) which ‘know’ about
the RT2 database due to the nifty MySQL replication feature.
Currently, RT only knows about one of them (SQL-1) in its config file, and
directs all queries and updates to this one server.
What I’d like to do is to designate one server (SQL-2) as the query
server, adn have all updates go to the other one (SQL-1). Is this
possible, or a ‘good’ thing to do?
Bruce Campbell RIPE
NCC
Operations