Grid based replication

摘要

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.

主权项

1. A method for replication in a grid based environment, comprising:
creating, using a processor of a computer, a grid command structure; and at an authorized node in a grid of nodes,
inserting a Data Definition Language (DDL) operation into the grid command structure;in response to determining that the DDL operation is for creating a table and that auto-registration is enabled for the table, posting a create replicate grid message in the grid command structure with a replicate name to be created, a database, an owner, and the table;activating full row logging for the table; andpropagating the DDL operation 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.