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

[Jeff Albert]

Hi Jesse,
No, we haven't brought these issues to the mailing list; performance 
isn't actually that bad for most basic queries, which are of course 
already index supported, but occasionally we'll get a few people all 
doing big "show me all tickets where content matches x" searches and 
performance will suffer for everyone; we've had some issues with MySQL's 
InnoDB ibdata files getting really gigantic and sometimes preventing a 
restart of MySQL; and, as you say, if we moved in an Oracle direction 
we'd have the support of a team of DBAs to assist with these sorts of 
issues.

One of the biggest problems we've had, actually, and the one that's 
pushing us in the direction of Oracle, has been a problem with running 
out of memory during mysqldumps, which we use as part of our backup 
process for MySQL databases. Research hasn't turned up much: we're 
already using the --quick flag that's often recommended to solve this 
issue, with no success. If you or the fine readers of this list had any 
suggestions on this one, I'd be very grateful.

At any rate, I am still interested in migrating to Oracle, as it's a 
well supported environment here, so I'll restate my original questions: 
have people made the MySQL to Oracle move? How was it accomplished?

Cheers,
Jeff Albert

Jesse Vincent wrote:
> 
> On Aug 7, 2007, at 4:57 PM, 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?
> 
> [I know this isn't exactly an answer to your question]
> 
> Are these all performance issues you've raised on the mailing lists? 
> We've seen RT on MySQL scale to well over 10,000 tickets/day.  But 
> you're definitely going to have to tune and index. (Of course, you might 
> be able to push that to a DBA team if you're switching to Oracle ;)
> 
> -jesse
> 
> 
>> Cheers,
>> Jeff Albert
>> _______________________________________________
>> List info: 
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>>
>