Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

eskiesirius's avatar

Database Backup Rule

Hello! i am currently using dedicated database of Digital Ocean and it has a standby node. My question now is that, what is the best practice for creating backups? Do i still need to dump the file? How about the binlogs? What are the best config for the database?

EDIT: My app is a Payment gateway, we are now handling large amount of money daily

0 likes
3 replies
imrandevbd's avatar

Since you're running a payment gateway, daily dumps are nowhere near enough. You’re dealing with high-stakes transactional data where even 5 minutes of data loss could be a reconciliation nightmare.

In your position, you need to think about RPO (Recovery Point Objective). If the DB blows up at 11:59 PM, and your last dump was 12:00 AM, can you afford to lose 23 hours of transactions? Probably not.

Please or to participate in this conversation.