An operational bundle which consists of multiple ACID transactions, usually on multiple servers, which must all commit or roll back. A transaction manager coordinates this through two-phase commits.
Questions tagged [distributed-transactions]
600 questions
15
votes
2 answers
Why the pattern for microservices distributed transactions named as SAGA?
I have gone through various SAGA patterns(Orchestration,Choreography), suggested for maintaining database consistency in microservices during distributed transactions.
But I am not able to relate the literal word SAGA in the context.
Why is it named…
Aditya Rewari
- 2,343
- 2
- 23
- 36
15
votes
1 answer
Spring Global transaction vs Local transaction
While reading through Spring transaction documentation I see that it supports both Global transactions and Local transactions.
In simple terms what is global transaction and what is local transaction?
What are the advantages of one over the other?…
18bytes
- 5,951
- 7
- 42
- 69
14
votes
1 answer
Sequential consistency in newbie terms?
Sequential consistency
The result of any execution is the same as if the operations of all
the processors were executed in some sequential order, and the
operations of each individual processor appear in this sequence in the
order specified…
Henok Tesfaye
- 8,287
- 13
- 47
- 84
14
votes
6 answers
Best way to handle LOBs in Oracle distributed databases
If you create an Oracle dblink you cannot directly access LOB columns in the target tables.
For instance, you create a dblink with:
create database link TEST_LINK
connect to TARGETUSER IDENTIFIED BY password using 'DATABASESID';
After this you…
morais
- 2,951
- 5
- 27
- 27
13
votes
4 answers
Deadlocks causing 'Server failed to resume the transaction' with NHibernate and distributed transactions
We are having an issue when using NHibernate with distributed transactions.
Consider the following snippet:
//
// There is already an ambient distributed transaction
//
using(var scope = new TransactionScope()) {
using(var session =…
jon without an h
- 572
- 1
- 4
- 17
13
votes
1 answer
How to learn about designing highly transactional systems?
I have been mostly working on data analysis, BI tools, etc. in my career. Most of the applications I work on are majorly read-only applications. Although I have also worked on simple CRUD applications but nothing extraordinarily transactional.
As a…
Kumar Vaibhav
- 2,632
- 8
- 32
- 54
13
votes
2 answers
Why is Paxos leader election not done using Paxos?
The questions below are intended to be serious rather than frivolous. I lack experience in distributed systems, but I do understand how Basic Paxos works and why leader selection is useful. Unfortunately, my understanding is not deep enough to…
merlin2011
- 71,677
- 44
- 195
- 329
12
votes
2 answers
How does the banking transactions work "under the hood" - possibly in detail
I'm wondering how does the banking transactions work. It is very hard to find some at least acceptable explanation. I dont mean some basic distributed transaction algorithms for not that serious businesses.
So what kind of measures must bank take to…
Jarek
- 7,425
- 15
- 62
- 89
12
votes
1 answer
Could AKKA remoted actors be a used in a p2p swarm context?
Most of the use cases I've seen for Akka actors are highly performing multicore servers or local clusters.
I'm curious about it's applicability to more remote high latency and highly failing swarm structures such as p2p networks.
The application I…
barrymac
- 2,750
- 1
- 20
- 32
12
votes
2 answers
What does a TransactionScope really do
Looking into it I verified that for example the value o "myInt" is not rolledback in the following scenario
int myInt = 10;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew))
{
myInt=20;
Transaction t =…
Leonardo
- 10,737
- 10
- 62
- 155
10
votes
1 answer
Recommended practice for stopping transactions escalating to distributed when using transactionscope
Using the TransactionScope object to set up an implicit transaction that doesn't need to be passed across function calls is great! However, if a connection is opened whilst another is already open, the transaction coordinator silently escalates the…
Kram
- 4,099
- 4
- 39
- 60
10
votes
1 answer
Reliable test for MSDTC promoting transactions to distributed?
How can I reliably check that MSDTC has promoted a transaction to a distributed transaction?
This is when using TransactionScope in .net.
Currently a co-worker is testing this by shutting down the coordinator on his machine - if an exception is…
Oded
- 489,969
- 99
- 883
- 1,009
10
votes
2 answers
Spring / RabbitMQ : transaction management
To simplify my problem, I have
App1 with @Transactionnal method createUser():
Insert new user in database
Add async message in RabbitMQ so that the user receives a notification mail
(potentially some additional code, but not much)
App2 with…
Sebastien Lorber
- 89,644
- 67
- 288
- 419
9
votes
3 answers
How to do 2 phase commit between two micro-services(Spring-boot)?
I Have two mico-serives A and B where they connect to seperate database, From Mico-serives A i need to persist(save) objects of both A and B in same transtation how to achive this.
I am using Spring micro-servies with netflix-oss.Please give…
sathees
- 193
- 2
- 3
- 10
9
votes
1 answer
Configuration binding extension could not be found
I am trying to get a WCF webservice running which will participate in distributed transactions. I keep getting the following error message...
Configuration binding extension 'system.serviceModel/bindings/myBinding' could not be found. Verify that…
Peter Morris
- 20,174
- 9
- 81
- 146