It's certainly a challenge, but inherent to having multiple systems of record. I'd always refer to the patterns described in https://developers.redhat.com/articles/2021/09/21/distributed-transaction-patterns-microservices-compared