DEV Community

Gregori Piñeres
Gregori Piñeres

Posted on

Automate daily MySQL and PostgreSQL database backups

Introduction

In today's fast-paced digital landscape, the importance of a robust disaster recovery plan cannot be overstated. Yet, it's a facet of business operations that often gets overlooked until it's too late. Picture this: you're running a development agency, managing numerous web applications hosted on EC2 servers or Digital Ocean droplets. The last thing you want is to be caught off guard by data loss due to unforeseen circumstances. That's where a reliable database backup solution becomes your knight in shining armor.

The Solution 💡

Introducing DatabaseBackup.dev – a game-changing, low-cost product designed to streamline database backups for both companies and individuals dealing with MySQL and PostgreSQL databases. Our platform empowers users to effortlessly configure their preferred storage provider – whether it's S3, Google Cloud Storage, Google Drive, or SFTP – and schedule daily, weekly, or monthly backups with just a few clicks.

But we didn't stop there. We understand the importance of user experience, which is why we've invested considerable effort into crafting a sleek, user-friendly interface. Our goal? To deliver a product that's not only simple and affordable but also just works, every single time.

DatabaseBackup.dev Interface

Curious about our development journey? Dive into the behind-the-scenes action in this enlightening Twitter thread.

Security and Storage 🔐

Security is paramount when it comes to handling sensitive data. That's why we've left no stone unturned in ensuring the utmost protection for your information. Our platform leverages advanced encryption techniques, utilizing OpenSSL with AES-256 and AES-128 encryption algorithms, to securely store your database and storage provider credentials. With DatabaseBackup.dev, you can rest easy knowing that your data is in safe hands.

Conclusion

In the ever-evolving digital landscape, a proactive approach to data management is non-negotiable. As the old adage goes, it's better to be safe than sorry. Don't wait until disaster strikes – take charge of your data's destiny today with DatabaseBackup.dev.

Ready to experience peace of mind like never before? Sign up for our free version, allowing you to add a database and storage provider of your choice. Trust us, your future self will thank you. Create an account now at DatabaseBackup.dev.

Top comments (2)

Collapse
 
nicolus profile image
Nicolas Bailly • Edited

Hi,
It looks like a nice product, and I could see myself using the free tier for a personal project for the ease of use.

At work though, it would be a tough sell : I already have pretty much the same functionality with Persona Monitoring and Management, which is free, provides a one click restore option, also has a bunch of monitoring options, and is hosted on our servers. Giving DB access to a SaaS platform is a big no no unless it's very reputable and can be thourougly audited.

Here are a few things that I think you should address if you wanted to make it appealing/usable for enterprises :

  • Have an easy restore feature (Maybe it's there but it's not advertised on the site, and a backup only really exist if you can restore it).
  • Provide data at rest encryption for the backups, you mention the credentials are encrypted, but what about the database itself ? There's no way I'm sending my database on an S3 provider unencrypted.
  • Explain what mechanism is used to make the backup and ensure consistency, and maybe even offer a choice ? A simple "mysqldump" can be fine for a pet project, but when you get to a 100GB database it could take hours and you probaby want to copy the files from the filesystem and then use binary logs to retire to a point in time (like what percona Xtra backup does)
  • If you ever want to appeal to large enterprise clients (or clients who deal with sensitive data), you could consider getting ISO27001 or SOC2 certified. It's probably not worth it though.

All in all, I think the free tier and plus tier make sense for hobbyists and freelancers with clients who don't handle sensitive information, but when you start charging $50 a month without storage people are going to expect more features and guarantees.

Collapse
 
gregorip02 profile image
Gregori Piñeres

Hi,

I appreciate you taking the time to read the post and for providing valuable feedback on the product. As a developer, I understand the importance of being cautious when entering database credentials into any third-party software. Therefore, the focus when promoting the product is to clearly highlight the encryption mechanisms implemented.

Regarding future features: restoration, backup encryption and storage for pro level clients are planned in the short term.

This current version of the product is functionally basic. The mechanisms implemented for backups are mysqldump and pg_dump, respectively. The objective is to evaluate its viability and usefulness in the market, also considering open source and self-hosted alternatives. Importantly, in the short term, I do not anticipate having clients with overly large databases. However, if this situation changes, I will have to reconsider the backup methods.