Results 1 to 11 of 11
-
10-27-2012, 08:23 AM #1WHT Addict
- Join Date
- Mar 2012
- Posts
- 121
Database server in different continent?
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
-
10-27-2012, 08:39 AM #2Web Hosting Master
- Join Date
- Aug 2001
- Posts
- 5,597
Generally I would not recommend it. Why would you consider it?
-
10-27-2012, 10:14 AM #3Web Hosting Master
- Join Date
- Jun 2006
- Posts
- 1,112
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!
-
10-27-2012, 10:21 AM #4Web Hosting Master
- Join Date
- Oct 2012
- Location
- Europe and USA
- Posts
- 991
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.★ NetworkPanda :: Web Hosting SSD Powered :: Reseller Hosting
★ Instant activation, fast servers, NVMe SSD disks, cPanel, Softaculous 1-click apps installer, daily backups
★ Multiple hosting locations: USA, Canada, France, UK, Germany, Italy, Spain, Poland, Finland
-
10-29-2012, 11:39 AM #5Web Hosting Guru
- Join Date
- May 2005
- Location
- California
- Posts
- 278
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.██ Jordan G.
██ Mambug Studios
██ Hosting, Designing, Scripting
██ We specialize in designing, coding, deploying and maintaining businesses online since 2005.
-
10-29-2012, 11:01 PM #6Web Hosting Master
- Join Date
- Aug 2012
- Posts
- 1,280
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.Hyperconnezion - your fast path to success
IT management, Cloud and Data Center Services in Asia Pacific
-
10-30-2012, 03:01 PM #7WHT Addict
- Join Date
- Jan 2004
- Posts
- 117
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 .<< Please review signature guidelines >>
-
10-30-2012, 07:26 PM #8Premium Member
- Join Date
- Mar 2005
- Posts
- 333
-
10-30-2012, 07:27 PM #9Web Hosting Guru
- Join Date
- May 2005
- Location
- California
- Posts
- 278
██ Jordan G.
██ Mambug Studios
██ Hosting, Designing, Scripting
██ We specialize in designing, coding, deploying and maintaining businesses online since 2005.
-
10-30-2012, 07:57 PM #10Premium Member
- Join Date
- Mar 2005
- Posts
- 333
-
10-30-2012, 08:43 PM #11Web Hosting Guru
- Join Date
- May 2005
- Location
- California
- Posts
- 278
██ Jordan G.
██ Mambug Studios
██ Hosting, Designing, Scripting
██ We specialize in designing, coding, deploying and maintaining businesses online since 2005.
Similar Threads
-
Multiple site in different continent!!
By aabinitio in forum Running a Web Hosting BusinessReplies: 8Last Post: 01-07-2010, 01:27 AM -
Looking for multi-continent dedi
By SmilieBG in forum Dedicated ServerReplies: 7Last Post: 04-07-2006, 10:35 AM -
vps from UK cross continent
By chueewowee in forum VPS HostingReplies: 5Last Post: 06-14-2005, 05:52 AM -
What continent are you in?
By Bakie in forum Web Hosting LoungeReplies: 47Last Post: 05-30-2005, 08:04 AM -
Which Continent...
By Amish_Geek in forum Web Hosting LoungeReplies: 20Last Post: 09-18-2004, 05:42 PM