METHODS AND APPARATUS FOR TRANSPARENT DATABASE SWITCHING USING MASTER-REPLICA HIGH AVAILABILITY SETUP IN RELATIONAL DATABASES

• US 20180157560A1
• Filed: 12/02/2016
• Published: 06/07/2018
• Est. Priority Date: 12/02/2016
• Status: Active Grant

• Current Assignee: Vmware LLC (Broadcom, Inc.)
• Original Assignee: VMware, Inc. (Broadcom, Inc.)
• Inventors: Gochkov, Gospodin, Mitevski, Miroslav, Kovacheva, Diana, Petkov, Ivo, Ivanov, Zahari
• Granted Patent: US 10,776,385 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/2028 eliminating a faulty processor or activating a spare
• CPC Class Codes: G06F 11/2041 with more than one idle spare processing component
• CPC Class Codes: G06F 11/2048 where the redundant components share neither address space nor persistent storage
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/815 Virtual middleware or OS functionality using virtual machines to implement generic software techniques for error detection or fault masking G06F11/1484

Abstract

Methods, apparatus, and systems to perform transparent database switching using master-replica high availability setup in relational databases are disclosed. An example system includes a first virtual appliance including a first proxy and a master database, the first proxy to forward service traffic to the master database, the master database to read and/or write data based on the service traffic; a second virtual appliance including a second proxy and a first replica database, the second proxy to determine data stored in the master database, the first replica database to replicate the master database; and a third virtual appliance including a third proxy and a second replica database, the third proxy to, in response to determining the master database of the first virtual appliance is to power down, promote the second replica database to the master database.

Claims

1. A system for performing transparent database switching using master-replica high availability setup in relational databases in a virtual machine environment, the system comprising:

a first virtual appliance including a first proxy and a master database, the first proxy to forward service traffic to the master database, the master database to at least one of read data or write data based on the service traffic;

a second virtual appliance including a second proxy and a first replica database, the second proxy to determine data stored in the master database, the first replica database to replicate the master database; and

a third virtual appliance including a third proxy and a second replica database, the third proxy to, in response to the master database of the first virtual appliance powering down, promote the second replica database to the master database.

2. The system of claim 1, wherein the master database of the first virtual appliance powers down during at least one of failover or maintenance.

3. The system of claim 1, wherein the second virtual appliance includes a service provider, wherein the second proxy is to, when the second replica database is promoted to the master database, instruct the service provider to disable write transactions until the second replica database completes the promotion.

4. The system of claim 1, wherein the third proxy is to instruct the master database of the first virtual appliance to reset in replica mode when the master database of the first virtual appliance powers up.

5. The system of claim 1, wherein, after the master database of the first virtual appliance powers up, the master database of the first virtual appliance maintains master mode and the second replica database returns to replica mode.

6. The system of claim 1, wherein an order of promotion is stored in a component registry of a service provider in at least one of the first virtual appliance, the second virtual appliance, or the third virtual appliance.

7. The system of claim 6, wherein the service provider is to generate the service traffic, the service traffic including at least one of a read transaction or a write transaction corresponding to the master database.

8. The system of claim 1, wherein the third proxy is to inform the second proxy of the promotion of the second replica database of the third virtual appliance to the master database of the third virtual appliance.

9. The system of claim 8, wherein the second proxy is to reconfigure the first replica database based on the master database of the third virtual appliance.

10. The system of claim 1, wherein the master database of the first virtual appliance is to power down after the promotion of the second replica database of the third virtual appliance to the master database of the third virtual appliance.

11. A method for performing transparent database switching using master-replica high availability setup in relational databases in a virtual machine environment, the method comprising:

forwarding, using a first proxy, service traffic to a master database of a first virtual appliance, the master database to at least one of read data or write data based on the service traffic;

replicating, using a second proxy, data stored in the master database at a first replica database of a second virtual appliance; and

in response to the master database powering down, promoting, using a third proxy, a second replica database of a third virtual appliance to the master database.

12. The method of claim 11, further including powering down the master database of the first virtual appliance during at least one of failover or maintenance.

13. The method of claim 11, further including, when the second replica database is promoted to the master database, instructing a service provider to disable write transactions until the second replica database completes the promotion.

14. The method of claim 11, further including instructing the master database of the first virtual appliance to reset in replica mode when the master database of the first virtual appliance powers up.

15. The method of claim 11, further including, after the master database of the first virtual appliance powers up, maintaining master mode in the master database of the first virtual appliance maintains master mode and returning the second replica database to replica mode.

16. The method of claim 11, further including storing an order of promotion in a component registry of a service provider in at least one of the first virtual appliance, the second virtual appliance, or the third virtual appliance.

17. The method of claim 16, further including generating the service traffic, the service traffic including at least one of a read transaction or a write transaction corresponding to the master database.

18. The method of claim 11, further including informing the second proxy of the promotion of the second replica database of the third virtual appliance to the master database of the third virtual appliance.

19. The method of claim 18, further including reconfiguring the first replica database based on the master database of the third virtual appliance.

20. The method of claim 11, further including powering down the master database of the first virtual appliance after the promotion of the second replica database of the third virtual appliance to the master database of the third virtual appliance.

21. A computer readable storage medium comprising instructions which, when executed causes a machine to at least:

forward service traffic to a master database of a first virtual appliance, the master database to at least one of read data or write data based on the service traffic;

replicate data stored in the master database at a first replica database of a second virtual appliance;

in response to powering down of the master database, promote a second replica database of a third virtual appliance to the master database.

22. The computer readable medium of claim 21, wherein the instructions cause the machine to power down the master database of the first virtual appliance during at least one of failover or maintenance.

23. The computer readable medium of claim 21, wherein the instructions cause the machine to, when the second replica database is promoted to the master database, instruct a service provider to disable write transactions until the second replica database completes the promotion.

24. The computer readable medium of claim 21, wherein the instructions cause the machine to instruct the master database of the first virtual appliance to reset in replica mode when the master database of the first virtual appliance powers up.

25. The computer readable medium of claim 21, wherein the instructions cause the machine to, after the master database of the first virtual appliance powers up, maintain master mode in the master database of the first virtual appliance maintains master mode and return the second replica database to replica mode.

26. The computer readable medium of claim 21, wherein the instructions cause the machine to store an order of promotion in a component registry of a service provider in at least one of the first virtual appliance, the second virtual appliance, or the third virtual appliance.

27. The computer readable medium of claim 26, wherein the instructions cause the machine to generate the service traffic, the service traffic including at least one of a read transaction or a write transaction corresponding to the master database.

28. The computer readable medium of claim 21, wherein the instructions cause the machine to inform a second proxy of the promotion of the second replica database of the third virtual appliance to the master database of the third virtual appliance.

29. The computer readable medium of claim 28, wherein the instructions cause the machine to reconfigure the first replica database based on the master database of the third virtual appliance.

30. The computer readable medium of claim 21, wherein the instructions cause the machine to power down the master database of the first virtual appliance after the promotion of the second replica database of the third virtual appliance to the master database of the third virtual appliance.