Amazon Technologies, Inc.

Alok Nandan Nikhil

Saileshwar Krishnamurthy

Alexandre Olegovich Verbitski

Kamal Kant Gupta

Tengiz Kharatishvili

Anurag Windlass Gupta

Sandor Loren Maurice

Alexey Kuznetsov

Lawrence Douglas Webley

Bohan Liu

Debanjan Saha

Mushahid Alam

Yuhui Yuan

Yoni Shalom

Jagdeep Singh Sidhu

Siyuan Xing

Yibo Zhu

Nicholas Piers O'Shea

Hongbo Song

Stefano Stefani

Gopi K Attaluri

Joseph Andrew Tucek

Niket Goel

Ian Kosseff

Proxy-based scaling may be performed for databases. A proxy may be implemented for a database that can establish a connection between the proxy and a database engine to perform a database queries received from a client at the proxy. A scaling event may be detected for the database responsive to which the proxy may establish a connection with a new database engine which may, in some embodiments, have different capabilities or resources that address the features or criteria that triggered the scaling event. Session state may be copied from the database engine to the new database engine so that the new database engine may be able to provide access to the database on behalf of requests received from the client through the proxy.

Proxy-based database scaling

Techniques for a context preservation during server restart are described. A restart of a database server having at least one open communications session with a database client is initiated. The database server can be executed by a compute instance hosted by a computer system of a provider network. A restarted database server is launched. The restarted database server obtains session state data to resume the at least one open communications session with the database client, the session state data including one or more session variables. The restarted database server receives a transaction from the database client.

Context preservation during server restart

A service provider network implements seamless scaling via proxy replay of session state. Upon a trigger, such as a determination to scale a server, a scaled server may be spun up and an identifier of the scaled server provided to a first (existing) server. The first server sends the identification of the second server, and session state information for each of the connections between the first server and the request router, to the request router. For each of the connections, the request router establishes a new connection between the request router and the second (scaled) server, and replays the session state information for the connection to the second server. The request router then routes traffic between each existing client connection (e.g., the same existing client connection which carried traffic delivered to the first server) and the corresponding new connection to the second server.

Seamless scaling via proxy replay of session state

Systems, methods, and computer-readable media are disclosed for an improved database. The systems, methods, and computer-readable media described herein may enhance the response time of databases and improve user experiences. In an example method described herein, a database may receive a search request for data stored in the database. The database may be stored in association with a b-tree to facilitate searching and retrieving data from the database. The method may include allocating a portion of a first memory for read ahead operations and performing the read ahead operations, wherein the read ahead operations comprise loading, into the portion of the first memory, data associated with one or more siblings of a current node, wherein the one or more siblings of the current node are one or more nodes that have a same number of parent nodes as the current node.

Methods and systems for an improved database

A dynamic proxy may be implemented for a database that can establish a connection between the proxy and a database engine to perform a database queries received from a client at the proxy. The proxy may receive a connection request (and later database queries) through a first network endpoint from a client. The proxy can then determine based on the source of the connection request a second network endpoint through which to access the database (e.g., the endpoint of the database engine). Once the proxy establishes a connection with the database engine through the second network endpoint, the proxy can request the performance of queries at the database engine instead of the client.

Dynamic proxy for databases

A system for updating a database instance with a patch or new binary image. A database instance includes a database engine and a client-side storage layer driver to manage database state information and volume geometry state information associated with client process connections to a volume of a storage layer of a database system during the patching process. The database engine and the client-side storage service driver save database state information and volume geometry state information, execute the new binary image, and restore the updated database engine with the database state information and volume geometry state information. The new binary image may be executed using a fork/exec model, wherein file descriptors used to identify sockets used in existing client connections are preserved, enabling restoration of the client connections without interruption or downtime.

Downtime management during database instance patching

Growing community of inventors

Seattle, WA, United States of America

Alok Nandan Nikhil