web hosting, sql and home server question

[Glitch]

WIll this work

If I were to get web hosting were they host my domain "web site" and sql files.... but I have the server at my home or does the server have to run on the same machine or with in the same network the sql database is.?

[Chasle]

Well technically oyu could have your mysql server on a different server/lan connection; but I would really discourage you for using this way as lags will be terrible. I would highly recommend to put it all on the same server. Also depending on your load, you might want to consider the type of connection you have to the internet (speed download and upload).

[arrestedgames]

I run this way.

 

I have a EC2 instance running the web frontend to my user signup, etc.

An EC2 instance running the world/auth servers

RDS Aurora running the DB

 

This works really well.. no latency..

If you plan to run a dev box, having everything in one place is certainly the way to go.. if you plan to run "production" / customer facing, I would not recommend putting it all in one place.

[zzbrandon]

I would recommend either cloud hosting or getting a Linux or Windows VPS to host your server on. You are going to want to have everything either on the same box or the same lan and chances are your home internet unless it is a business internet connection is not going to do the trick. Currently I am using a windows VPS because some web development I am doing is in ASP.NET and C# instead of PHP.