Can I perform a transaction across two different MySQL databases on two different servers in different tables I have a table A in database db1 in server A and table B in database db2 in server B, both of which are MySQL. 

Is it possible to make a transaction, where updates in both tables are involved?

                      +-&gt; Server A | db1 | table A -+
Transaction:  Update -+                             + -&gt; COMMIT / ROLLBACK
                      +-&gt; Server B | db2 | table B -+


If so, kindly provide step by step instruction on how to achieve this.
This is a duplicate question. It seems like this is a possibility with InnoDB as your engine, but other than that, unfortunately, it does not seem like there is a way. This also seems dependent on the version of MySQL, like 5.6 and above, the thread I linked to points to a documentation here.

A side note: just because this seems to a possibility, it may not be the best solution. It seems that it would be best to write the transaction, and use a script to run the transaction on both servers.