On Fri, May 04, 2007 at 06:15:36PM +0200, Luca Villani wrote: > Alle 17:30, venerd? 4 maggio 2007, Kenneth Marshall ha scritto: > > > > I know that this does not help your situation, but pgpool will allow > > you to perform select queries to a slave postgresql DB and updates to > > the master DB. There may be a similar proxy available for MySQL that > > would allow you to scale your DB load better. > > Generally speaking, we prefer to put no wrapper/proxy on our architecture, > due > to high load of our systems. > > Do you have a link for a mysql proxy acting like this? > > Since RT uses DBI to access the underlying database, you should be able to use DBIx::DBCluster to send your writes to the master DB and read from the slave(s).
Ken > > -- > Luca Villani Mobile Team, Dada S.p.A. > Tel: +39 055 2267220 Mob: +39 335 8753086 > ICQ: 76272621 Skype: luca.villani > GPG key fingerprint: 7FC9 E2FE 0BEE 9DF8 1719 8761 1B79 82CC F0B5 B7CF > _______________________________________________ > 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 > _______________________________________________ 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