svn: /phpdoc/en/trunk/reference/mysqlnd_ms/ changes.xml concepts.xml quickstart.xml setup.xml

From: Date: Thu, 14 Mar 2013 15:31:49 +0000
Subject: svn: /phpdoc/en/trunk/reference/mysqlnd_ms/ changes.xml concepts.xml quickstart.xml setup.xml
Groups: php.doc.cvs 
Request: Send a blank email to doc-cvs+get-11104@lists.php.net to get a copy of this message
uw Thu, 14 Mar 2013 15:31:49 +0000 Revision: http://svn.php.net/viewvc?view=revision&revision=329786 Log: Final touches for alpha: trx detection improvements Changed paths: U phpdoc/en/trunk/reference/mysqlnd_ms/changes.xml U phpdoc/en/trunk/reference/mysqlnd_ms/concepts.xml U phpdoc/en/trunk/reference/mysqlnd_ms/quickstart.xml U phpdoc/en/trunk/reference/mysqlnd_ms/setup.xml Modified: phpdoc/en/trunk/reference/mysqlnd_ms/changes.xml =================================================================== --- phpdoc/en/trunk/reference/mysqlnd_ms/changes.xml 2013-03-14 15:28:55 UTC (rev 329785) +++ phpdoc/en/trunk/reference/mysqlnd_ms/changes.xml 2013-03-14 15:31:49 UTC (rev 329786) @@ -19,7 +19,7 @@ <itemizedlist> <listitem> <simpara> - Release date: under development + Release date: 03/2013 </simpara> </listitem> <listitem> @@ -135,6 +135,48 @@ </listitem> <listitem> <para> + Improved transaction boundaries detection with PHP 5.5.0 or newer and + <literal>mysqli</literal>. The <literal>mysqli</literal> extension has been + modified to use new C API calls of the <literal>mysqlnd</literal> + library to begin, commit and rollback a transaction or savepoint. + If <link linkend="ini.mysqlnd-ms-plugin-config-v2.trx-stickiness"><literal>trx_stickiness</literal></link> + is used to enable transaction aware load balancing, not only the + <function>mysqli_autocommit</function> call will be monitored by the plugin + but also <function>mysqli_begin</function>, <function>mysqli_commit</function> + and <function>mysqli_rollback</function>. All SQL features to control + transactions are also available through the improved <literal>mysqli</literal> + transaction control related functions. Thus, there is no need to + issue SQL statements instead of using API calls. Applications + using the appropriate API calls only, can be load balanced by PECL/mysqlnd_ms + in a completely transaction aware way. + </para> + <para> + Please note, <literal>PDO_MySQL</literal> has not been updated + yet to utilize the new mysqlnd API calls. Thus, transaction boundary + detection with <literal>PDO_MySQL</literal> continues to be limited to + the monitoring of <function>PDO::setAttribute(PDO::ATTR_AUTOCOMMIT, ...)</function>. + </para> + </listitem> + <listitem> + <para> + Introduced <literal>trx_stickiness=on</literal>. This + <link linkend="ini.mysqlnd-ms-plugin-config-v2.trx-stickiness"><literal>trx_stickiness</literal></link> + option differs from <literal>trx_stickiness=master</literal> as it + tries to execute a read only transaction on a slave, if + quality of service (consistency level) allows the use of a slave. + Read only transactions have been introduced in MySQL 5.6. They + offer performance gains. + </para> + </listitem> + <listitem> + <para> + Query cache support considered beta if used with <literal>mysqli</literal> + API. It should work fine with primary copy based clusters. For all other + APIs, the feature continues to be called experimental. + </para> + </listitem> + <listitem> + <para> The code examples in the mysqlnd_ms source were updated. </para> </listitem> Modified: phpdoc/en/trunk/reference/mysqlnd_ms/concepts.xml =================================================================== --- phpdoc/en/trunk/reference/mysqlnd_ms/concepts.xml 2013-03-14 15:28:55 UTC (rev 329785) +++ phpdoc/en/trunk/reference/mysqlnd_ms/concepts.xml 2013-03-14 15:31:49 UTC (rev 329786) @@ -444,6 +444,12 @@ sure that the autocommit settings is changed exclusively through the listed API calls. </para> + <para> + API based transaction boundary detection has been improved with PHP 5.5.0 and + PECL/mysqlnd_ms 1.5.0 to cover not only calls to <function>mysqli_autocommit</function> + but also <function>mysqli_begin</function>, + <function>mysqli_commit</function> and <function>mysqli_rollback</function>. + </para> </section> <section xml:id="mysqlnd-ms.errorhandling"> Modified: phpdoc/en/trunk/reference/mysqlnd_ms/quickstart.xml =================================================================== --- phpdoc/en/trunk/reference/mysqlnd_ms/quickstart.xml 2013-03-14 15:28:55 UTC (rev 329785) +++ phpdoc/en/trunk/reference/mysqlnd_ms/quickstart.xml 2013-03-14 15:31:49 UTC (rev 329786) @@ -729,6 +729,12 @@ a transaction. Once <literal>autocommit</literal> is re-enabled, the plugin starts to load balance statements again. </para> + <para> + API based transaction boundary detection has been improved with PHP 5.5.0 and + PECL/mysqlnd_ms 1.5.0 to cover not only calls to <function>mysqli_autocommit</function> + but also <function>mysqli_begin</function>, + <function>mysqli_commit</function> and <function>mysqli_rollback</function>. + </para> <para> <example> <title>Transaction aware load balancing: trx_stickiness setting</title> Modified: phpdoc/en/trunk/reference/mysqlnd_ms/setup.xml =================================================================== --- phpdoc/en/trunk/reference/mysqlnd_ms/setup.xml 2013-03-14 15:28:55 UTC (rev 329785) +++ phpdoc/en/trunk/reference/mysqlnd_ms/setup.xml 2013-03-14 15:31:49 UTC (rev 329786) @@ -2300,6 +2300,16 @@ by SQL statements such as <literal>SET AUTOCOMMIT=0</literal> or <literal>BEGIN</literal>. </para> <para> + Since PHP 5.5.0 the mysqlnd library features additional C API calls to + control transactions. The level of control matches the one offer by SQL + statement. The <literal>mysqli</literal> API has been modified to use + those calls. Since version 1.5.0, PECL/mysqlnd_ms can monitor not only + <function>mysqli_autocommit</function> but also <function>mysqli_begin</function>, + <function>mysqli_commit</function> and <function>mysqli_rollback</function> to + detect transaction boundaries and stop load balancing for the duration of + a transaction. + </para> + <para> <example> <title>Using master to execute transactions</title> <programlisting role="ini">

« previous php.doc.cvs (#11104) next »