Re: Load overshooting ONE server

On Mon, 5 Sep 2016 23:24:19 -0700 (PDT), 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....?

I entered that exact question into a search engine and got some pretty decent hits.

E.g. :

<https://www.ixquick.com/do/dsearch?query=If+you+have+a+website+whose+main+job+is+to+put+in+and+retrieve+from+a+MySQL+DB%2C+and+the+load+of+the+site+overshoots+1+server%2C+what+do+you+do%2C+exactly%3F+If+you+add+*webservers*+for+the+site%2C+and+load+blance+between+them%2C+that+doesn%27t+solve+the+problem%2C+becau&cat=web&pl=opensearch&language=english>

-- 
Kees Nuyt