how to run 2 sites with the same db?
hi guys,I have one domain: domain.com with 2 subdomains a.domain.com, b.domain.com
I upload my site into 2 different hosts A, B.
and point a.domain.com -> A, b.domain.com -> B
what I want is that whenever people surf my site domain.com.
I will check their IP and auto redirect them to correct hosts.
for ex: 1.1.1.1 -> domain.com -> a.domain.com,
2.2.2.2 -> domain.com -> b.domain.com
-------------
So, in this case, what is the solution for my db?
( I want whenever db in one host changes, other db will be changed automatically, so even people access to different hosts (A,B) they also see the same content. )
-------------
Appreciate all your comments and suggestions