RE: [rt-users] Splitting queries across mysql servers

2006-09-07 Thread Parish, Brent
ored on one server and they get load balanced onto another one. Not even sure if RT works like that, but it was easy enough to set up as a "just in case". - Brent -Original Message- From: Roy El-Hames [mailto:[EMAIL PROTECTED] Sent: Thursday, September 07, 2006 5:03 AM To: Parish, B

RE: [rt-users] Splitting queries across mysql servers

2006-09-07 Thread Parish, Brent
ember 07, 2006 5:03 AM To: Parish, Brent Cc: Drew Taylor; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Splitting queries across mysql servers This sounds good How many web interfaces (rt instances) are you running, how did you set up $DatabaseHost in the RT config?? Roy Parish, Brent wr

Re: [rt-users] Splitting queries across mysql servers

2006-09-07 Thread Roy El-Hames
r 05, 2006 5:24 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Splitting queries across mysql servers Hi, (Now subscribed from my personal address) We're looking to scale our RT instance at $work, and make it more fault tolerant at the same time. The obvious first step is to s

RE: [rt-users] Splitting queries across mysql servers

2006-09-06 Thread Parish, Brent
TH - Brent Parish -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Taylor Sent: Tuesday, September 05, 2006 5:24 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Splitting queries across mysql servers Hi, (Now subscribed from my personal addre

[rt-users] Splitting queries across mysql servers

2006-09-05 Thread Drew Taylor
Hi, (Now subscribed from my personal address) We're looking to scale our RT instance at $work, and make it more fault tolerant at the same time. The obvious first step is to split the DB out from the Mason servers (currently all on one box). At the same time, we want to use mysql replication to g