Microsoft Technology Licensing, LLC

Amazon Technologies, Inc.

Tony Petrossian

James Christopher Sorenson

Istvan Cseri

Lev Novik

Akshat Vig

Jason Duane Clark

Somasundaram Perianayagam

Ajay Kalhan

Tomas Talius

Marc Todd Friedman

Andrew Eyring Kimball

Alexander Richard Keyes

Santeri Olavi Voutilainen

Joachim Hammer

Cihangir Biyikoglu

Stefano Stefani

Amit Gupta

Vaibhav Jain

Alexander Evgenievich Nosov

Sameer Arun Verkhedkar

Oren Yossef

Rishabh Jain

Richard Shawn Bice

Arijit Choudhury

Nathan Pellegrom Riley

Mark Roper

Akanksha Fouzdar

Joon Ahn

A distributed database maintains a table on a first plurality of partitions. A request to restore the table to a point-in-time is received. The database determines, based on log data of the partitions, a maximum version number of an operation processed by the partitions. The log data is processed to exclude, from the restoration, operations whose transactions were started after the point-in-time, by setting the version number of those operations to be greater than the maximum version number. The log data is then applied to a second plurality of partitions, where the version number of each applied operation is less than or equal to the determined maximum version number.

Transactionally consistent point-in-time restore

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.

Global table management operations for multi-region replicated tables

Semi-automatic failover includes automatic failover by a service provider as well as self-serviced failover by a service consumer. A signal can be afforded by a service provider based on analysis of an incident that affects the service provider. Initiation of self-serviced failover by a service consumer can be predicated on the signal. In one instance, the signal provides information that aids a decision of whether or not to failover. In another instance, the signal can grant or deny permission to perform a self-serviced failover.

Semi-automatic failover

Methods, systems, and computer program products are provided for partitioning online databases. Online database operations, such as, for example, SPLIT, MERGE, and DROP, are used to alter the arrangement of partitions in a federated database. A SPLIT operation splits rows at one partition across a plurality of other partitions. A MERGE operation merges rows at a plurality of partitions in to one partition. A DROP operation shifts responsibility for rows of data from one partition to another partition and then drops the rows from the one partition.

Partitioning online databases

The present invention extends to methods, systems, and computer program products for partitioning online databases. Online database operations, such as, for example, SPLIT, MERGE, and DROP, are used to alter the arrangement of partitions in a federated database. A SPLIT operation splits rows at one partition across a plurality of other partitions. A MERGE operation merges rows at a plurality of partitions in to one partition. A DROP operation shifts responsibility for rows of data from one partition to another partition and then drops the rows from the one partition.

Growing community of inventors

Bellevue, WA, United States of America

Tony Petrossian