Skip to content

ci: fix HTAP and replication test #26

ci: fix HTAP and replication test

ci: fix HTAP and replication test #26

name: MySQL HTAP MaxScale Test
on:
push:
branches: [ "main" ]
jobs:
htap-test:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v4
# Install dependencies
- name: Install dependencies
run: |
sudo apt-get update
sudo apt-get install -y mysql-client
curl -LJO https://github.com/duckdb/duckdb/releases/latest/download/duckdb_cli-linux-amd64.zip
unzip duckdb_cli-linux-amd64.zip
chmod +x duckdb
sudo mv duckdb /usr/local/bin
- name: Launch HTAP cluster
run: |
cd devtools/htap-setup-mysql/maxscale
docker compose up -d --wait
sleep 10
- name: Verify HTAP setup
run: |
# Save SELECT count before executing the query
docker exec maxscale maxctrl api get servers/myduck-server data.attributes.statistics.total_connections | tee select_count_before.txt
# Execute READ statement
mysql -h127.0.0.1 -P14000 -ulol -plol -e "SELECT * FROM db01.test;"
# Save SELECT count after executing the query
docker exec maxscale maxctrl api get servers/myduck-server data.attributes.statistics.total_connections | tee select_count_after.txt
# Read counts from files
before_count=$(cat select_count_before.txt)
after_count=$(cat select_count_after.txt)
# Calculate the difference
diff=$((after_count - before_count))
# Verify that SELECT count increased by 1
if [ "$diff" -eq 1 ]; then
echo 'HTAP setup verification successful.'
else
echo 'HTAP setup verification failed.'
exit 1
fi
- name: Cleanup
if: always()
run: |
cd devtools/htap-setup-mysql/maxscale
docker compose down