Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.

Abstract: Techniques are provided for resynchronizing instances of a replicated table. In one embodiment, a database server is provided as a member of a plurality of communicatively coupled database servers. Each database server is configured to support a replicating mode of operation and a non-replicating mode of operation. The instances of the replicated table are resynchronized responsive to a user request, without stopping any of the plurality of database servers and without requiring any of the plurality of database servers to operate in the non-replicating mode of operation.

Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.

Abstract: A method and system for providing convergence of data copies in asynchronous data replication in a database system, includes: labeling rows, a copy of identification and propagation controls. In applying communicated changes, conflicting changes are identified and resolved. In this manner, convergence of data copies in asynchronous data replication is provided, and processing and storage costs are significantly reduced.

Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.

Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.

Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.

Abstract: Techniques are disclosed for adding a key column to a table to be replicated, where the key column stores key values for use in replication. In one embodiment, a request is received to add a table to a replication domain, such that the table is replicated from a first database server to at least a second database server. Key values are generated for both existing records and new records subsequently requested to be inserted into the table, respectively. Each generated key value is unique across the replication domain. Further, the key column may be added to the table without requiring exclusive access to the table.

Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.

Abstract: Provided are techniques for replication in a grid based environment. Grid control structures, including a grid command structure, are created. At an authorized node in a grid of nodes, a Data Definition Language (DDL) operation is received, the DDL operation is inserted into the grid command structure, and the DDL operation is propagated from the authorized node to one or more other nodes in the grid of nodes at the end of a transaction that inserted the DDL operation into the grid command structure.