Using RT with replicated databases

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