[Maria-developers] 2PC between two engines + binlog
![](https://secure.gravatar.com/avatar/4a81ad68d36ab4fdbf830ccb4db35769.jpg?s=120&d=mm&r=g)
Hi Hakan, all With PBXT and the latest merge, this should now technically be enabled (again). That is, a transaction should be consistent between InnoDB+PBXT +binlog, that is either all or none should commit. But as I understand, when this was last tried with Falcon it went kaboom in MySQL, so likely there are some bugs. I think it would be good to at least create/enable some tests for this, then we can see what the exact code status is, and hopefully get it all working as well. Right now I don't think anybody really expects something like this to work, but in theory it should work so presumptions *may* be made (I know this sentence appears kinda contradictory, hope it makes sense anyhow ;-). Thus it's important for us to know what happens, so that we can tell people "don't do this now, please track bug #", or "please try this". Thanks Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget. Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
![](https://secure.gravatar.com/avatar/c9faafda089b9482b0f5094e44db85ec.jpg?s=120&d=mm&r=g)
Hi Hakan, Unfortunately there is a bug in 1.0.09f which prevents PBXT XA from working correctly with the binlog. I have pushed the patch to: lp:~paul-mccullagh/maria/maria-pbxt-1009g We have already tested the patch with MySQL 5.1.41. I will propose the patch for merge as soon as I have finished testing MariaDB. After that, all should work (theoretically), as Arjen says... :) On Dec 21, 2009, at 1:29 PM, Arjen Lentz wrote:
Hi Hakan, all
With PBXT and the latest merge, this should now technically be enabled (again). That is, a transaction should be consistent between InnoDB+PBXT +binlog, that is either all or none should commit.
But as I understand, when this was last tried with Falcon it went kaboom in MySQL, so likely there are some bugs. I think it would be good to at least create/enable some tests for this, then we can see what the exact code status is, and hopefully get it all working as well.
Right now I don't think anybody really expects something like this to work, but in theory it should work so presumptions *may* be made (I know this sentence appears kinda contradictory, hope it makes sense anyhow ;-). Thus it's important for us to know what happens, so that we can tell people "don't do this now, please track bug #", or "please try this".
Thanks
Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget.
Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com
![](https://secure.gravatar.com/avatar/f07edef711f62df1b869b658b12d4623.jpg?s=120&d=mm&r=g)
Hi Paul, I will wait for your update. Cheers, Hakan On 21.12.2009, at 14:21, Paul McCullagh wrote:
Hi Hakan,
Unfortunately there is a bug in 1.0.09f which prevents PBXT XA from working correctly with the binlog.
I have pushed the patch to: lp:~paul-mccullagh/maria/maria-pbxt-1009g
We have already tested the patch with MySQL 5.1.41. I will propose the patch for merge as soon as I have finished testing MariaDB.
After that, all should work (theoretically), as Arjen says... :)
On Dec 21, 2009, at 1:29 PM, Arjen Lentz wrote:
Hi Hakan, all
With PBXT and the latest merge, this should now technically be enabled (again). That is, a transaction should be consistent between InnoDB+PBXT +binlog, that is either all or none should commit.
But as I understand, when this was last tried with Falcon it went kaboom in MySQL, so likely there are some bugs. I think it would be good to at least create/enable some tests for this, then we can see what the exact code status is, and hopefully get it all working as well.
Right now I don't think anybody really expects something like this to work, but in theory it should work so presumptions *may* be made (I know this sentence appears kinda contradictory, hope it makes sense anyhow ;-). Thus it's important for us to know what happens, so that we can tell people "don't do this now, please track bug #", or "please try this".
Thanks
Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget.
Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com
-- Hakan Küçükyılmaz, QA/Benchmark Engineer, Stuttgart/Germany Monty Program Ab, http://askmonty.org/ Skype: hakank_ Phone: +49 171 1919839
![](https://secure.gravatar.com/avatar/c9faafda089b9482b0f5094e44db85ec.jpg?s=120&d=mm&r=g)
Hi Hakan, All tests look good, so I have proposed the bug fix mentioned below for merging: lp:~paul-mccullagh/maria/maria-pbxt-1009g On Dec 21, 2009, at 3:09 PM, Hakan Kuecuekyilmaz wrote:
Hi Paul,
I will wait for your update.
Cheers,
Hakan
On 21.12.2009, at 14:21, Paul McCullagh wrote:
Hi Hakan,
Unfortunately there is a bug in 1.0.09f which prevents PBXT XA from working correctly with the binlog.
I have pushed the patch to: lp:~paul-mccullagh/maria/maria-pbxt-1009g
We have already tested the patch with MySQL 5.1.41. I will propose the patch for merge as soon as I have finished testing MariaDB.
After that, all should work (theoretically), as Arjen says... :)
On Dec 21, 2009, at 1:29 PM, Arjen Lentz wrote:
Hi Hakan, all
With PBXT and the latest merge, this should now technically be enabled (again). That is, a transaction should be consistent between InnoDB+PBXT +binlog, that is either all or none should commit.
But as I understand, when this was last tried with Falcon it went kaboom in MySQL, so likely there are some bugs. I think it would be good to at least create/enable some tests for this, then we can see what the exact code status is, and hopefully get it all working as well.
Right now I don't think anybody really expects something like this to work, but in theory it should work so presumptions *may* be made (I know this sentence appears kinda contradictory, hope it makes sense anyhow ;-). Thus it's important for us to know what happens, so that we can tell people "don't do this now, please track bug #", or "please try this".
Thanks
Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Exceptional Services for MySQL at a fixed budget.
Follow our blog at http://openquery.com/blog/ OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com
-- Hakan Küçükyılmaz, QA/Benchmark Engineer, Stuttgart/Germany Monty Program Ab, http://askmonty.org/ Skype: hakank_ Phone: +49 171 1919839
-- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com
participants (4)
-
Arjen Lentz
-
Hakan Kuecuekyilmaz
-
Kristian Nielsen
-
Paul McCullagh