How to share data between servers

2006-06-28 Thread VenuGopal Papasani
Hi all, I have got two servers.Let it be server1 and server2 now i have an application one on server1 which gets the data everymonth and stores in the database and now the problem is the application in server2 also need the data to be accessed but data is entered only once in server1

Re: How to share data between servers

2006-06-28 Thread Gabriel PREDA
1. One-Way-Replication: server2 gets data from server1, if server2 does not write in the database... if it writes: 1.a 2-Way-Replication: server2 gets data from server1 AND server1 gets data from server2... :) ... 2. FEDERATED Storage Engine: the actual data is stored on server1, the tables