If I have done functional partitioning in my database and have for example a database Transactions and a database Products and these are different database servers and there are references from tables in the Transactions schema to tables in the products:
If I have a transaction that involves/updates/deletes rows from tables both databases is that executed within a two phase commit protocol and is that done automatically under the hood by MySQL or some how the client program has to be involved?
In my understanding the client program has to be involved in XA transactions but my scenario is not of that kind. So how would that work?
Asked
Active
Viewed 46 times
0
Jim
- 123
- 5