We are using DB2 which does support XA but I am not sure about MySQL. Are you using the community edition or the enterprise edition?