I want to host my site on three servers which includes 1 sql server and 2 other servers for hosting CMS files. Now the problem is how to sync the files b/w second and third server? In this whole setup, the third server will be the main server. The site is vbulletin forum.
1 domain on 1 SQL server and 2 hosting servers
- Thread starter damnyou
- Start date
- Status
11 comments
You only need to do this if you're getting serious amounts of traffic. A well configured server can easily handle over 100,000 visitors per day.
But in case you wanted to know, here is what you would do. In reality you would want to purchase all three servers from the same datacenter, to reduce latency and bandwidth usage.
Setup one server to handle mysql and make sure it can accept connections from ip addresses other than localhost.
Setup the other two servers to handle http connections. The issue is that really, you need a further server in order to load balance between the two http servers. That being said, you could just as well set one of them as the load balancer and then have it distribute traffic between its own web server running on localhost and the other web server you have.
If this is sounding a bit complicated to you, don't do it!
But in case you wanted to know, here is what you would do. In reality you would want to purchase all three servers from the same datacenter, to reduce latency and bandwidth usage.
Setup one server to handle mysql and make sure it can accept connections from ip addresses other than localhost.
Setup the other two servers to handle http connections. The issue is that really, you need a further server in order to load balance between the two http servers. That being said, you could just as well set one of them as the load balancer and then have it distribute traffic between its own web server running on localhost and the other web server you have.
If this is sounding a bit complicated to you, don't do it!
Well thats not a problem as I want to host my msql on the separate server. I am talking about syncing the dynamic CMS files b/w the two servers located on the separate data centers. The thing here I want to achieve is that the second server will act as a backup server in case of the main server's downtime.
BTW will it effect the speed if I host the sql database on the USA server and my main host in Lithuania connected to that sql server?
Indeed ya it sounds bit complicated. I don't want to setup the load balancer here. I just want to setup the backup server in case of main servers downtime. Is there any solution to sync the CMS files b/w two servers located in the separate datacenters. As I already posted above, my three servers are located in the separate datacenters with 1st as a main server located in the Lithuania, 2nd as secondary server located in the USA and the 3rd server which is dedicated to the sql database is also located in the USA. In my current setup the First two server will be connected to the third server i.e., sql server via config.php. The ips of the first two servers will be added to the DNS.
Last edited:
cyber.crime
Active Member
you must allowed remote msql database to other server
at MSQL have feature about remote database you must put what ip can do remote the database
at MSQL have feature about remote database you must put what ip can do remote the database
Waz-Warez has over 1.5million requests yesterday
1 Big server with the services split over drives
Are your server on the same datacenter ?
I am looking for syncing the CMS files b/w my main and slave server.
- Status