US 11,030,220 B2 · Global table management operations for multi-region replicated tables

Abstract

Systems and methods are disclosed to implement, in a database system, global table management operations for global tables or objects that are replicated across multiple locations. In embodiments, for a regional replica of a global table, a requested change to a metadata property of the replica (e.g., an attribute data type, a write throughput limit, or a time-to-live setting) is propagated to other replicas of the global table at other locations. In embodiments, before performing the requested management operation, the database system may first verify that the operation can be successfully performed in all locations. In embodiments, the operation may be performed optimistically without verification, and rolled back if it cannot be performed everywhere. In embodiments, to serialize management operations on a global table, the database system may check for other pending management operations via a shared control object, and proceed when any pending operations are finished.

Claims20

Dependent claims

A system, comprising:

one or more hardware processors with associated memory that implement a database system, configured to:
receive, from a client device, a request to perform a management operation on a database object at a first location;
determine that the database object is one replica in a group of replicas maintained as part of a global object, wherein individual ones of the replicas are located at different locations, and changes in one replica of the global object are transmitted to one or more other ones of the different locations and replicated across all replicas of the global object;
determine that the management operation specifies a modification to a metadata property of the database object that is to be kept consistent across all replicas of the global object;
send the management operation from the first location to one or more other ones of the different locations to perform the management operation on one or more other replicas of the global object;
perform the management operation on the database object at the first location;
and
acknowledge that the management operation has been performed on the global object.

5 more elements

One or more non-transitory computer-accessible storage media storing program instructions that when executed on or across one or more processors of a database system, cause the database system to:

receive, from a client device, a request to perform a management operation on a database object at a first location;
determine that the database object is one replica in a group of replicas maintained as part of a global object, wherein individual ones of the replicas are located at different locations;
determine that the management operation specifies a modification to a metadata property of the database object that is to be kept consistent across all replicas of the global object;
send the management operation from the first location to one or more other ones of the different locations to perform the management operation on one or more other replicas of the global object;
perform the management operation on the database object at the first location;
and
acknowledge that the management operation has been performed on the global object.

4 more elements

Dependencies are inferred from the claim text.

Global table management operations for multi-region replicated tables

Life of this patent

Global table management operations for multi-region replicated tables

Life of this patent

Abstract

Claims20