Changeset 5895


Ignore:
Timestamp:
Nov 30, 2011, 2:46:07 PM (10 years ago)
Author:
Nicklas Nordborg
Message:

References #1630: Migrate from MySQL to PostgreSQL

Documentation configuration options for the migration program.

Location:
trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/config/dist/base.config

    r5822 r5895  
    271271# ssl.truststore.provider =
    272272
     273# ===================
     274# Migration section
     275# ===================
     276# Configuration settings that are related to migrating a BASE
     277# installation on a MySQL database to a PostgreSQL database.
     278# See documentation for more information.
     279
     280# Enable this flag to compress the exported data. This may increase
     281# performance if disks are slow.
     282# migrate.export.compress = 0
     283
     284# The number of rows that should be fetched at the same time from
     285# the database. Increasing this value may give better performance
     286# but requires more memory.
     287# migrate.export.fetch-size = 20000
     288
     289# Enable this flag to issue an SQL statment for statistical
     290# analysis of the imported data before continuing with the next table.
     291# Disabling this may result in very poor performance.
     292# migrate.import.analyze = 1
     293
     294# Enable this flag to drop the primary key of a table before importing
     295# data to it. This may increase the performance. The primary key is
     296# re-created after the data has been imported.
     297# migrate.import.drop-primary-key = 1
     298
     299# Enable this flag to drop unique constraints and indexes before importing
     300# data. This may increase the performance. The constraints and indexes
     301# are re-created after the data has been imported. NOTE! Foreign key
     302# constraints are not affected by this flag, since they must always be dropped.
     303# migrate.import.drop-constraints = 1
     304
     305
  • trunk/doc/src/docbook/admin/installation.xml

    r5890 r5895  
    15561556            </listitem>
    15571557
     1558            <listitem>
     1559              <para>
     1560              Make sure that you have configured migration-specific settings
     1561              in the <filename>base.config</filename> file. In most cases the
     1562              default settings should be good, but if you are experiencing
     1563              performance problems it may be necessary to change some settings.
     1564              See <xref linkend="appendix.base.config.migrate" /> for more
     1565              information.
     1566              </para>
     1567            </listitem>
     1568
    15581569            <listitem>           
    15591570              <para>
     
    15681579                where <replaceable>/path/to/migration/dir</replaceable>
    15691580                is replaced with the path to the working directory created above.
    1570                 Make sure that the directory is empty since existing files will
    1571                 cause the corresponding table to be skipped (useful when debugging).
    15721581                Depending on the size of the BASE installation the export may
    15731582                take a long time.
     
    15761585          </orderedlist>
    15771586         
     1587          <note>
     1588            <para>
     1589              Make sure that the migration working directory is empty to perform
     1590              a full export. Existing files in the directory causes the corresponding
     1591              tables to be skipped. This can be useful when debugging and after a
     1592              server crash, since the export will resume where it stopped. Just make
     1593              sure that the database hasn't been modified in the meantime.
     1594            </para>
     1595          </note>
    15781596          <warning>
    15791597            <para>
     
    15841602            </para>
    15851603          </warning>
    1586 
    15871604        </listitem>
    15881605      </varlistentry>
     
    16671684              Make the corresponding changes in <filename>base.config</filename>
    16681685              so that the BASE installation points to the new database.
     1686              Also, make sure that you have configured migration-specific settings
     1687              in the <filename>base.config</filename> file. In most cases the
     1688              default settings should be good, but if you are experiencing
     1689              performance problems it may be necessary to change some settings.
     1690              See <xref linkend="appendix.base.config.migrate" /> for more
     1691              information.
    16691692              </para>
    16701693            </listitem>
  • trunk/doc/src/docbook/appendix/base.config.xml

    r5822 r5895  
    10641064   
    10651065  </simplesect>
     1066 
     1067  <simplesect id="appendix.base.config.migrate">
     1068    <title>Migration section</title>
     1069   
     1070    <para>
     1071      The settings in this section only affect the migration program that can
     1072      be used to move a BASE installation from a MySQL database to PostgreSQL.
     1073      For more information about this see <xref linkend="installation.migrate" />.
     1074    </para>
     1075   
     1076    <variablelist>
     1077      <varlistentry>
     1078        <term><property>migrate.export.compress</property></term>
     1079        <listitem>
     1080          <para>
     1081            Enable this option
     1082            to compress the data files generated by the export. This may
     1083            improve performance in case disk speed is a limiting factor.
     1084            Default is to not compress.
     1085          </para>
     1086        </listitem>
     1087      </varlistentry>
     1088      <varlistentry>
     1089        <term><property>migrate.export.fetch-size</property></term>
     1090        <listitem>
     1091          <para>
     1092            The number
     1093            of rows that should be fetch at the same time from the database.
     1094            A higher value may increase the performance but uses more
     1095            memory. The default value is 20000.
     1096          </para>
     1097        </listitem>
     1098      </varlistentry>
     1099      <varlistentry>
     1100        <term><property>migrate.import.analyze</property></term>
     1101        <listitem>
     1102          <para>
     1103            Enable this flag to issue an SQL statment for statistical
     1104            analysis of the imported data before continuing with the next
     1105            table. Disabling this may result in very poor performance. This
     1106            option is enabled by default.
     1107          </para>
     1108        </listitem>
     1109      </varlistentry>
     1110 
     1111      <varlistentry>
     1112        <term><property>migrate.import.drop-primary-key</property></term>
     1113        <listitem>
     1114          <para>
     1115            Enable this flag to drop the primary key of a table before
     1116            importing data to it. This may increase the performance. The
     1117            primary key is re-created after the data has been imported.
     1118            This option is enabled by default.
     1119          </para>
     1120        </listitem>
     1121      </varlistentry>
     1122     
     1123      <varlistentry>
     1124        <term><property>migrate.import.drop-constraints</property></term>
     1125        <listitem>
     1126          <para>
     1127            Enable this flag to drop unique constraints and indexes before
     1128            importing data to a table. This may increase the performance.
     1129            The constraints and indexes are re-created after the data has been
     1130            imported. NOTE! Foreign key constraints are not affected by this flag,
     1131            since they must always be dropped. This option is enabled by
     1132            default.
     1133          </para>
     1134        </listitem>
     1135      </varlistentry>
     1136    </variablelist>
     1137   
     1138  </simplesect>
    10661139
    10671140</appendix>
Note: See TracChangeset for help on using the changeset viewer.