Failover and resume when using ordered sequences in a multi-instance database environment
US9910893B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Dec 1, 2011 |
| Grant date | Mar 6, 2018 |
| Priority date | — |
| Expiry date | Aug 30, 2032 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/24552
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
An approach is disclosed for implementing failover and resume when using ordered sequences in a multi-instance database environment. The approach commences by instantiating a first database instance initially to serve as an active instance, then instantiating a second database instance to serve as an instance of one or more passive instances. The active database establishes mastership over a sequence and then processes requests for the ‘next’ symbol by accessing a shared sequence cache only after accessing a first instance semaphore. The active instance and the passive instance perform a protocol such that upon passive database detection of a failure of the active database, one of the passive database instances takes over mastership of the sequence cache, and then proceeds to satisfy sequence value requests. The particular order is observed in spite of the failure.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.