Distributed transactions within a microservices architecture
-
Hello, In my company we had a system on .net framework platform. That was made from an orchestator, different rest API services on top of a monolithic oracle DB. With a huge plsql library. We used distributed transaction for the operation (import of data). Because of the rollback possibilities if one request did fail e.t.c. And used a orchestrator in front of the rest API services (micro services) that organized the different requests all in one transaction. We had to upgrade the system to .net core. But .net core don't support DTC anymore ! Have anyone had a similar situation, and what what did you do about it? Or do anyone have any comments to this issue/problem.? That if one request fails in a big operation of many requests the database data will not be consistent, if no rollback is done. When we use many "micro"services on top of one monolithic database. BR
-
Hello, In my company we had a system on .net framework platform. That was made from an orchestator, different rest API services on top of a monolithic oracle DB. With a huge plsql library. We used distributed transaction for the operation (import of data). Because of the rollback possibilities if one request did fail e.t.c. And used a orchestrator in front of the rest API services (micro services) that organized the different requests all in one transaction. We had to upgrade the system to .net core. But .net core don't support DTC anymore ! Have anyone had a similar situation, and what what did you do about it? Or do anyone have any comments to this issue/problem.? That if one request fails in a big operation of many requests the database data will not be consistent, if no rollback is done. When we use many "micro"services on top of one monolithic database. BR
I think a DTC implies "multiple" "micro services". A transaction that spans multiple databases is not what I would can micro.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it. ― Confucian Analects: Rules of Confucius about his food