We’ll start by explaining how a MariaDB database stores its data on disk.

You’ll learn how to quickly back up or restore a database by simply copying and pasting the files.

Next, we’ll explore why performing physical backup restorations on a running database server for a single database can be challenging.

We’ll dive into issues like I/O usage, AWS EBS Snapshot performance bottlenecks, and other unexpected problems that can arise. Along the way, we’ll share how we solve each challenge step by step.

Finally, we’ll compare Logical and Physical Backups to help you decide whether the complexity is worth it.