Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-31 Thread Sanford Whiteman
> MySQl and MyISAM can not be used in conjuction with LIXA for > distributed transaction processing. Should be very clear about this in your documentation, as MySQL as RM will be unsupported in practice in the majority of *MP installations. You didn't mention MSSQL, I assume because you develop o

Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-30 Thread Christian Ferrari
>> 1. Is there any interest in "two phase commit" inside PHP >> community? Without a real interest, every effort would be useless. > > I can't speak to a "critical mass" of interest, but as PHP and > MySQL > are closely coupled in the real world, until relatively recently (when > Inno became t

Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-30 Thread Christian Ferrari
>> Dear all, >> I'm the author of LIXA project (http://lixa.sourceforge.net/) and I >> would discuss a little about "two phase commit" transactions for > PHP >> applications. > > Besides all technical discussions etc one legal comment, on the project > page I read: > >         Which type of

Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-30 Thread Johannes Schlüter
On Tue, 2012-05-29 at 21:27 +0100, Christian Ferrari wrote: > Dear all, > I'm the author of LIXA project (http://lixa.sourceforge.net/) and I > would discuss a little about "two phase commit" transactions for PHP > applications. Besides all technical discussions etc one legal comment, on the proje

Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-30 Thread Gustavo Lopes
On Wed, 30 May 2012 22:10:56 +0200, Christian Ferrari wrote: You correctly understood the only necessary changes are related to open/close connection to the resource manager (database); this is a consequence of XA and TX specifications. I've not completely understood your statement "add so

Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-30 Thread Sanford Whiteman
> 1. Is there any interest in "two phase commit" inside PHP > community? Without a real interest, every effort would be useless. I can't speak to a "critical mass" of interest, but as PHP and MySQL are closely coupled in the real world, until relatively recently (when Inno became the default) that

Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-30 Thread Christian Ferrari
>> >> These are the issues I partially solved integrating LIXA with PHP. >> >> 1. >>  XA interface is a C level interface: the PHP database drivers must be >> changed at C source level to avoid many leaps between C and PHP code. >> The most important PHP database drivers are distributed with PHP

Re: [PHP-DEV] PHP and two phase commit transactions

2012-05-29 Thread Gustavo Lopes
On Tue, 29 May 2012 22:27:53 +0200, Christian Ferrari wrote: These are the issues I partially solved integrating LIXA with PHP. 1. XA interface is a C level interface: the PHP database drivers must be changed at C source level to avoid many leaps between C and PHP code. The most important

[PHP-DEV] PHP and two phase commit transactions

2012-05-29 Thread Christian Ferrari
Dear all, I'm the author of LIXA project (http://lixa.sourceforge.net/) and I would discuss a little about "two phase commit" transactions for PHP applications. "Two phase commit" means I can write a program that uses two (or more) Resource Managers (for example databases, like MySQL and Postgre