Re: [rt-users] MySQL Scaling for a large instance

2012-03-16 Thread reg.bestpractical
David, > Do you know of any successful MySQL proxy implentations with RT ? You should not really use any MySQL replication-based solution for database load distribution unless application was designed with that in mind or at least adjusted to work in such architecture. This is even more true fo

Re: [rt-users] MySQL Scaling for a large instance

2012-03-16 Thread David Moreau Simard
Hi ! Do you know of any successful MySQL proxy implentations with RT ? It is indeed one of the solutions we had been thinking of but it does not have a release deemed "stable" at this time, still in beta. Thanks, -- *David Moreau Simard* /Spécialiste TI // IT Specialist/

Re: [rt-users] MySQL Scaling for a large instance

2012-03-13 Thread Ruslan Zakirov
On Tue, Mar 13, 2012 at 20:56, David Moreau Simard wrote: > Hi, > > Our RT instance is rather large (> 5 million tickets) and I wondered if any > users have had to deal with a RT database this size and if so, how they > scaled their infrastructure as a result. > > Right now, the web portion is hos

Re: [rt-users] MySQL Scaling for a large instance

2012-03-13 Thread k...@rice.edu
Hi David, Our instance is not large, but have you tried profiling the load on the database to find out where your resource shortages are located? This will help you target the changes needed to improve the performance of the backend. As Ronald mentions, the first step would be to use partitioning

Re: [rt-users] MySQL Scaling for a large instance

2012-03-13 Thread ronald higgins
hi David. Our instance of RT is around 3.5 million records and the mySQL db about 470GB in size. the biggest performance gain I've got was through partitioning and indexing, i'm very keen to see where this thread goes for "bigger" deployments as i'm also concerned about that breaking point. regar

[rt-users] MySQL Scaling for a large instance

2012-03-13 Thread David Moreau Simard
Hi, Our RT instance is rather large (> 5 million tickets) and I wondered if any users have had to deal with a RT database this size and if so, how they scaled their infrastructure as a result. Right now, the web portion is hosted on a cluster and really, this part doesn't worry me at all. I