Providing services across systems that manage distributed replicas

摘要

Techniques are provided to allow users to define a global service that is offered across multiple replicated databases. Database clients connect to and use a global service just as they do with regular services on a single database today. Upon receiving a connection request, a collection of components, referred to collectively as the Global Data Service framework (GDS framework), automatically chooses the best database server instances to which to connect a client. Once those connections have been established, the clients determine which database server instance, of those database server instances to which they are connected, to send requests to based, at least in part, on advisory messages sent to the clients by the GDS framework.

主权项

1. A method comprising:
receiving a connection request from a client that requires access to a data set stored in a distributed replication environment; wherein the distributed replication environment includes a plurality of database systems, each of which maintains a separate copy of the data set to which the client requires access; wherein each of the plurality of database systems includes one or more database server instances; in response to the connection request, performing the steps of:
selecting at least one database server instance, from among a set of database server instances that includes at least one database server instance from each of the plurality of database systems, based on one or more selection criteria;wherein every database server instance in the set of database server instances has access to a copy of the data set to which the client requires access; andfacilitating establishment of one or more connections between the client and the at least one database server instance; wherein the method is performed by one or more computing devices.