[rt-users] RT and mysql replication

[Kenneth Marshall]

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.

Ken

On Fri, May 04, 2007 at 05:10:56PM +0200, Ham MI-ID, Torsten Brumm wrote:
> Hi,
> Just to pick up this discussion, this palnned scenario would be very, very clever, should be added to the rt4 wish list.
> 
> Torsten.
> 
> Btw: on on mysql cluster won't help if you have on on very big environment, the replica architecture would be the best way i think.
> 
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com <rt-users-bounces at lists.bestpractical.com>
> To: rt-users at lists.bestpractical.com <rt-users at lists.bestpractical.com>
> Sent: Fri May 04 16:27:05 2007
> Subject: Re: [rt-users] RT and mysql replication
> 
> Alle 15:39, venerd?? 4 maggio 2007, Bob Goldstein ha scritto:
> 
> 
> >   I don't believe this is an RT question.  Mysql supports replication,
> >   for sure at 4.x, and supports clusters at 5.x.
> 
> As far as in a replication cluster scenario applications must perform insert 
> and updates only onto the master db server and can perform select onto an 
> arbitrary slave server of the cluster, this will be an RT question: code must 
> be patched to follow this behaviour.
> 
> 
> >   Do the needful at the mysql level, RT doesn't care.
> 
> RT doesn't care because it use only one cluster server: the master server.
> 
> We're using RT in an heavy duty environment (about 1500/1600 tickets per day), 
> with about 90 different CRM operators, and using a single mysql server is not 
> a good deal: if RT can split searches onto some slaves db servers (4/5 slave 
> server) it can improve all operativeness.
> 
> 
> 
> -- 
> 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

> _______________________________________________
> 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