System and method for supporting common transaction identifier (XID) optimization based on resource manager (RM) instance awareness in a transactional environment

• US 9,524,186 B2
• Filed: 12/31/2014
• Issued: 12/20/2016
• Est. Priority Date: 04/28/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Little, Todd J., Shen, Xugang, Zhang, Qingsheng, Jin, Yongshun
• Primary Examiner(s): Khatri, Anil
• Application Number:
  US14/587,468
• Publication Number:
  US 20150309834A1
• Time in Patent Office: 720 Days
• Field of Search: 718100-108
• US Class Current: 1/1
• CPC Class Codes: G06F 9/466 Transaction processing
• CPC Class Codes: G06F 9/467 Transactional memory G06F9/528 takes precedence
• CPC Class Codes: G06F 9/5083 Techniques for rebalancing the load in a distributed system
• CPC Class Codes: H04L 67/10 in which an application is distributed across nodes in the network software deployment G06F8/60; multiprogramming arrangements G06F9/46

Abstract

A system and method can support transaction processing in a transactional environment. A coordinator for a global transaction operates to propagate a common transaction identifier and information for a resource manager instance to one or more participants of the global transaction in the transactional environment. The coordinator allows said one or more participants, which share resource manager instance with the coordinator, to use the common transaction identifier, and can process the global transaction for said one or more participants that share the resource manager instance using one transaction branch.

Claims

1. A method for supporting transaction processing in a transactional system comprising:

a plurality of transactional servers including a first group of transactional servers including a first transaction manger and a second group of transactional servers including a second transaction manager, and a plurality of resource manager instances for managing access to a database, the method comprising;

receiving a global transaction from said plurality of transactional servers directed via said first transaction manager and said second transaction to a shared resource manager instance of said plurality of resource manager instances;

using the first transaction manager in the first group of transactional servers as the coordinator for said global transaction;

propagating, via the coordinator for said global transaction, a common transaction identifier and information for said resource manager instance to both of said first transaction manager and second transaction manager participating in said global transaction in the transactional environment;

allowing said first transaction manager and second transaction manager which share said shared resource manager instance, to use the common transaction identifier; and

processing the global transaction, via the coordinator and shared resource manager instance using one transaction branch.

2. The method of claim 1, further comprising:

using a transaction identifier assigned to the global transaction by the first transaction manager in first group of transactional servers as the common transaction identifier.

3. The method of claim 1, wherein

said database comprises a clustered database.

4. The method of claim 1, further comprising:

committing or rolling back the global transaction, via the coordinator, for said first transaction manager and second transaction manager.

5. The method of claim 1, further comprising:

using another transaction branch to process the global transaction for a third transaction manager participating in the global transaction, wherein said third transaction manager utilizes a different resource manager instance of said plurality of resource manager instances than said shared resource manager instance.

6. The method of claim 1, further comprising:

invoking a one-phase commit operation directly on the shared resource manager instance, when all transaction managers participating in the global transaction share the shared resource manager instance.

7. The method of claim 1, further comprising:

sending a forget request to a transaction manager on a remote node in order to release remote transactional resources.

8. The method of claim 1, further comprising:

allowing the first and second transaction managers to be in different domains.

9. The method of claim 1, wherein the first transaction manager is in a remote domain from the second transaction manager, and wherein the method further comprises:

receiving the common transaction identifier and the identification information for the resource manager instance at the second transaction manager from the remote domain via a gateway.

10. A system for supporting transaction processing in a transactional environment, comprising:

a plurality of networked computer systems each comprising one or more microprocessor and memory;

a plurality of transactional servers operating on said plurality of networked computer systems, wherein said plurality of transactional servers include a first group of transactional servers including a first transaction manger, and a second group of transactional servers including a second transaction manager;

a database;

a plurality of resource manager instances for managing access to the database;

wherein said plurality of transactional servers are configured to generate a global transaction directed via said first transaction manager and said second transaction to a shared resource manager instance of said first plurality of resource manager instances and second plurality of resource manager instances;

wherein the first transaction manager functions as the coordinator for the global transaction;

wherein the coordinator for said global transaction is configured to propagate a common transaction identifier and information for said resource manager instance to both of said first transaction manager and second transaction manager participating in said global transaction in the transactional environment;

wherein said first transaction manager and second transaction manager which share said shared resource manager instance are configured to use the common transaction identifier to coordinate the global transaction; and

wherein the coordinator is configured to process the global transaction, via the coordinator and shared resource manager instance to the database, using one transaction branch.

11. The system according to, claim 10, wherein:

a transaction identifier assigned to the global transaction by the first transaction manager in the first group of transactional server is used as the common transaction identifier.

12. The system according to claim 10, wherein:

the database is a clustered database.

13. The system according to claim 10, wherein:

the coordinator is configured to commit or roll back the global transaction for both of said first transaction manager and second transaction manager.

14. The system according to claim 10, further comprising:

a third transaction manager participating in said global transaction, wherein said third transaction manager utilizes a different resource manager instance of said plurality of resource manager instances than said shared resource manager instance; and

wherein another transaction branch is used to process the global transaction for said third transaction manager via said different resource manager.

15. The system according to claim 10, wherein:

an one-phase commit operation is invoked directly on the resource manager instance, when all transaction managers participating in the global transaction share the shared resource manager instance.

16. The system according to claim 10, wherein:

the coordinator is further configured to send a forget request to a remote transaction manager on a remote node in order to release remote transactional resources.

17. The system according to claim 10, wherein:

the first transaction manager and the second transaction manager are in different domains.

18. A non-transitory machine readable storage medium having instructions stored thereon for supporting transaction processing in a transactional system comprising:

a plurality of transactional servers including a first group of transactional servers including a first transaction manger and a second group of transactional servers including a second transaction manager, and a plurality of resource manager instances for managing access to a database, which instructions, when, executed, cause the transactional system to perform steps comprising;

receiving a global transaction from said plurality of transactional servers directed via said first transaction manager and said second transaction to a shared resource manager instance of said first plurality of resource manager instances and second plurality of resource manager instances;

using the first transaction manager in the first group of transactional servers as the coordinator for said global transaction;

propagating, via the coordinator for said global transaction, a common transaction identifier and information for said resource manager instance to both of said first transaction manager and second transaction manager participating in said global transaction in the transactional environment;

allowing said first transaction manager and second transaction manager which share said shared resource manager instance, to use the common transaction identifier; and

processing the global transaction, via the coordinator and shared resource manager instance using one transaction branch.