[rt-users] migrating database

[ronald higgins]

Thanks very much for the info all.

On Wed, Jun 9, 2010 at 2:52 PM, Emmanuel Lacour <elacour at easter-eggs.com> wrote:
> On Wed, Jun 09, 2010 at 02:37:59PM +0200, ronald higgins wrote:
>> Hi All,
>>
>> We're currently running RT 3.8.0 plugging into MySQL 5.0 (local)
>> running on Centos 5.4.
>> Due to performance issues i am looking at partitioning the Attachments
>> & Tickets tables
>> to try and squeeze out some performance. However, MySQL 5.1 isnt
>> available via Centos 5.4.
>>
>> So my solution is too build a seperate VM, build MySQL 5.1 from source
>> on this new server,
>> and then point the WebRT Application to the new remote MySQL Server.
>>
>> Where in RT do i change the MySQL database location from localhost to
>> remote host ?
>>
>
> Look at $DatabaseHost in etc/RT_Config.pm and override it in
> RT_SiteConfig.pm.
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>