Hi,
(Now subscribed from my personal address)
We're looking to scale our RT instance at $work, and make it more
fault tolerant at the same time. The obvious first step is to split
the DB out from the Mason servers (currently all on one box). At the
same time, we want to use mysql replication to get the data onto a
second DB server. In a perfect world we would have RT transparently be
able to do SELECTs on both DB boxes while sending UPDATE/INSERT
statements to the master DB.
I know I'm not the first person to attempt this. :-) Any pointers to
DBI multiplexers, tips, etc would be most appreciated.
Thanks,
Drew
--
----------------------------------------------------------------
Drew Taylor * Web development & consulting
Email: [EMAIL PROTECTED] * Site implementation & hosting
Web : www.drewtaylor.com * perl/mod_perl/DBI/mysql/postgres
----------------------------------------------------------------
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com