[Rt-devel] Migrating RT 3.4 from MySQL to Oracle

[Jeff Albert]

Hi Andrew,
We don't have any particular reason to believe that Oracle would 
intrinsically provide better performance; however, we do have a team of 
DBAs to assist with Oracle. I am also looking at Postgres as an 
alternative, since we have a fairly deep pool of experience there. I'm 
curious about what changes you needed to make to achieve performance 
gains; mostly an issue of refining indexes, or was there more to it than 
that?

Cheers,
Jeff Albert

Andrew Sullivan wrote:
> Do you have any reason at all to believe it will get better on
> Oracle?  RT was originally designed for MySQL.  We moved to
> PostgreSQL, at which we are experts, and things took a nosedive until
> we did a lot of work with the database.  I suspect Oracle will be a
> similar story.
> 
> A
> 
> On Tue, Aug 07, 2007 at 01:57:45PM -0700, Jeff Albert wrote:
>> Hello all,
>> Owing to performance issues with RT on MySQL, we're looking at moving to 
>> RT on Oracle; unfortunately, the documentation on this migration process 
>> on the wiki is somewhat lacking 
>> (http://wiki.bestpractical.com/view/MySQLToOracle). Have folks here 
>> performed this migration with success? How did you go about it?
>>
>> Cheers,
>> Jeff Albert
>> _______________________________________________
>> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>