[rt-users] RT on database in read-only mode?

[Philip Kime]

Running mysql 5 under RT with a master/slave configuration and I would
like to be able to make one of the slaved read-only. This is impossible
using RT rights because that means altering the database on the slave
which eventually (or quickly ...) breaks mysql replication because of
duplicate IDs in the RT transaction table. Starting Mysql on the slave
"read-only" would be nicer but RT won't start at all in this case
because it complains about not being able to write session data. It
mentioned /usr/local/rt/var/session_data. Is there any way to force RT
to use the filesystem locations for session data etc. so that the DB can
be completely read-only?
 
PK
 
--
Philip Kime
NOPS Systems Architect
310 401 0407
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20061219/0ddd4ae4/attachment.htm>