Re: Moving from one MySQL server to three MySQL servers?

[Warren Young]

On 8/4/2010 12:40 PM, Nunzio Daveri wrote:
> it pretty much came down to it's knees within two hours of
> running tests.

Can you clarify what happened in those 2 hours, exactly?

If you mean it took 2 hours of running a single test for performance to 
collapse, I'm not sure this means anything.  2 hours of continuous 
pounding may not be representative of how your application will actually 
be used.  If there will be lulls and your test doesn't include lulls to 
give the system time to do periodic cleanups that let it withstand the 
next round of pounding, all you're testing here is what will happen when 
someone tries to DoS the system.

If instead you mean it took you 2 hours of trying before you found a 
test that would kill the box, what was the test, and is it 
representative of actual load conditions?  Again, if not, all you've 
done is found a DoS test case, not something that requires 
rearchitecting everything.