Author: shinz
Date: 2006-01-04 18:17:03 +0100 (Wed, 04 Jan 2006)
New Revision: 672
Log:
Final tweaks to RBR sections
Modified:
trunk/refman-5.1/replication.xml
Modified: trunk/refman-5.1/replication.xml
===================================================================
--- trunk/refman-5.1/replication.xml 2006-01-04 15:24:09 UTC (rev 671)
+++ trunk/refman-5.1/replication.xml 2006-01-04 17:17:03 UTC (rev 672)
@@ -4260,11 +4260,16 @@
<listitem>
<para>
- Not all update statements can be replicated:
+ Not all <literal>UPDATE</literal> statements
+ can be replicated:
Any non-deterministic behavior, for example when
using random functions in an SQL statement, is
hard to replicate when using statement-based
replication.
+ When using a non-deterministic user-defined function (UDF),
+ it is not possible to replicate the result using
+ statement-based replication, while row-based replication
+ will just replicate the value returned by the UDF.
</para>
</listitem>
@@ -4392,6 +4397,11 @@
as well as <literal>GRANT</literal> and
<literal>REVOKE</literal> statements, are replicated
using row-based-replication.
+ For statements like
+ <literal>CREATE … SELECT</literal>, a
+ <literal>CREATE</literal> statement is generated from the
+ table definition and replicated statement-based, while
+ the row insertions are replicated row-based.
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r672 - trunk/refman-5.1 | stefan | 4 Jan |