Welcome to Server Circle. It's a friendly site and all levels of experience are welcome. Be aware that we use cookies for your login.
Server Circle - Ask questions about Servers and get answers from experts.
Beta (0.50 sec)
Is it realistic to run a database server remotely from a web server ?

Will I get massive slowdowns on my site if I try and use a database server in Amazon's EC2 and a web server somewhere else ?

Any experience of how to speed up the remote connection ?

Thanks.
Asked by:
TomPating
1355 points
 Report Abuse
 Share Page - Category: Cloud Servers - Tags: Is it realistic to run a database server remotely from a web server ?
 Enter your response
Please use Pastie.org to paste lengthy code or to fix formatting issues with code
  • Responses in reverse (1)

Best Answer

It's possible for sure, but do remember that the further away the MySQL bit of the server is from your web server, the slower the connection is likely to be. If the two are in different data centres then you're adding even more slowdown.

Speeding up the above setup with Amazon - best way I think would be using something like memcached to cache the MySQL queries on the web server where possible, and if possible use other web server caching too especially if the pages aren't changing on a regular basis.

Do prepare for slowdowns with this however, possibly much larger than running MySQL and Apache on the same busy server.

Response by:
trevHCS
640 points


  • Related Questions
About Us : Contact Us : Etiquette : Terms : CDN Failover : ShorterURL : CDN Fallback : © 2013 Server Circle