I was just seeking some higher advice on whether or not having your main data on one database, then having separate server database to use for frequent updating and reading will prove to be an optimization or a failure. My logic was that sharing the load like this across 2 separate server databases will be quicker than packing it all in on one shared hosting Thanks for your time.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Yes, you can and should use multiple servers if you have a high load in your mysql.
you need to see what solution works to you: