List:General Discussion« Previous MessageNext Message »
From:Warren Young Date:August 4 2010 6:50pm
Subject:Re: Moving from one MySQL server to three MySQL servers?
View as plain text  
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.
Thread
Moving from one MySQL server to three MySQL servers?Nunzio Daveri4 Aug
  • Re: Moving from one MySQL server to three MySQL servers?Warren Young4 Aug
  • Re: Moving from one MySQL server to three MySQL servers?Wm Mussatto4 Aug
    • Re: Moving from one MySQL server to three MySQL servers?Prabhat Kumar4 Aug
      • Re: Moving from one MySQL server to three MySQL servers?Andrés Tello5 Aug
  • Re: Moving from one MySQL server to three MySQL servers?Joerg Bruehe5 Aug
  • RE: Moving from one MySQL server to three MySQL servers?Steven Staples5 Aug
    • Re: Moving from one MySQL server to three MySQL servers?Nunzio Daveri5 Aug
      • Re: Moving from one MySQL server to three MySQL servers?Andrés Tello6 Aug
      • Re: Moving from one MySQL server to three MySQL servers?Warren Young9 Aug
      • Re: Moving from one MySQL server to three MySQL servers?Todd Lyons18 Aug