github.com/pingcap/ticdc@v0.0.0-20220526033649-485a10ef2652/tests/move_table/run.sh (about)

     1  #!/bin/bash
     2  
     3  set -e
     4  
     5  CUR=$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )
     6  source $CUR/../_utils/test_prepare
     7  WORK_DIR=$OUT_DIR/$TEST_NAME
     8  CDC_BINARY=cdc.test
     9  SINK_TYPE=$1
    10  
    11  
    12  function run() {
    13      rm -rf $WORK_DIR && mkdir -p $WORK_DIR
    14  
    15      start_tidb_cluster --workdir $WORK_DIR
    16  
    17      cd $WORK_DIR
    18  
    19      start_ts=$(run_cdc_cli tso query --pd=http://$UP_PD_HOST_1:$UP_PD_PORT_1)
    20      run_sql "CREATE DATABASE move_table;" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    21      go-ycsb load mysql -P $CUR/conf/workload -p mysql.host=${UP_TIDB_HOST} -p mysql.port=${UP_TIDB_PORT} -p mysql.user=root -p mysql.db=move_table
    22      run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY --loglevel "debug" --logsuffix "1" --addr 127.0.0.1:8300
    23  
    24      TOPIC_NAME="ticdc-move-table-test-$RANDOM"
    25      case $SINK_TYPE in
    26          kafka) SINK_URI="kafka://127.0.0.1:9092/$TOPIC_NAME?partition-num=4&kafka-version=${KAFKA_VERSION}";;
    27          *) SINK_URI="mysql://normal:123456@127.0.0.1:3306/?max-txn-row=1";;
    28      esac
    29  
    30      run_cdc_cli changefeed create --start-ts=$start_ts --sink-uri="$SINK_URI"
    31      if [ "$SINK_TYPE" == "kafka" ]; then
    32        run_kafka_consumer $WORK_DIR "kafka://127.0.0.1:9092/$TOPIC_NAME?partition-num=4&version=${KAFKA_VERSION}"
    33      fi
    34  
    35      run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY --loglevel "debug" --logsuffix "2" --addr 127.0.0.1:8301
    36      run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY --loglevel "debug" --logsuffix "3" --addr 127.0.0.1:8302
    37  
    38      # Add a check table to reduce check time, or if we check data with sync diff
    39      # directly, there maybe a lot of diff data at first because of the incremental scan
    40      run_sql "CREATE table move_table.check1(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    41      check_table_exists "move_table.USERTABLE" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    42  
    43      cd $CUR
    44      GO111MODULE=on go run main.go 2>&1 | tee $WORK_DIR/tester.log &
    45      cd $WORK_DIR
    46  
    47      check_table_exists "move_table.check1" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 90
    48      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    49      run_sql "truncate table move_table.USERTABLE" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    50      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    51      run_sql "CREATE table move_table.check2(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    52      check_table_exists "move_table.check2" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 90
    53      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    54  
    55      cleanup_process $CDC_BINARY
    56  }
    57  
    58  trap stop_tidb_cluster EXIT
    59  run $*
    60  check_logs $WORK_DIR
    61  echo "[$(date)] <<<<<< run test case $TEST_NAME success! >>>>>>"