Hot answers tagged connection
When you're using "localhost" notation in fact MySQL uses UNIX domain sockets. They're more performant, comparing to TCP/IP, and for high-load it can make noticeable difference. But UNIX domain is local to the host by its nature, it's not networking, so this implies you can't use remote MySQL server with it.
THe connect with multiple 10g connections. OBVIOUS, is it not? A plan which I am not aware of? I am quite sure you are totally unaware of what is there outside what is offered to smaller customers ;)
It's very hard to make anything out of your question. I decided that your question is Will a remote database at my provider that I can access via mysql.example.com be slower then a local database that I run on my machine/VPS and that I can access via localhost. The answer is: It depends on many things, among them The specs of your own server/VPS ...
It's not entirely clear to me what you're asking, but I get the impression you're talking about a web server like Apache or nginx running on the same leased server as your MySql database in a hosting provider's data center. You're worried about the connection from the web server to the database, and the only difference between the two choices is what name ...
They use a dedicated database server because it's easier to manage. Having dedicated database servers and web servers makes it easier to update, easier to backup, etc. If you have everything for a single customer on a single server you have to run updates and backups on every single instance. By separating them you can have as much customers on a given ...
Only top voted, non community-wiki answers of a minimum length are eligible