[Ilugc] Setting up mirror server and database server in Sync
- From: girishvenkatachalam@xxxxxxxxx (Girish Venkatachalam)
- Date: Thu, 17 Nov 2011 13:45:16 +0530
On Thu, Nov 17, 2011 at 1:02 PM, Sathish M Kumar <nmsksathish at gmail.com>
wrote:
I would like to know about setting-up mirror server and database server in
sync mode.
Fine.
we have one server at one Geo-location and we need to set-up another server
at another Geo-location on different network.
Fine.
Same application will be running in both server, and separate Database
server running on each on various host ip.
Various host ip? What is meant by that?
All database operations will be done at both server. So that i need to
set-up both databases always in synchronize with each other.
It would be grateful if anyone give idea or suggestion on doing the same.
Typically directory syncs are done every 5 minutes or so.
If you are talking about a database then syncs are done much quicker.
But all that is only when you have a colocated setup. That is not the
case for you.
You can use VPN to connect the two locations, use something like IPsec
or even SSLVPN.
Then you can synchronize the database using the hints given in other posts.
If nothing works you can use rsync between them.
Basic flow is this:
1) setup a cron job to invoke the sync operation every n seconds
2) sync both ways(no master/slave relationship), the cron job is run
at every location
3) Make sure the DBs are not written to when the sync is
happening.Lock the DB whilst performing
the sync
-Girish
--
G3 Tech
Networking appliance company
web:
http://g3tech.in ?mail: girish at g3tech.in
Other related posts: