From: | sandeep kumar <s_kumar66(at)yahoo(dot)com> |
---|---|
To: | ABBAS SHAKEEL <shakeel(dot)abbas(dot)qau(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Syncronizing Databases at different Remote Location |
Date: | 2009-11-04 11:03:17 |
Message-ID: | 632933.22746.qm@web30705.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Shakeel, this can be done using symmetricDS.
cheers
//Sandeep
--- On Wed, 4/11/09, ABBAS SHAKEEL <shakeel(dot)abbas(dot)qau(at)gmail(dot)com> wrote:
> From: ABBAS SHAKEEL <shakeel(dot)abbas(dot)qau(at)gmail(dot)com>
> Subject: [ADMIN] Syncronizing Databases at different Remote Location
> To: pgsql-admin(at)postgresql(dot)org
> Date: Wednesday, 4 November, 2009, 3:48 PM
> HelloI am new in the field of Database
> Management. Most of times i worked with Software development
> and Database Design.I need some advice regarding
> database management.
> I have three Database (DB) servers at different
> locations. suppose A, B and C as three servers. where as Z
> is a central server which have VPN to all other
> servers.
>
> I have to insert/update records to central
> server Z if there is any insert/update in any of the A,B and
> C server.
> Now I can write a JAVA code that when ever there
> is insertion/updation of record of A/B/C do same in central
> Server Z using JAVA sockets I can send records to central
> server where Socket server will listen and then insert or
> update records in DB.
>
> But I come to know that there is a concept
> called Replication. I studied it and found that
> it is used for load balancing. I dont need load balancing
> I only need to Syncronize only Two tables of all A,B,C
> servers to central server Z.
>
>
> Please suggest how to move forward.(Open source
> solutions )
>
> --
> Best Regards
> Shakeel Abbas
>
>
>
>
From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew
From | Date | Subject | |
---|---|---|---|
Next Message | ABBAS SHAKEEL | 2009-11-04 11:18:15 | Re: Syncronizing Databases at different Remote Location |
Previous Message | ABBAS SHAKEEL | 2009-11-04 10:18:37 | Syncronizing Databases at different Remote Location |