Skip to content

added consistent volume for mysql container #6

added consistent volume for mysql container

added consistent volume for mysql container #6

Workflow file for this run

name: Build, Push, and Deploy Docker Compose
on:
push:
branches:
- main
jobs:
build-push-and-deploy:
runs-on: ubuntu-latest
steps:
- name: Checkout repository
uses: actions/checkout@v2
- name: Set up Docker Buildx
uses: docker/setup-buildx-action@v1
- name: Generate .env file
run: |
echo "MYSQL_PORT=${{ secrets.MYSQL_PORT }}" >> .env
echo "MYSQL_HOST=${{ secrets.MYSQL_HOST }}" >> .env
echo "MYSQL_USER=${{ secrets.MYSQL_USER }}" >> .env
echo "MYSQL_PASSWORD=${{ secrets.MYSQL_PASSWORD }}" >> .env
echo "MYSQL_DATABASE=${{ secrets.MYSQL_DATABASE }}" >> .env
echo "DOCKERHUB_USERNAME=${{ secrets.DOCKERHUB_USERNAME }}" >> .env
- name: Build and Push Docker Images
run: |
echo "${{ secrets.DOCKERHUB_TOKEN }}" | docker login -u ${{ secrets.DOCKERHUB_USERNAME }} --password-stdin
docker-compose build
docker-compose push
- name: Deploy to Server
uses: appleboy/ssh-action@master
with:
host: ${{ secrets.SERVER_IP }}
username: ${{ secrets.SERVER_USERNAME }}
key: ${{ secrets.SERVER_SSH_KEY }}
script: |
# Change to the appropriate directory..
cd apps
mkdir shareme
cd shareme
# Pull the Docker Compose project on the remote server
docker pull ${{ secrets.DOCKERHUB_USERNAME }}/shareme:latest
docker pull mysql
rm -rf .env
echo "MYSQL_PORT=${{ secrets.MYSQL_PORT }}" >> .env
echo "MYSQL_HOST=${{ secrets.MYSQL_HOST }}" >> .env
echo "MYSQL_USER=${{ secrets.MYSQL_USER }}" >> .env
echo "MYSQL_PASSWORD=${{ secrets.MYSQL_PASSWORD }}" >> .env
echo "MYSQL_DATABASE=${{ secrets.MYSQL_DATABASE }}" >> .env
echo "DOCKERHUB_USERNAME=${{ secrets.DOCKERHUB_USERNAME }}" >> .env
curl -O -L https://raw.githubusercontent.com/nheek/shareme/main/Dockerfile
curl -O -L https://raw.githubusercontent.com/nheek/shareme/main/docker-compose.yml
mkdir .custom_sql_settings
cd .custom_sql_settings
curl -O -L https://raw.githubusercontent.com/nheek/shareme/main/.custom_sql_settings/my.cnf
cd ..
mkdir .sql_data
cd .sql_data
curl -O -L https://raw.githubusercontent.com/nheek/shareme/main/.sql_data/create_database.sql
docker-compose up -d