[DERBY-2872] Add Replication functionality to Derby

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.1.3
• Fix Version/s: 10.4.1.3
• Component/s: Replication
• Assignee: Jorgen Loland
• Reporter: Jorgen Loland
• Created: 26/Jun/07 09:55
• Updated: 02/May/13 02:29
• Resolved: 28/Apr/08 06:42

Description

It would be nice to have replication functionality to Derby; many potential Derby users seem to want this. The attached functional specification lists some initial thoughts for how this feature may work.

Dag Wanvik had a look at this functionality some months ago. He wrote a proof of concept patch that enables replication by copying (using file system copy) and redoing the existing Derby transaction log to the slave (unfortunately, I can not find the mail thread now).

DERBY-2852 contains a patch that enables replication by sending dedicated logical log records to the slave through a network connection and redoing these.

Replication has been requested and discussed previously in multiple threads, including these:

http://mail-archives.apache.org/mod_mbox/db-derby-user/200504.mbox/[e-mail]%3e
http://www.nabble.com/Does-Derby-support-Transaction-Logging---t2626667.html

Issue Links

• incorporates: DERBY-2922 Replication: Add master replication mode
• incorporates: DERBY-2978 Replication: Add slave replication mode
• incorporates: DERBY-3169 Add documentation for replication
• is depended upon by: DERBY-3161 Test the Derby Replication functionality introduced in DERBY-2872
• is related to: DERBY-2852 Derby: Replication and Availability

Sub-Tasks

• Replication: Add a network service that connects the master and slave Derby instances: Closed
• Add commands to NetworkServerControl for interacting with the replication functionality: Closed
• Replication: Add connection url command options for starting and stopping master: Closed
• Replication: Add connection url command options for starting, stopping slave and for failover: Closed
• Replication: Add functionality to send various commands from master to slave using the replication network connection: Closed
• Implement the replication stop functionality: Closed
• Implement the replication failover functionality: Closed