<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>AW: Re: [Rt-devel] Migrating RT 3.4 from MySQL to Oracle</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi jeff,<BR>
<BR>
We have no plan about the migration to oracle yet but for your mysql problems it could be a good way to not dump the whole db, dump each table instead step by step this helps us in our environment (90 gb db) during last dump.<BR>
<BR>
For your query problem i think you will also have the same problems under oracle like mysql, context searches are killing our system too (64 proc pseries) so a clever way of handling this kind of searches would be great. I remember a mail from jesse some months ago about the way the searchbuilder is doing this and if i'm right he searches the whole db and doing the restrictions later, the way around would be better i think, search only inside all the ticket/attachment where a user has the rights to, this is from my point of view much faster?!?<BR>
<BR>
Ps: if you have success with your oracle migration pls let me know, we have planned this for next year....<BR>
<BR>
Torsten<BR>
<BR>
-----Original Message-----<BR>
From: rt-devel-bounces@lists.bestpractical.com <rt-devel-bounces@lists.bestpractical.com><BR>
To: Jesse Vincent <jesse@bestpractical.com><BR>
CC: RT-Developer Mailinglist <rt-devel@lists.fsck.com><BR>
Sent: Wed Aug 08 18:27:07 2007<BR>
Subject: Re: [Rt-devel] Migrating RT 3.4 from MySQL to Oracle<BR>
<BR>
Hi Jesse,<BR>
No, we haven't brought these issues to the mailing list; performance<BR>
isn't actually that bad for most basic queries, which are of course<BR>
already index supported, but occasionally we'll get a few people all<BR>
doing big "show me all tickets where content matches x" searches and<BR>
performance will suffer for everyone; we've had some issues with MySQL's<BR>
InnoDB ibdata files getting really gigantic and sometimes preventing a<BR>
restart of MySQL; and, as you say, if we moved in an Oracle direction<BR>
we'd have the support of a team of DBAs to assist with these sorts of<BR>
issues.<BR>
<BR>
One of the biggest problems we've had, actually, and the one that's<BR>
pushing us in the direction of Oracle, has been a problem with running<BR>
out of memory during mysqldumps, which we use as part of our backup<BR>
process for MySQL databases. Research hasn't turned up much: we're<BR>
already using the --quick flag that's often recommended to solve this<BR>
issue, with no success. If you or the fine readers of this list had any<BR>
suggestions on this one, I'd be very grateful.<BR>
<BR>
At any rate, I am still interested in migrating to Oracle, as it's a<BR>
well supported environment here, so I'll restate my original questions:<BR>
have people made the MySQL to Oracle move? How was it accomplished?<BR>
<BR>
Cheers,<BR>
Jeff Albert<BR>
<BR>
Jesse Vincent wrote:<BR>
><BR>
> On Aug 7, 2007, at 4:57 PM, Jeff Albert wrote:<BR>
><BR>
>> Hello all,<BR>
>> Owing to performance issues with RT on MySQL, we're looking at moving<BR>
>> to RT on Oracle; unfortunately, the documentation on this migration<BR>
>> process on the wiki is somewhat lacking<BR>
>> (<A HREF="http://wiki.bestpractical.com/view/MySQLToOracle">http://wiki.bestpractical.com/view/MySQLToOracle</A>). Have folks here<BR>
>> performed this migration with success? How did you go about it?<BR>
><BR>
> [I know this isn't exactly an answer to your question]<BR>
><BR>
> Are these all performance issues you've raised on the mailing lists?<BR>
> We've seen RT on MySQL scale to well over 10,000 tickets/day. But<BR>
> you're definitely going to have to tune and index. (Of course, you might<BR>
> be able to push that to a DBA team if you're switching to Oracle ;)<BR>
><BR>
> -jesse<BR>
><BR>
><BR>
>> Cheers,<BR>
>> Jeff Albert<BR>
>> _______________________________________________<BR>
>> List info:<BR>
>> <A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel</A><BR>
>><BR>
><BR>
_______________________________________________<BR>
List info: <A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel</A><BR>
</FONT>
</P>
</BODY>
</HTML>