[rt-users] RT and mysql replication

[Kenneth Marshall]

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: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>