Discovery and Client Routing to Database Nodes
AssigneeMicrosoft Corporation
InventorsRaghu Ram, Rohan Samuel Lam, Chadwin J. Mumford, Peter Gvozdjak, David W. Olix, Matthew A. Neerincx, Junfeng Dong
Life of this patent
Estimating the term…
Abstract
Aspects of the subject matter described herein relate to database access. In aspects, a request for access to a database is received at a node of a database cluster. Also received at the node is an intent associated with the request. If the intent is to potentially write to the database, a primary instance of the database services the request. If the intent is to read from but not write to the database, an identifier of a secondary instance of the database is sent to the requestor for use in accessing the database.
Claims20
A method implemented at least in part by a computer, the method comprising:
- from a requestor, receiving a request for access to a database, the database being accessible via a primary instance and one or more secondary instances;
- receiving an intent associated with the access, the intent indicating whether the requestor seeks to potentially write to the database;
- based on the intent, determining whether the primary instance or one of the one or more secondary instances are to provide the access to the database in response to the request;
- if the intent indicates that the requestor seeks to potentially write to the database, providing access to the database via the primary instance;
- and
- if the intent indicates that the requestor does not seek to potentially write to the database, sending an identifier of a secondary instance via which the requestor is allowed to access the database.
A computer storage medium having computer-executable instructions, which when executed perform actions, comprising:
- sending, from a requestor, a request for access to a database, the database being accessible via a primary instance and one or more secondary instances;
- sending an intent associated with the access, the intent indicating whether the requestor seeks to potentially write to the database;
- if the intent indicates that the requestor seeks to potentially write to the database, receiving access to the database via the primary instance;
- and
- if the intent indicates that the requestor does not seek to potentially write to the database, receiving an identifier of a secondary instance via which the requestor is allowed to access the database.
In a computing environment, an apparatus, comprising:
- a connection manager operable to establish, maintain, and terminate connections with requestors involved with a database, the database being accessible via a primary instance and one or more secondary instances, and
- a connection director operable to receive a request for access to the database, the request originating from a requestor, the connection director further operable to receive an intent associated with the access, the intent indicating whether the requestor seeks to potentially write to the database, the connection director further operable determine an instance to service the request based on the intent and, if the instance is one of the secondary instances, to send the requestor an identifier of the secondary instance in response to the request.
Dependencies are inferred from the claim text.