Oracle International Corporation

Patricia H McElroy

Lik Wong

Nimar Singh Arora

Alan Robert Downing

Anand Lakshminath

Ramkumar Venkatesan

Lei Gao

Byron Wang

Jun Yuan

Splitting and merging database object information sharing streams. Streams are also referred to herein as 'propagations'. Splitting and merging information sharing streams can be used to improve performance in a information sharing environment when a failed or slow DBS impacts the performance. In one embodiment, an auto split process monitors the progress of applying changes at each node and detects the presence of a failed or a slow node. Once the failed or slow node is identified, the auto split process splits the propagation such that the offending node is sent through a separate propagation. Furthermore, an auto merge process can be started to monitor the newly created separate propagation. At a later point, the new propagation can be merged back into the original stream. For example, if the offending node catches up with other nodes, the auto merge process merges the newly created propagation back to the original propagation.

Reconfiguring propagation streams in distributed information sharing

Configuring an n-way multi-master information sharing topology. Adding a new node (e.g., database server) to the information sharing topology can be implemented as follows. Initially, the new node is added as a slave of a particular co-master in the information sharing topology. The objects to replicate are instantiated on the new node by propagating data from the particular co-master to the new node. Furthermore, a capture process is created on the particular co-master to send changes to the objects to the slave. Meanwhile, the co-masters continue to propagate changes to each other. To promote the slave to a master, changes to objects stored at the slave are propagated to each of the co-masters. Furthermore, changes at each of the masters are propagated to the promoted node.

Configuring or reconfiguring a multi-master information sharing environment

Growing community of inventors

Santa Clara, CA, United States of America

Patricia H McElroy