Skip to content

Commit 90da67b

Browse files
committed
added README.md
1 parent 982f4e3 commit 90da67b

File tree

1 file changed

+26
-0
lines changed

1 file changed

+26
-0
lines changed
Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
Google Cloud Function - SQL Backup Exporter to GCS
2+
=====================
3+
4+
Triggers GCP [Cloud SQL](https://cloud.google.com/sql) export backups to [GCS](https://cloud.google.com/storage).
5+
6+
Solution documentation:
7+
8+
https://cloud.google.com/solutions/scheduling-cloud-sql-database-exports-using-cloud-scheduler
9+
10+
`main.py` - the code
11+
`requirements.txt` - the pip modules to bootstrap
12+
`deploy.sh` - upload the code and deps
13+
14+
Upload the function to GCF in the current GCP project:
15+
16+
```
17+
./deploy.sh
18+
```
19+
20+
### Solution Dependencies
21+
22+
- [Cloud PubSub](https://cloud.google.com/pubsub) topic must exist
23+
- [Cloud Scheduler](https://cloud.google.com/scheduler) must be set to trigger notifications on schedule for any instances and databases in those instances you want backed up to GCS
24+
- service account with permissions to access [Cloud SQL](https://cloud.google.com/sql) and the [GCS](https://cloud.google.com/storage) bucket
25+
26+
See [DevOps Bash tools] repo which has scripts to idempotently create the service account and permissions, and also set up the [Cloud Scheduler](https://cloud.google.com/scheduler) jobs for every running non-replica instance and database in the current project.

0 commit comments

Comments
 (0)