svn: /phpdoc/en/trunk/reference/mysqlnd_ms/ changes.xml concepts.xml quickstart.xml setup.xml
| From: | Ulf Wendel | 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">