Re: Load overshooting ONE server

[Quoted] On 06/09/16 07:24, bit-naughty_at_hotmail.com wrote:
> If you have a website whose main job is to put in and retrieve from a
> MySQL DB, and the load of the site overshoots 1 server, what do you
> do, exactly? If you add *webservers* for the site, and load blance
> between them, that doesn't solve the problem, because the load on the
> MySQL server will remain the same. Do you have to add *another MySQL
> sserver*, and then copy the entire database over from the existing
> server to the new one, and load balance between THOSE 2? How is this
> done? And then, how do you do it so that an INSERT into the db
> INSERTs into BOTH those servers? And if more servers are added later,
> then those, and so on....?
>
>
>
> Thanks.
>

1/. Increase the power of the server. More CPU, More RAM, SSD if its I/O bound.

2/. Rewrite the code so the load is off the server and into the application(s).

3/. Use a proper database like Oracle, and pay for it.

-- 
Religion is regarded by the common people as true, by the wise as
foolish, and by the rulers as useful.

(Seneca the Younger, 65 AD)