Re: Replication Question

>Yes there a some people using ER.... > >The default collision resolution is timestamp. Which ever row has the later >time stamp would >win. However you can define a hybrid conflict resolution using stored >procedures. > >If each site only operates on its own set of rows, then the instances of >collisions should be >quite small, and therefore ER a good solution. My concern would be running >this over a dial-up..... > >Jon > One of the features of 7.3 is sporadic connections (mobil). What this does is to create a "store forward" queue for a target. When the targets wants to connect/replicate it would issue a "cdr connect" command. This would cause the transfer of the data within the store forward queue. Also data from the sporadic connection is transfered to the non-sporadic server. This allows the ACKs to the source to be done without having to be done on the source machine. Once the transmission is done, a "cdr disconnect" command can be issued to terminate the transfer of data. This allows the "replay" phase of ER to be done outside of the data transfer. This approach is designed to support replication over PPP as well as non-PPP TCP/IP connections. For instance a cron job could be set up to do the dial/PPP-connect/CDR-connect/CDR-disconnect/hangup. Madison Pruet