github.com/pingcap/ticdc@v0.0.0-20220526033649-485a10ef2652/tests/unified_sorter/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  CDC_COUNT=3
    12  DB_COUNT=4
    13  
    14  function run() {
    15      rm -rf $WORK_DIR && mkdir -p $WORK_DIR
    16  
    17      start_tidb_cluster --workdir $WORK_DIR
    18  
    19      cd $WORK_DIR
    20  
    21      start_ts=$(run_cdc_cli tso query --pd=http://$UP_PD_HOST_1:$UP_PD_PORT_1)
    22      run_sql "CREATE DATABASE unified_sort;" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    23      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=unified_sort
    24  
    25      run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY
    26  
    27      TOPIC_NAME="ticdc-sink-retry-test-$RANDOM"
    28      case $SINK_TYPE in
    29          kafka) SINK_URI="kafka://127.0.0.1:9092/$TOPIC_NAME?partition-num=4&max-message-bytes=102400&kafka-version=${KAFKA_VERSION}";;
    30          *) SINK_URI="mysql://normal:123456@127.0.0.1:3306/?max-txn-row=1";;
    31      esac
    32      sort_dir="$WORK_DIR/unified_sort_cache"
    33      mkdir $sort_dir
    34      run_cdc_cli changefeed create --start-ts=$start_ts --sink-uri="$SINK_URI" --sort-engine="unified"
    35      if [ "$SINK_TYPE" == "kafka" ]; then
    36        run_kafka_consumer $WORK_DIR "kafka://127.0.0.1:9092/$TOPIC_NAME?partition-num=4&version=${KAFKA_VERSION}"
    37      fi
    38  
    39      # Add a check table to reduce check time, or if we check data with sync diff
    40      # directly, there maybe a lot of diff data at first because of the incremental scan
    41      run_sql "CREATE table unified_sort.check1(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    42      check_table_exists "unified_sort.USERTABLE" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    43      check_table_exists "unified_sort.check1" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 90
    44      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    45  
    46      run_sql "truncate table unified_sort.USERTABLE" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    47      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    48      run_sql "CREATE table unified_sort.check2(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    49      check_table_exists "unified_sort.check2" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 90
    50      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    51  
    52      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=unified_sort
    53      run_sql "CREATE table unified_sort.check3(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    54      check_table_exists "unified_sort.check3" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 90
    55      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    56  
    57      run_sql "create table unified_sort.USERTABLE2 like unified_sort.USERTABLE" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    58      run_sql "insert into unified_sort.USERTABLE2 select * from unified_sort.USERTABLE" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    59      run_sql "create table unified_sort.check4(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    60      check_table_exists "unified_sort.USERTABLE2" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    61      check_table_exists "unified_sort.check4" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 90
    62  
    63      check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    64  
    65      cleanup_process $CDC_BINARY
    66  }
    67  
    68  trap stop_tidb_cluster EXIT
    69  run $*
    70  check_logs $WORK_DIR
    71  echo "[$(date)] <<<<<< run test case $TEST_NAME success! >>>>>>"