Operating a data center

Patent metadata

Field	Value
Publication number	US-11874751-B2
Application number	US-202117546870-A
Country	US
Kind code	B2
Filing date	Dec 9, 2021
Priority date	Dec 9, 2021
Publication date	Jan 16, 2024
Grant date	Jan 16, 2024

Abstract

In an approach, a primary data center is provided including primary source and primary target database systems, where a function is activated causing the primary target database system to: include a copy of data and receive analysis queries from the primary source database system; and execute the analysis queries on data. A processor, in response to detecting a failure in the primary source database system: offloads queries intended for the primary source database system to a secondary source database system of a secondary data center also including a secondary target database system and a copy of data, where the function is deactivated. A processor, responsive to the primary target database system being available: receives analysis queries, processed by the secondary source database system, of the offloaded queries; and copies data to the secondary target database system. A processor causes the function to be activated in the secondary data center.

First claim

What is claimed is:

1. A computer-implemented method comprising:
providing a primary data center, the primary data center comprising a primary source database system and a primary target database system, wherein a function is activated in the primary data center causing the primary target database system to:
comprise a copy of data of the primary source database system;
receive analysis queries from the primary source database system; and
execute the analysis queries on the data; and

in response to detecting a failure in the primary source database system:
offloading queries intended for the primary source database system to a secondary source database system, the secondary source database system of a secondary data center further comprising a secondary target database system, the secondary source database system comprising a copy of the data, wherein the function is deactivated in the secondary data center;
responsive to the primary target database system being available:
receiving, by the primary target database system, analysis queries, processed by the secondary source database system, of the offloaded queries; and
copying, by the primary target database system, the data to the secondary target database system; and

causing the function to be activated in the secondary data center.

2. The computer-implemented method of claim 1 , further comprising setting the primary target database system to a read only mode before executing the analysis queries at the primary target database system.

3. The computer-implemented method of claim 1 , further comprising:
sending, from the primary target database system to the secondary target database system, log positions until a time when the data was replicated from the primary source database system to the primary target database system, wherein the log positions are used for replicating further changes that occurred at the secondary source database system after the failure.

4. The computer-implemented method of claim 3 , wherein the log positions are sent in replication metadata of the primary target database system.

5. The computer-implemented method of claim 1 , wherein the failure is a failure of a disk subsystem of the primary source database system.

6. The computer-implemented method of claim 1 , wherein the primary source database system actively mirrors storage of the primary source database system to storage of the secondary source database system such that the secondary source database system comprises the copy of the data.

7. The computer-implemented method of claim 1 , wherein copying the data to the secondary target database system is performed in parallel to executing the analysis queries.

8. The computer-implemented method of claim 1 , wherein causing the function to be activated in the secondary data center comprises changing the primary source database system into a read/write mode.

9. The computer-implemented method of claim 1 , wherein the primary source database system is an online transaction processing (OLTP) system and the primary target database system is an online analytical processing (OLAP) system.

10. The computer-implemented method of claim 1 , wherein the secondary source database system is an online transaction processing (OLTP) system and the secondary target database system is an online analytical processing (OLAP) system.

11. The computer-implemented method of claim 1 , wherein:
the primary data center is connected to the secondary data center through one or more links and a first link of the one or more links is of a type selected from the group consisting of: a Fibre Channel Protocol (FCP) link and a Fibre Connection (FICON) link.

12. A computer program product comprising:
one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media, the program instructions comprising:
program instructions to provide a primary data center, the primary data center comprising a primary source database system and a primary target database system, wherein a function is activated in the primary data center causing the primary target database system to:
comprise a copy of data of the primary source database system;
receive analysis queries from the primary source database system; and
execute the analysis queries on the data; and

program instructions to, in response to detecting a failure in the primary source database system:
offload queries intended for the primary source database system to a secondary source database system, the secondary source database system of a secondary data center further comprising a secondary target database system, the secondary source database system comprising a copy of the data, wherein the function is deactivated in the secondary data center;
responsive to the primary target database system being available:
receive, by the primary target database system, analysis queries, processed by the secondary source database system, of the offloaded queries; and
copy, by the primary target database system, the data to the secondary target database system; and

cause the function to be activated in the secondary data center.

13. The computer program product of claim 12 , further comprising program instructions, collectively stored on the one or more computer readable storage media, to set the primary target database system to a read only mode before executing the analysis queries at the primary target database system.

14. The computer program product of claim 12 , further comprising:
program instructions, collectively stored on the one or more computer readable storage media, to send, from the primary target database system to the secondary target database system, log positions until a time when the data was replicated from the primary source database system to the primary target database system, wherein the log positions are used for replicating further changes that occurred at the secondary source database system after the failure.

15. The computer program product of claim 14 , wherein the log positions are sent in replication metadata of the primary target database system.

16. The computer program product of claim 12 , wherein the failure is a failure of a disk subsystem of the primary source database system.

17. The computer program product of claim 12 , wherein the primary source database system actively mirrors storage of the primary source database system to storage of the secondary source database system such that the secondary source database system comprises the copy of the data.

18. The computer program product of claim 12 , wherein copying the data to the secondary target database system is performed in parallel to executing the analysis queries.

19. The computer program product of claim 12 , wherein program instructions to cause the function to be activated in the secondary data center comprise program instructions to change the primary source database system into a read/write mode.

20. A computer system comprising:
one or more computer processors, one or more computer readable storage media, and program instructions collectively stored on the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:
program instructions to provide a primary data center, the primary data center comprising a primary source database system and a primary target database system, wherein a function is activated in the primary data center causing the pri

Assignees

• IBM

Inventors

• Roy Huiyan
• Martin Daniel
• Butterstein Dennis
• Pelletier Kevin
• Hrle Namik

Classifications

• G06F11/2094 Primary

  Redundant storage or storage space (G06F11/2056 takes precedence) · CPC title

• G06F16/1865

  Transactional file systems · CPC title

• G06F2201/85

  Active fault masking without idle spares · CPC title

• G06F11/2097

  maintaining the standby controller/processing unit updated (initialisation or re-synchronisation thereof G06F11/1658 and subgroups) · CPC title

• G06F2201/80

  Database-specific techniques · CPC title