Web Hosting Talk : Web Hosting Main Forums : VPS Hosting : Load Balancing 2 VPS

[dewaforex]

Hi everybody,

I just tried load balancing wordpress site between 2 VPS, A at US and B at EU.
I use simple DNS round-robin.
File is synchronized using rsync and database using mysql replication.
The master is VPS A, the problem is now how to redirect if user try to post comment at VPS B to VPS A because database master is at VPS A. So, if user post comment at VPS B, the comment will not show up at VPS A.
I'm using nginx, php-fpm and mysql.

I'm new at mysql replication

[dewaforex]

Just found the article exactly is same with my configuration.
Hope will help anyone with same configuration

Using plugin HyperDB to write the master database.
I will try it and report again

Link for article http://2012.birmingham.wordcamp.org/.../#comment-2717

But, it's seem only for Wordpress site just like me..
Maybe someone will add other way beside for Wordpress latter.

[Cirtex]

Thanks for sharing! DNS round-robin can definitely work but is not the perfect solution, however definitely a good way to start

[dewaforex]

yes, DNS round-robin is cheap way for clustering
I use anycast DNS in my case.

Can't find any cheap service for DNS global traffic director except geoscaling.com, but haven't yet test it as still confuse with making the PHP script for this purpose at geoscaling