Database server in different continent?
Posted by UberTricep, 10-27-2012, 08:23 AM Hello, Is it wise to have a web server hosted in Europe, and a database server hosted in North America, with about one page view per second, each page view about 20 queries? Has anyone tested this? Thanks
Posted by zoid, 10-27-2012, 08:39 AM Generally I would not recommend it. Why would you consider it?
Posted by DevMonkey, 10-27-2012, 10:14 AM The only thing I can think of would be distributing web servers so that people connect to the closest server and hence have a 'faster' experience. Problem is, the delayed database connection will probably outweigh that. Especially considering any delay is usually caused by downloading assets (image, css, javascript etc) which can be thrown on a CDN. Not recommended at all unless you have a very good, perhaps special, reason!
Posted by NetworkPanda, 10-27-2012, 10:21 AM The database server should be in the same local area network/datacenter with the web server. Having a database server in different continent would need several seconds for the execution of each query and would consume lots of public bandwidth. Not recommended at all.
Posted by Mambug, 10-29-2012, 11:39 AM 20 queries, per page view? Talk about poor programming. Yikes! I'd say the best solution would be to house your database server within the same network as your web server. This way, regardless of the number of queries that you're running per page view, the speed delivery will be unaffected. Housing the db server in a different location will cause an additional delay to each query, and running a large number of queries like that, will certainly impact your website speeds.
Posted by concerto49, 10-29-2012, 11:01 PM As others have said, the database should be near the web server. The only reason to do so is if it's a real-time replica of an existing database. There isn't any point. The latency will be very high and you might have connection issues.
Posted by alyak, 10-30-2012, 03:01 PM calling to oversea server for database query is very poor idea . you need REPLICATION , looks ion mysql doc . then each server will call to read to nearest database , but update need at single , there is other types of databases where allowed to sync by update on both servers .
Posted by BCata, 10-30-2012, 07:26 PM Depends really on his application. It is a lot for a static content site, but a forum will easily go over 20 queries per page on most pages.
Posted by Mambug, 10-30-2012, 07:27 PM As someone who regularly deals with both programming and database administration (and has developed a forum software before), I could easily argue that point. Then again, I'm very strict on my requirements for data access.
Posted by BCata, 10-30-2012, 07:57 PM Can you please argue it in a PM (so we do not hijack the thread). I am curious how you keep a forum page under 20 queries assuming you have internationalized content, 20 posts per page, stats logging. Take this standard WHT page.
Posted by Mambug, 10-30-2012, 08:43 PM Well, I sent ya' a PM.