XA transactions for heterogeneous database

[arjenzhou]

Hi community,
I was searching for a solution of distributed transaction (XA), and just ran into shardingsphere-jdbc. After checking the documentation found there was no example for heterogeneous database except database replicas.

I wonder if shardingsphere support XA for heterogeneous database, i.e. run differenct SQLs in MySQL and PostgreSQL in one transaction. Please correct me for any misunderstanding.

[tristaZero]

Hi @arjenzhou
Thanks for your question. Currently, ShardingSphere supports XA for homogeneous databases. Could I know whether you have this need? It's expected that ShardingSphere helps users manage heterogeneous databases? But how do users visit ShardingSphere?

[arjenzhou]

@tristaZero Thanks for your reply,
I have a data transmisson job, whose state updating and job committing were manipulated in two heterogeneous database. i.e. Updating state in MySQL, commiting transfer table in PostgreSQL, commiting these in one transaction helps decrease complexity. By searching XA solution found shardingsphere-jdbc claims that no extra deployment and dependence.
I wonder is there any way to do this among heterogeneous dbs without deploying any transaction coordinator? It seems beyond the reach. :(