github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/move_table/run.sh (about)

     1  #!/bin/bash
     2  
     3  set -eu
     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  function run() {
    12  
    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 ${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?protocol=open-protocol&partition-num=4&kafka-version=${KAFKA_VERSION}&max-message-bytes=10485760" ;;
    27  	storage) SINK_URI="file://$WORK_DIR/storage_test/$TOPIC_NAME?protocol=canal-json&enable-tidb-extension=true" ;;
    28  	pulsar)
    29  		run_pulsar_cluster $WORK_DIR normal
    30  		SINK_URI="pulsar://127.0.0.1:6650/$TOPIC_NAME?protocol=canal-json&enable-tidb-extension=true"
    31  		;;
    32  	*) SINK_URI="mysql://normal:123456@127.0.0.1:3306/?max-txn-row=1" ;;
    33  	esac
    34  
    35  	run_cdc_cli changefeed create --start-ts=$start_ts --sink-uri="$SINK_URI"
    36  	case $SINK_TYPE in
    37  	kafka) run_kafka_consumer $WORK_DIR "kafka://127.0.0.1:9092/$TOPIC_NAME?protocol=open-protocol&partition-num=4&version=${KAFKA_VERSION}&max-message-bytes=10485760" ;;
    38  	storage) run_storage_consumer $WORK_DIR $SINK_URI "" "" ;;
    39  	pulsar) run_pulsar_consumer --upstream-uri $SINK_URI ;;
    40  	esac
    41  
    42  	run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY --loglevel "debug" --logsuffix "2" --addr 127.0.0.1:8301
    43  	run_cdc_server --workdir $WORK_DIR --binary $CDC_BINARY --loglevel "debug" --logsuffix "3" --addr 127.0.0.1:8302
    44  
    45  	# Add a check table to reduce check time, or if we check data with sync diff
    46  	# directly, there maybe a lot of diff data at first because of the incremental scan
    47  	run_sql "CREATE table move_table.check1(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    48  	check_table_exists "move_table.usertable" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT}
    49  
    50  	cd $CUR
    51  	GO111MODULE=on go run main.go 2>&1 | tee $WORK_DIR/tester.log
    52  	cd $WORK_DIR
    53  
    54  	check_table_exists "move_table.check1" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 300
    55  	check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    56  	run_sql "truncate table move_table.usertable" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    57  	# move back
    58  	cd $CUR
    59  	GO111MODULE=on go run main.go 2>&1 | tee $WORK_DIR/tester.log
    60  	cd $WORK_DIR
    61  	check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    62  	run_sql "CREATE table move_table.check2(id int primary key);" ${UP_TIDB_HOST} ${UP_TIDB_PORT}
    63  	check_table_exists "move_table.check2" ${DOWN_TIDB_HOST} ${DOWN_TIDB_PORT} 300
    64  	check_sync_diff $WORK_DIR $CUR/conf/diff_config.toml
    65  
    66  	cleanup_process $CDC_BINARY
    67  }
    68  
    69  trap stop_tidb_cluster EXIT
    70  run $*
    71  check_logs $WORK_DIR
    72  echo "[$(date)] <<<<<< run test case $TEST_NAME success! >>>>>>"