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?
Printable View
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?
I have tried it on Enterprise and community with no success.
I am leaning towards the other open source db, but the migration is not an easy task since we are already on production for past 4 years.
It's a decision that we can't make lightly basically, and we are somewhat delaying this entire 2PC feature for a time being.
We are also using hibernate as our persistence framework and we can't utilize the secondary caching that supports distributed clustered, simply due to this lack of 2PC feature.
Oh well.