7.2.3. Batch Applier Setup

Here is how to set up on MySQL. For more information on specific data warehouse types, refer to Chapter 2, Deployment.

  1. Enable row replication on the MySQL master using set global binlog_format=row or by updating my.cnf.

  2. Ensure that you are operating using GMT throughout your source and target database.

  3. Install using the --batch-enabled=true option. Here's a typical installation command using tpm:.

    shell> ./tools/tpm batch
    --cluster-hosts=logos1,logos2 \
    --master-host=logos1  \
    --datasource-user=tungsten  \
    --datasource-password=secret  \
    --batch-enabled=true \
    --batch-load-template=mysql \
    --svc-extractor-filters=colnames,pkey \
    --property=replicator.filter.pkey.addPkeyToInserts=true \
    --property=replicator.filter.pkey.addColumnsToDeletes=true \
    --install-directory=/opt/continuent \
    --channels=1 \
    --buffer-size=1000 \
    --mysql-use-bytes-for-string=false \
    --skip-validation-check=MySQLConfigFileCheck \
    --skip-validation-check=MySQLExtractorServerIDCheck \
    --skip-validation-check=MySQLApplierServerIDCheck \
    --svc-parallelization-type=disk
    --start-and-report

The description of each of the options is shown below; click the icon to hide this detail:

Click the icon to show a detailed description of each argument.

There are a number of important options for batch loading.

You may force additional parameter settings using --property flags if necessary.