GH actions trial #2
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: | ||
| common-steps: | ||
| steps: | ||
| - uses: actions/checkout@v3 | ||
| - uses: actions/setup-java@v3 | ||
| # https://github.com/actions/setup-java | ||
| with: | ||
| distribution: 'temurin' | ||
| java-version: '11' | ||
| check-latest: true | ||
| - 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: latest | ||
| 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-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-reserved-words" | ||
| run: migtests/scripts/run-test.sh mysql/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 | ||
| run-mysql-migration-tests-pr: | ||
| if: ${{ github.event_name == 'pull_request' }} | ||
| strategy: | ||
| matrix: | ||
| version: [2.14.10.2-b1,2.17.3.0-b152,2.16.5.0-b24,2.18.1.0-b84] | ||
| BETA_FAST_DATA_EXPORT: [0, 1] | ||
| env: | ||
| BETA_FAST_DATA_EXPORT: ${{ matrix.BETA_FAST_DATA_EXPORT }} | ||
| runs-on: ubuntu-latest | ||
| steps: | ||
| - name: Run common steps | ||
| uses: ./.github/workflows/common-steps | ||
| run-mysql-migration-tests-push: | ||
| if: ${{ github.event_name == 'push' }} | ||
| strategy: | ||
| matrix: | ||
| version: [2.18.1.0-b84] | ||
| BETA_FAST_DATA_EXPORT: [0, 1] | ||
| env: | ||
| BETA_FAST_DATA_EXPORT: ${{ matrix.BETA_FAST_DATA_EXPORT }} | ||
| runs-on: ubuntu-latest | ||
| steps: | ||
| - name: Run common steps | ||
| uses: ./.github/workflows/common-steps | ||
