How to achieve Transactional with Spring-boot-aerospike as we are updating mutliple sets in a request

65 views Asked by At

I am new to Aerospike DB and hoping to try transactional.

We have an API which updates TableA and TableB in a single request. Now, how can I make my request transactional where atomicity is achieved?

1

There are 1 answers

0
Roi Menashe On BEST ANSWER

Aerospike doesn't support multi record transactions natively yet.

There is a non-official way to achieve multi record transactions:

https://aerospike.com/blog/multi-record-transactions-for-aerospike/

https://github.com/aerospike-examples/atomicMultiRecordTxn

But it has flaws (https://github.com/aerospike-examples/atomicMultiRecordTxn#caveats) and it's not supported in Spring Data Aerospike - you added a spring-boot tag so I assume you are using Spring Data Aerospike.

An alternative approach could involve modeling your data differently, potentially eliminating the need for multi-record transactions. Aerospike supports a rich data model which includes Maps and Lists, check out: https://docs.aerospike.com/server/guide/data-types/overview