Address review comments in #1712 #5833
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: "MySQL: Migration Tests" | |
| on: | |
| push: | |
| branches: ['main'] | |
| pull_request: | |
| branches: ['main'] | |
| jobs: | |
| run-mysql-migration-tests: | |
| strategy: | |
| matrix: | |
| version: [2.21.1.0-b271, 2024.1.1.0-b137, 2.20.5.0-b72] | |
| BETA_FAST_DATA_EXPORT: [0, 1] | |
| env: | |
| BETA_FAST_DATA_EXPORT: ${{ matrix.BETA_FAST_DATA_EXPORT }} | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - uses: actions/setup-java@v3 | |
| # https://github.com/actions/setup-java | |
| with: | |
| distribution: "temurin" | |
| java-version: "17" | |
| check-latest: true | |
| - name: Cache local Maven repository | |
| uses: actions/cache@v3 | |
| with: | |
| path: ~/.m2/repository | |
| key: ${{ runner.os }}-maven-${{ hashFiles('**/pom.xml') }} | |
| restore-keys: | | |
| ${{ runner.os }}-maven- | |
| - name: Install python3 and psycopg2 | |
| run: | | |
| sudo apt install -y python3 | |
| sudo apt install -y libpq-dev | |
| sudo pip3 install psycopg2 | |
| - name: Run installer script to setup voyager | |
| run: | | |
| yes | ./installer_scripts/install-yb-voyager --install-from-local-source | |
| env: | |
| ON_INSTALLER_ERROR_OUTPUT_LOG: Y | |
| DEBEZIUM_VERSION: aneesh_ff-fb-remove | |
| DEBEZIUM_RELEASE_TAG: voyager-debezium | |
| - name: Start MySQL | |
| run: | | |
| sudo /etc/init.d/mysql start | |
| sleep 10 | |
| - name: Test MySQL connection | |
| run: | | |
| mysql -uroot -proot -e 'select version();' | |
| - name: Create MySQL user | |
| run: | | |
| ./migtests/scripts/mysql/create_mysql_user | |
| - name: Start YugabyteDB cluster | |
| run: | | |
| docker pull yugabytedb/yugabyte:${{ matrix.version }} | |
| VERSION=${{ matrix.version }} docker compose -f migtests/setup/yb-docker-compose.yaml up -d | |
| sleep 20 | |
| - name: Test YugabyteDB connection | |
| run: | | |
| psql "postgresql://yugabyte:@127.0.0.1:5433/yugabyte" -c "SELECT version();" | |
| - name: Create YugabyteDB user | |
| run: | | |
| ./migtests/scripts/yugabytedb/create_yb_user | |
| - name: Enable yb-tserver-n1 name resolution | |
| run: | | |
| echo "127.0.0.1 yb-tserver-n1" | sudo tee -a /etc/hosts | |
| psql "postgresql://yugabyte@yb-tserver-n1:5433/yugabyte" -c "SELECT version();" | |
| - name: "TEST: mysql-table-list-flags-test (table-list and exclude-table-list)" | |
| run: migtests/scripts/run-test.sh mysql/table-list-flags-tests | |
| - name: "TEST: mysql-table-list-file-path-test (table-list-file-path and exclude-table-list-file-path)" | |
| run: migtests/scripts/run-test.sh mysql/table-list-flags-tests env-file-path-flags.sh | |
| - name: "TEST: mysql-sakila" | |
| run: migtests/scripts/run-test.sh mysql/sakila | |
| - name: "TEST: mysql-datatypes" | |
| run: migtests/scripts/run-test.sh mysql/datatypes | |
| - name: "TEST: mysql-constraints" | |
| run: migtests/scripts/run-test.sh mysql/constraints | |
| - name: "TEST: mysql-case-indexes" | |
| run: migtests/scripts/run-test.sh mysql/indexes | |
| - name: "TEST: mysql-functions" | |
| run: migtests/scripts/run-test.sh mysql/functions | |
| - name: "TEST: mysql-case-sequences" | |
| run: migtests/scripts/run-test.sh mysql/sequences | |
| - name: "TEST: mysql-triggers-procedures" | |
| run: migtests/scripts/run-test.sh mysql/triggers-procedures | |
| - name: "TEST: mysql-case-views" | |
| run: migtests/scripts/run-test.sh mysql/views | |
| - name: "TEST: mysql-partitions" | |
| run: migtests/scripts/run-test.sh mysql/partitions | |
| - name: "TEST: mysql-sample-chinook" | |
| run: migtests/scripts/run-test.sh mysql/chinook | |
| - name: "TEST: mysql-misc-tests" | |
| run: migtests/scripts/run-test.sh mysql/misc-tests | |
| - name: "TEST: mysql-case-sensitivity-reserved-words" | |
| run: migtests/scripts/run-test.sh mysql/case-sensitivity-reserved-words | |
| # Placeholder for now so that a basic test can run | |
| - name: Create the live migration user | |
| run: | | |
| mysql -uroot -proot -e 'GRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'ybvoyager'@'127.0.0.1';' | |
| - name: "TEST: mysql-live-migration-test" | |
| run: migtests/scripts/live-migration-run-test.sh mysql/basic-live-test |