Amazon Technologies, Inc.

Maxym Kharchenko

Jason Curtis Jenks

Weinan Wang

Min Zhu

Joseph Elmar Magerramov

Bruce Ferry

Aaron D Kujat

Zhiyu Zhang

Aaron Drew Alexander Kujat

Aravanan Sivaloganathan

Alessandro Gherardi

Balakrishnan Narayanaswamy

Jeremiah Wilton

Vijay Gopal Joshi

Zhao Song

Joshua Tobey Oberwetter

Kyle Henderson Hailey

Vikramank Yogendra Singh

An anomalous period of operation of a database management system is detected by analyzing a time series of data points indicating the number of database queries pending processing by the system. Conditions associated with execution of the pending database queries are recorded and analyzed to identify conditions correlated with the anomalous period of operation. A recommendation for tuning the database is generated based on analysis of the conditions.

Assisted database anomaly mitigation

Disclosed are various embodiments for increasing distributed database capacity by adding new nodes while minimizing downtime. A database is partitioned among multiple nodes in a cluster. Each node stores a respective portion of the database. The portions of the database are replicated to corresponding physical standbys. For each portion, a first portion is mapped to an existing node, while a remaining portion is mapped to a physical standby. The cluster is updated to include the physical standbys as additional nodes among which the database is partitioned.

Increasing distributed database capacity

Disclosed are various embodiments for facilitating data redistribution in database sharding. A database is maintained that is horizontally partitioned into a set of first buckets using modulo-based assignments. A fixed number of the first buckets are stored in each of multiple physical data stores. The database is repartitioned into a set of second buckets using modulo-based assignments. The number of second buckets in the set is a multiple of the sum of a positive integer and the quantity of the physical data stores. The data in the database is unmoved between the physical data stores by repartitioning.

Facilitating data redistribution in database sharding

Growing community of inventors

Bellevue, WA, United States of America

Maxym Kharchenko