Show HN: Databasus – open-source backup tool for PostgreSQL, MySQL and MongoDB

Show HN: Databasus – open-source backup tool for PostgreSQL, MySQL and MongoDB(databasus.com)

10 points by rostislav_dugin 141 days ago | 7 comments

I had a post in the start of December about Postgresus 2.0: self hosted tool for PostgreSQL. Since then the project changed the name and added support of other databases: MySQL, MariaDB and MongoDB.

Website - https://databasus.com

GitHub - https://github.com/databasus/databasus

Main features:

- Scheduled backups for multiple PostgreSQL, MySQL, MariaDB and MongoDB databases

- Storage to S3, Cloudflare R2, Google Drive, Azure Blob, NAS, SFTP, rclone, etc.

- Notifications about backup status via email, Telegram, Slack, Discord, MS Teams and customizable webhooks

- Works with both self-hosted and managed PostgreSQL (RDS, Cloud SQL, etc.)

- Runs as a single Docker container or via Helm on Kubernetes, can be installed via script

- There are workspaces and role-based access with audit logs

vkhafizov 140 days ago |

Nice to see the project evolving beyond PostgreSQL. How does Databasus compare architecturally to tools like pgBackRest or WAL-G for Postgres, or to mysqldump-based solutions for MySQL? In particular, how do these differences affect performance and reliability for backups and restores?

rostislav_dugin 140 days ago | |

Databasus and WAL-G have completely different architectures. WAL-G is installed on the server with DB. Databasus connects to the database remotely.

WAL-G is about PITR backups, Databasus is about logical ones.

From one side, Databasus usually is slower when database is large.

From another side, it's much easier to use (especially when you have a lot of DBs).

In the future, I am considering implementing incremental backups and following a similar approach as WAL-G or pgBackRest do. But it will be one of options, not mandatory one

freakynit 140 days ago |

Wanted something simple like this, but, this seems to place a hard requirement that database to import to should be empty before a restore.

rostislav_dugin 140 days ago | |

Yes

To restore database - it should be empty (otherwise conflicts are possible)

Technically, you can try to restore to filled DB. But don't think it makes sense to try

freakynit 139 days ago | | |

Hmmm... can you not provide such a tool built on top of pgBackRest?

Im using it personally one one of my postgres installations, and it's incredibly simple.

Having web ui built on top would also make it accessible to a lot more people since setting it up the first time is not that trivial.

dmarwicke 140 days ago |

does this do point-in-time recovery? tried like 3 postgres backup tools, they all claim to support it but then you actually need to restore and it's a mess

rostislav_dugin 140 days ago | |

No, it's logical backup (at least, by the time): PITR are complicated in setting up and recovering.