hey yall . am currently having some issues with my mysql server. I keep getting some extremely high System Load averages on my server and apparently it's caused by mysql. so i would like to take the mysql database of that server and host it from my home pc . is this at all possible
I am sure it's possible, however, you may not gain anything. The database server needs to be connected directly to the web server through a second nic card. Having it go through the internet to your slower home connection, will make your web server constantly wait for information, and if your sites are busy, will start to overload it. Have you done some MySQL tuning and tweaking?
Thanks for the reply. Yes i did try tweaking mysql a bit but it didn't seem to make a difference. am not sure if may have done it the right way
Yes you could. You would have many more problems than you are experiencing now if you try to host a database remotely. What are you using the database for? Also, what sort of traffic are database usage are you experiencing? Many times it comes down to needing better hardware to host on.
It's a bit of an assumption to say it would be bad for him to do, unless you know the workloads. My website runs on three servers and two of them are in my home. If you're hitting the database very often for low-load queries it would be of little use to host it elsewhere as the overhead of making the connection will generally outweigh any query gains. For my setup the webserver hosts the db that runs the shopping cart system. That's basically a lot of light work with the need for quick connections. However, the page content goes to my home servers which do the heavy lifting. The webserver simply couldn't handle the requirements of even a few queries for page content, so the half second or so it takes to make the connection is of little consequence. You couldn't tell it's happening. If your home computer out classes the web server by at least a second per query it may be worth looking into.
Based on the specific statement that he is having problem with high server load for the mysql server, offloading it would be disastrous. I do agree that low latency queries could be doable over the internet, but if he's experiencing usage problems locally, putting it on a remote server isn't going to fix anything. We run some very light remote db usage, and quite a bit remotely using the federated storage engine. In any case, there is noticeable speed degradation when compared to hosting locally or on an adjacent server connected with a 10/1000 or better connection. The thing that would concern me about hosting anything out of a home, is that there is no bandwidth guarantee, and ISP's routinely throttle or block bandwidth over specific ports, especially outgoing traffic. If your web app / site is used for money or anything that could be harmed by unavailability, I would steer far clear of hosting anything at home.
Off course possible to host a database from a home pc, but that something I would do if I have great internet connection, static ip, and some software to make my pc perform as server. But still I won't do that since I can host my database on other hosting company or even moving my site to other hosting company. Or the easy part is to upgrade your hosting plan, since higher plan deserved better server resources, bandwidth and space.
If you're hosting a db I would suggest using dyndns or something for your ip and I would suggest using mysql as opposed to mssql. It requires less as oppossed to an odbc database. Either way it's not all that recommended unless you got a fast inet connection because no matter how optimized your db is ur connection makes the difference.