Github action needed to take database (running on azure vm) to storage account
Budget: ₹600 – ₹1,100 INR
Scenerio :
have a vm which has a blob fuse mounted on storage account
have a script which have logic to take backup and copy the database into the fuse mount point
this script runs as cron job daily
Already have script : $backupscript.sh
USAGE $ ./backupscript.sh <serverip> <name of db>
Solution Needed
Have a github action to take the entire backup with below steps in workflow
1.Checks out the github which has the backup.sh (already written) script
2.Copy the script in any running path .Say /mnt/workingfusepath
3.Checks if mount path is fully working , if not remount the fuse path (https://learn.microsoft.com/en-us/azure/storage/blobs/storage-how-to-mount-container-linux)
4.Run the backup script ,which was copied in 2 against the name of the database passed by the UI of githib actions.
Eg ./ backscript.sh 10.2.3.1 testdb1
5. The above will create a backupwithcurretndate.testdb1.ta.gz
this will automatically copy the same file via fuse to container .
So in one button click and by selecting db name in the UI was able to take the entire backup to storage account
have a vm which has a blob fuse mounted on storage account
have a script which have logic to take backup and copy the database into the fuse mount point
this script runs as cron job daily
Already have script : $backupscript.sh
USAGE $ ./backupscript.sh <serverip> <name of db>
Solution Needed
Have a github action to take the entire backup with below steps in workflow
1.Checks out the github which has the backup.sh (already written) script
2.Copy the script in any running path .Say /mnt/workingfusepath
3.Checks if mount path is fully working , if not remount the fuse path (https://learn.microsoft.com/en-us/azure/storage/blobs/storage-how-to-mount-container-linux)
4.Run the backup script ,which was copied in 2 against the name of the database passed by the UI of githib actions.
Eg ./ backscript.sh 10.2.3.1 testdb1
5. The above will create a backupwithcurretndate.testdb1.ta.gz
this will automatically copy the same file via fuse to container .
So in one button click and by selecting db name in the UI was able to take the entire backup to storage account