[Ilugc] Setting up mirror server and database server in Sync

  • From: nmsksathish@xxxxxxxxx (Sathish M Kumar)
  • Date: Thu, 17 Nov 2011 13:18:19 +0530

Application in on PHP,  Database server is mysql and also postgresql for
another kind of application.

So MySql and Postgresql.

Regards ,
Sathish.M Kumar




On Thu, Nov 17, 2011 at 1:13 PM, Sudharshan S <sudharsh at gmail.com> wrote:

On Thu, Nov 17, 2011 at 1:02 PM, Sathish M Kumar <nmsksathish at gmail.com>
wrote:
All database operations will be done at both server. So that i need to
set-up both databases always in synchronize with each other.

Look up on Database Replication[1].
And what Database are you running? If its postgres check out

http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling

[1]:
http://en.wikipedia.org/wiki/Replication_(computer_science)#Database_replication

--
Sudharshan S
http://sudharsh.wordpress.com
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc


Other related posts: