| List: | Commits | « Previous MessageNext Message » | |
| From: | mcbrown | Date: | September 6 2007 3:07pm |
| Subject: | svn commit - mysqldoc@docsrva: r7726 - in trunk: refman-5.0 refman-5.1 refman-5.2 | ||
| View as plain text | |||
Author: mcbrown Date: 2007-09-06 15:07:57 +0200 (Thu, 06 Sep 2007) New Revision: 7726 Log: Update image locations Make depend Modified: trunk/refman-5.0/Makefile.depends trunk/refman-5.0/replication-solutions.xml trunk/refman-5.0/replication-topology.xml trunk/refman-5.1/Makefile.depends trunk/refman-5.1/replication-notes.xml trunk/refman-5.1/replication-solutions.xml trunk/refman-5.1/replication-topology.xml trunk/refman-5.2/replication-notes.xml Modified: trunk/refman-5.0/Makefile.depends =================================================================== --- trunk/refman-5.0/Makefile.depends 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.0/Makefile.depends 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 8, Lines Added: 30, Lines Deleted: 30; 6123 bytes @@ -864,6 +864,7 @@ ../refman-common/images/published/cnet-win-install-step3.png \ ../refman-common/images/published/cnet-win-install-step4.png \ ../refman-common/images/published/drbd-main.png \ + ../refman-common/images/published/multi-db.png \ ../refman-common/images/published/myaccess-odbc.png \ ../refman-common/images/published/myaccess.png \ ../refman-common/images/published/myarchitecture.png \ @@ -908,6 +909,10 @@ ../refman-common/images/published/mysql-vstudioplugin-3.png \ ../refman-common/images/published/mysql-vstudioplugin-4.png \ ../refman-common/images/published/proxy-architecture.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png \ ../refman-common/information-sources.xml \ ../refman-common/manual-conventions.en.xml \ ../refman-common/maxdb.en.xml \ @@ -920,11 +925,6 @@ ../refman-common/news-mysql-proxy.xml \ ../refman-common/news-vstudioplugin.xml \ ../refman-common/replication-drbd.xml \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ ../refman-common/urls.ent \ ../refman-common/what-is-mysql-ab.en.xml \ ../refman-common/what-is.en.xml \ @@ -1020,6 +1020,7 @@ ../refman-common/images/published/cnet-win-install-step3.png \ ../refman-common/images/published/cnet-win-install-step4.png \ ../refman-common/images/published/drbd-main.png \ + ../refman-common/images/published/multi-db.png \ ../refman-common/images/published/myaccess-odbc.png \ ../refman-common/images/published/myaccess.png \ ../refman-common/images/published/myarchitecture.png \ @@ -1064,11 +1065,10 @@ ../refman-common/images/published/mysql-vstudioplugin-3.png \ ../refman-common/images/published/mysql-vstudioplugin-4.png \ ../refman-common/images/published/proxy-architecture.png \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png \ images/cluster-components-1.png \ images/cluster-upgrade-downgrade-table.png \ images/multi-comp-1.png \ @@ -1492,20 +1492,20 @@ replication_solutions_INCLUDES = \ ../common/fixedchars.ent \ ../common/phrases.ent \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png \ ../refman-common/urls.ent \ all-entities.ent \ versions.ent replication_solutions_IMAGES = \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png replication_solutions_SOURCES = replication-solutions.xml $(replication_solutions_INCLUDES) replication_solutions_IDMAPS = \ metadata/client-utility-programs.idmap \ @@ -1524,11 +1524,11 @@ replication_INCLUDES = \ ../common/fixedchars.ent \ ../common/phrases.ent \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png \ ../refman-common/urls.ent \ all-entities.ent \ replication-configuration.xml \ @@ -1537,11 +1537,11 @@ replication-solutions.xml \ versions.ent replication_IMAGES = \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png replication_SOURCES = replication.xml $(replication_INCLUDES) replication_IDMAPS = \ ../refman-common/metadata/bug-reports.idmap \ Modified: trunk/refman-5.0/replication-solutions.xml =================================================================== --- trunk/refman-5.0/replication-solutions.xml 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.0/replication-solutions.xml 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 5, Lines Added: 5, Lines Deleted: 5; 1920 bytes @@ -471,7 +471,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/scaleout.png" + fileref="../refman-common/images/published/scaleout.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -575,7 +575,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/multi-db.png" + fileref="../refman-common/images/published/multi-db.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -706,7 +706,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/submaster-performance.png" + fileref="../refman-common/images/published/submaster-performance.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -852,7 +852,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/redundancy-before.png" + fileref="../refman-common/images/published/redundancy-before.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -956,7 +956,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/redundancy-after.png" + fileref="../refman-common/images/published/redundancy-after.png" format="PNG" lang="en"/> </imageobject> <textobject> Modified: trunk/refman-5.0/replication-topology.xml =================================================================== --- trunk/refman-5.0/replication-topology.xml 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.0/replication-topology.xml 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 5, Lines Added: 5, Lines Deleted: 5; 1865 bytes @@ -38,7 +38,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/slave-single.png" + fileref="../refman-common/images/published/slave-single.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -62,7 +62,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/slaves-multiple.png" + fileref="../refman-common/images/published/slaves-multiple.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -86,7 +86,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/twinmaster.png" + fileref="../refman-common/images/published/twinmaster.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -201,7 +201,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/multimaster-circular.png" + fileref="../refman-common/images/published/multimaster-circular.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -247,7 +247,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/multimaster-chain.png" + fileref="../refman-common/images/published/multimaster-chain.png" format="PNG" lang="en"/> </imageobject> <textobject> Modified: trunk/refman-5.1/Makefile.depends =================================================================== --- trunk/refman-5.1/Makefile.depends 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.1/Makefile.depends 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 8, Lines Added: 30, Lines Deleted: 30; 6268 bytes @@ -915,6 +915,7 @@ ../refman-common/images/published/cnet-win-install-step3.png \ ../refman-common/images/published/cnet-win-install-step4.png \ ../refman-common/images/published/drbd-main.png \ + ../refman-common/images/published/multi-db.png \ ../refman-common/images/published/myaccess-odbc.png \ ../refman-common/images/published/myaccess.png \ ../refman-common/images/published/myarchitecture.png \ @@ -959,7 +960,11 @@ ../refman-common/images/published/mysql-vstudioplugin-3.png \ ../refman-common/images/published/mysql-vstudioplugin-4.png \ ../refman-common/images/published/proxy-architecture.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ ../refman-common/images/published/se-federated-structure.png \ + ../refman-common/images/published/submaster-performance.png \ ../refman-common/information-sources.xml \ ../refman-common/manual-conventions.en.xml \ ../refman-common/maxdb.en.xml \ @@ -971,11 +976,6 @@ ../refman-common/news-mysql-proxy.xml \ ../refman-common/news-vstudioplugin.xml \ ../refman-common/replication-drbd.xml \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ ../refman-common/urls.ent \ ../refman-common/what-is-mysql-ab.en.xml \ ../refman-common/what-is.en.xml \ @@ -1064,6 +1064,7 @@ ../refman-common/images/published/cnet-win-install-step3.png \ ../refman-common/images/published/cnet-win-install-step4.png \ ../refman-common/images/published/drbd-main.png \ + ../refman-common/images/published/multi-db.png \ ../refman-common/images/published/myaccess-odbc.png \ ../refman-common/images/published/myaccess.png \ ../refman-common/images/published/myarchitecture.png \ @@ -1108,12 +1109,11 @@ ../refman-common/images/published/mysql-vstudioplugin-3.png \ ../refman-common/images/published/mysql-vstudioplugin-4.png \ ../refman-common/images/published/proxy-architecture.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ ../refman-common/images/published/se-federated-structure.png \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ + ../refman-common/images/published/submaster-performance.png \ images/cluster-circular-replication-1.png \ images/cluster-circular-replication-2.png \ images/cluster-components-1.png \ @@ -1457,20 +1457,20 @@ replication_solutions_INCLUDES = \ ../common/fixedchars.ent \ ../common/phrases.ent \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png \ ../refman-common/urls.ent \ all-entities.ent \ versions.ent replication_solutions_IMAGES = \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png replication_solutions_SOURCES = replication-solutions.xml $(replication_solutions_INCLUDES) replication_solutions_IDMAPS = \ metadata/client-utility-programs.idmap \ @@ -1489,11 +1489,11 @@ replication_INCLUDES = \ ../common/fixedchars.ent \ ../common/phrases.ent \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png \ + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png \ ../refman-common/urls.ent \ all-entities.ent \ replication-configuration.xml \ @@ -1502,11 +1502,11 @@ replication-solutions.xml \ versions.ent replication_IMAGES = \ - ../refman-common/replication-graphics/multi-db.png \ - ../refman-common/replication-graphics/redundancy-after.png \ - ../refman-common/replication-graphics/redundancy-before.png \ - ../refman-common/replication-graphics/scaleout.png \ - ../refman-common/replication-graphics/submaster-performance.png + ../refman-common/images/published/multi-db.png \ + ../refman-common/images/published/redundancy-after.png \ + ../refman-common/images/published/redundancy-before.png \ + ../refman-common/images/published/scaleout.png \ + ../refman-common/images/published/submaster-performance.png replication_SOURCES = replication.xml $(replication_INCLUDES) replication_IDMAPS = \ ../refman-common/metadata/bug-reports.idmap \ Modified: trunk/refman-5.1/replication-notes.xml =================================================================== --- trunk/refman-5.1/replication-notes.xml 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.1/replication-notes.xml 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 1, Lines Added: 245, Lines Deleted: 0; 7308 bytes @@ -228,6 +228,251 @@ </section> + <section id="replication-features-create-select"> + + <title>Replication of <literal>CREATE TABLE ... SELECT</literal> Statements</title> + + <para> + The following rules and decisions are applied when a + <literal>CREATE TABLE ... SELECT</literal> statement is + replicated: + </para> + + <itemizedlist> + + <listitem> + <para> + All <literal>CREATE TABLE ... SELECT</literal> statements do + implicit commit. + </para> + </listitem> + + <listitem> + <para> + If there are no failures, then all <literal>CREATE TABLE ... + SELECT</literal> statements are replicated as follows: + </para> + + <itemizedlist> + + <listitem> + <para> + For <literal>STATEMENT</literal> and + <literal>MIXED</literal> format, as the <literal>CREATE + TABLE ... SELECT</literal> statement itself. + </para> + </listitem> + + <listitem> + <para> + For <literal>ROW</literal> format, as a <literal>CREATE + TABLE</literal> statement followed by binwrite events. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + Requirements for <literal>CREATE TABLE t2 SELECT + ...</literal> using both transactional and non-transactional + tables: + </para> + + <itemizedlist> + + <listitem> + <para> + For <literal>STATEMENT</literal>, + <literal>MIXED</literal>, and <literal>ROW</literal> + formats: + </para> + + <itemizedlist> + + <listitem> + <para> + If the table already exists, then the statement does + nothing on the master, and only the implicit commit + is logged. + </para> + </listitem> + + <listitem> + <para> + If other execution failure (and thus + <literal>t2</literal> did not exist), then the table + is never created on master and only the implicit + commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + Requirements for <literal>CREATE TABLE IF NOT EXISTS t2 + SELECT ...</literal> + </para> + + <itemizedlist> + + <listitem> + <para> + For <literal>STATEMENT</literal> and + <literal>MIXED</literal> format: + </para> + + <para> + If execution failure, then statement is logged with + error code. + </para> + </listitem> + + <listitem> + <para> + For <literal>ROW</literal> format when t2 is + transactional: + </para> + + <itemizedlist> + + <listitem> + <para> + If table already exists, then + </para> + + <itemizedlist> + + <listitem> + <para> + The <literal>CREATE TABLE</literal> part of the + statement is not logged. + </para> + </listitem> + + <listitem> + <para> + All applied rows are logged. + </para> + </listitem> + + <listitem> + <para> + The implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + If other failure in creating table, then only the + implicit commit is logged. + </para> + </listitem> + + <listitem> + <para> + If failure in selecting or inserting (but create + succeeded), then the table is dropped on master and + only the implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + For <literal>ROW</literal> format when t2 is + non-transactional: + </para> + + <itemizedlist> + + <listitem> + <para> + If table already exists, then: + </para> + + <itemizedlist> + + <listitem> + <para> + the <literal>CREATE TABLE</literal> part of the + statement is not logged. + </para> + </listitem> + + <listitem> + <para> + All applied rows are logged. + </para> + </listitem> + + <listitem> + <para> + The implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + If other failure in creating table, then only the + implicit commit is logged. + </para> + </listitem> + + <listitem> + <para> + If failure in selecting or inserting (but create + succeeded), then: + </para> + + <itemizedlist> + + <listitem> + <para> + The <literal>CREATE TABLE</literal> part of the + statement is logged. + </para> + </listitem> + + <listitem> + <para> + All applied rows are logged. + </para> + </listitem> + + <listitem> + <para> + The implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + + </section> + <section id="replication-features-directory"> <title>Replication and <literal>DIRECTORY</literal> Statements</title> Modified: trunk/refman-5.1/replication-solutions.xml =================================================================== --- trunk/refman-5.1/replication-solutions.xml 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.1/replication-solutions.xml 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 5, Lines Added: 5, Lines Deleted: 5; 1920 bytes @@ -471,7 +471,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/scaleout.png" + fileref="../refman-common/images/published/scaleout.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -575,7 +575,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/multi-db.png" + fileref="../refman-common/images/published/multi-db.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -706,7 +706,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/submaster-performance.png" + fileref="../refman-common/images/published/submaster-performance.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -852,7 +852,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/redundancy-before.png" + fileref="../refman-common/images/published/redundancy-before.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -956,7 +956,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/redundancy-after.png" + fileref="../refman-common/images/published/redundancy-after.png" format="PNG" lang="en"/> </imageobject> <textobject> Modified: trunk/refman-5.1/replication-topology.xml =================================================================== --- trunk/refman-5.1/replication-topology.xml 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.1/replication-topology.xml 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 5, Lines Added: 5, Lines Deleted: 5; 1865 bytes @@ -38,7 +38,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/slave-single.png" + fileref="../refman-common/images/published/slave-single.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -62,7 +62,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/slaves-multiple.png" + fileref="../refman-common/images/published/slaves-multiple.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -86,7 +86,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/twinmaster.png" + fileref="../refman-common/images/published/twinmaster.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -201,7 +201,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/multimaster-circular.png" + fileref="../refman-common/images/published/multimaster-circular.png" format="PNG" lang="en"/> </imageobject> <textobject> @@ -247,7 +247,7 @@ <mediaobject> <imageobject> <imagedata - fileref="../refman-common/replication-graphics/multimaster-chain.png" + fileref="../refman-common/images/published/multimaster-chain.png" format="PNG" lang="en"/> </imageobject> <textobject> Modified: trunk/refman-5.2/replication-notes.xml =================================================================== --- trunk/refman-5.2/replication-notes.xml 2007-09-06 13:07:47 UTC (rev 7725) +++ trunk/refman-5.2/replication-notes.xml 2007-09-06 13:07:57 UTC (rev 7726) Changed blocks: 1, Lines Added: 245, Lines Deleted: 0; 7308 bytes @@ -228,6 +228,251 @@ </section> + <section id="replication-features-create-select"> + + <title>Replication of <literal>CREATE TABLE ... SELECT</literal> Statements</title> + + <para> + The following rules and decisions are applied when a + <literal>CREATE TABLE ... SELECT</literal> statement is + replicated: + </para> + + <itemizedlist> + + <listitem> + <para> + All <literal>CREATE TABLE ... SELECT</literal> statements do + implicit commit. + </para> + </listitem> + + <listitem> + <para> + If there are no failures, then all <literal>CREATE TABLE ... + SELECT</literal> statements are replicated as follows: + </para> + + <itemizedlist> + + <listitem> + <para> + For <literal>STATEMENT</literal> and + <literal>MIXED</literal> format, as the <literal>CREATE + TABLE ... SELECT</literal> statement itself. + </para> + </listitem> + + <listitem> + <para> + For <literal>ROW</literal> format, as a <literal>CREATE + TABLE</literal> statement followed by binwrite events. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + Requirements for <literal>CREATE TABLE t2 SELECT + ...</literal> using both transactional and non-transactional + tables: + </para> + + <itemizedlist> + + <listitem> + <para> + For <literal>STATEMENT</literal>, + <literal>MIXED</literal>, and <literal>ROW</literal> + formats: + </para> + + <itemizedlist> + + <listitem> + <para> + If the table already exists, then the statement does + nothing on the master, and only the implicit commit + is logged. + </para> + </listitem> + + <listitem> + <para> + If other execution failure (and thus + <literal>t2</literal> did not exist), then the table + is never created on master and only the implicit + commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + Requirements for <literal>CREATE TABLE IF NOT EXISTS t2 + SELECT ...</literal> + </para> + + <itemizedlist> + + <listitem> + <para> + For <literal>STATEMENT</literal> and + <literal>MIXED</literal> format: + </para> + + <para> + If execution failure, then statement is logged with + error code. + </para> + </listitem> + + <listitem> + <para> + For <literal>ROW</literal> format when t2 is + transactional: + </para> + + <itemizedlist> + + <listitem> + <para> + If table already exists, then + </para> + + <itemizedlist> + + <listitem> + <para> + The <literal>CREATE TABLE</literal> part of the + statement is not logged. + </para> + </listitem> + + <listitem> + <para> + All applied rows are logged. + </para> + </listitem> + + <listitem> + <para> + The implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + If other failure in creating table, then only the + implicit commit is logged. + </para> + </listitem> + + <listitem> + <para> + If failure in selecting or inserting (but create + succeeded), then the table is dropped on master and + only the implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + For <literal>ROW</literal> format when t2 is + non-transactional: + </para> + + <itemizedlist> + + <listitem> + <para> + If table already exists, then: + </para> + + <itemizedlist> + + <listitem> + <para> + the <literal>CREATE TABLE</literal> part of the + statement is not logged. + </para> + </listitem> + + <listitem> + <para> + All applied rows are logged. + </para> + </listitem> + + <listitem> + <para> + The implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> + If other failure in creating table, then only the + implicit commit is logged. + </para> + </listitem> + + <listitem> + <para> + If failure in selecting or inserting (but create + succeeded), then: + </para> + + <itemizedlist> + + <listitem> + <para> + The <literal>CREATE TABLE</literal> part of the + statement is logged. + </para> + </listitem> + + <listitem> + <para> + All applied rows are logged. + </para> + </listitem> + + <listitem> + <para> + The implicit commit is logged. + </para> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + </listitem> + + </itemizedlist> + + </section> + <section id="replication-features-directory"> <title>Replication and <literal>DIRECTORY</literal> Statements</title>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r7726 - in trunk: refman-5.0 refman-5.1 refman-5.2 | mcbrown | 6 Sep |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.869 sec. using MySQL 5.1.14-beta-log