Distributed systems like ==NoSQL databases== which scale horizontally on the fly don’t support ==ACID transactions== globally & this is due to their design. The whole reason for the development of NoSQL tech is the ability to be Highly Available and Scalable. If we must lock down nodes every time, it becomes just like SQL.
So, NoSQL databases don’t support ACID transactions and those that claim to, have terms and conditions applied to them. Generally, transaction support is limited to a geographic zone or an entity hierarchy. Developers of tech make sure that all the Strongly consistent entity nodes reside in the same geographic zone to make ACID transactions possible.
Conclusion: For transactional things go for MySQL because it provides a lock-in feature and supports ACID transactions.
https://www.geeksforgeeks.org/eventual-vs-strong-consistency-in-distributed-databases/