How to host one Wordpress site on two locations?

Terrance · Sep 1, 2016

This is just my idea to help my wordpress site uptime 100% when one of locations goes offline. It is possible to achieve that, for example the site loads from location A if the location B goes offline it will use the location A is online. For the database, when I add a new post it gets added on both servers.

VirtuBox · Sep 1, 2016

In a first time you can create a database replication, to have two databases running with the same data. ->
https://www.howtoforge.com/tutorial/replicating-a-master-database-using-mariadb-10/
But to have a website running in complete replication, you have to use a load-balancing, to handle and route the traffic in the two servers, and to redirect to only one in case of failure. it require 2 IP and another server to be the router with a proxy like squid or varnish.

That's pretty hard to setup. My advice will be : try to optimize your server to handle traffic (nginx, php7, mariadb, redis etc ...) and you should not have more than 5 minutes of downtime per year.

KevinHV · Sep 17, 2016

Hello

You must have 2 shared hosting account or VPS with shell access. So that you can use rsync data from Server A to B . You can also set interval time between two servers. After that specific time, your data will be copied to other server. By this way you can keep data of same website on 2 locations.

UWH-David · Oct 5, 2016

You can do this many different ways. You can round robin via DNS, failover via DNS or setup load balancing. A quick and easy way to set this is up via nginx and its load balancer /upstream option or Apache mod_proxy_balancer.

hynds · Oct 5, 2016

I think the easiest way is using sync service between your 2 locations. This way will keep your source and database in 2 locations. However you only have 1 domain pointing to 1 location, so that you need also to config it automatically points to the 2nd location if the 1st is down. I think this is a hard process to do, and you need research carefully before taking action.
Good luck to you,

UWH-David · Oct 5, 2016

Agreed. In our experience creating a cron for rsync along with utilizing Tungsten replicator for mySQL as it has a better system for error checking and timeouts was the easiest and most reliable to accomplish this when using round-robin or load-balancing. Tungsten is very versatile with other database systems as well and is up to version 4.0. Here is some great documentation on the method:
www.percona.com/blog/2015/05/04/keep-your-mysql-data-in-sync-when-using-tungsten-replicator/
code.google.com/archive/p/tungsten-replicator/

hynds said:
I think the easiest way is using sync service between your 2 locations. This way will keep your source and database in 2 locations. However you only have 1 domain pointing to 1 location, so that you need also to config it automatically points to the 2nd location if the 1st is down. I think this is a hard process to do, and you need research carefully before taking action.
Good luck to you,

webhoster · Oct 6, 2016

Terrance said:
This is just my idea to help my wordpress site uptime 100% when one of locations goes offline. It is possible to achieve that, for example the site loads from location A if the location B goes offline it will use the location A is online. For the database, when I add a new post it gets added on both servers.

Hi Terrance,

You can use Cloudflare, it caches your website pages and keeps it on globally distributed network of servers. When your site goes offline, it shows pages from cache on its server.

When a visitor visits your website in browser, it will show your website pages from nearest cloudflare server, this makes your website faster.

If you keep your website on many servers you will have to manage updates in all pages and database on all servers. With cloudflare, you don't need to manage each and every copy of your website.

How to host one Wordpress site on two locations?

Terrance

Member

VirtuBox

Well-known member

KevinHV

Member

UWH-David

Member

hynds

Well-known member

UWH-David

Member

webhoster

New member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud