AWS RDS Mariadb Backups

mysql
rds
aws

Backup your RDS Mariadb database to s3 or other providers s3 storage

AWS RDS Mariadb Logo

Description

Backup your RDS Mariadb database to your own S3 storage or make use of SnapShooters storage to add a extra layer of protection


Easy Setup

Easy to get started with SnapShooters RDS Mariadb backups, just follow the guide, choose your own server to use as the backup hub or use on of SnapShoots on demand servers to backup your database without having to manage your own servers. Great if your hosting your applications serverless and need backups.

Full MySQLDump backups provide a backup thats no longer limited to AWS and relies on AWS file system snapshot. Perfect if you want downloads you can export to different providers, or even your local machine.


How to Backup your RDS Mariadb database

1 - Login to AWS and view RDS

  • Login to your AWS account and find your database under the RDS service section
  • Locate your RDS MariaDB
  • Click on the database identifiyer

2 - Allow Network Access (optional)

If your using SnapShooters Compute for backups you will need to allow access to the RDS database, if your using your own servers, you need to make sure your own server has its access to RDS and SnapShooter can access that server.

Allow Public Access to RDS MariaDB
  • Press Modify Server
  • Find Connection Tab
  • Press Additional configuration
  • Check Publicly accessible
  • Make RDS MariaDB public
  • Scroll to bottom and press continne
  • Make sure the summary of modifications, only shows public access change, if you see anything else, i.e. master password, go back and reset
  • Change Schedule of modiciations to Apply Immediately
  • Press Modify DB Instance
  • The change should happen quickly
Allow Remote IP Access
  • Go to RDS instance overview screen
  • Find the VPC security group attachment RDS VPC Security Group
  • Press the Security Group link
  • Press Edit Inbound Rules VPC edit inbound rules
  • In SnapShooter Find the IP's you need Compute ip WhiteList
  • Find the region you need, for example if your storage is US East (N. Virgina) SnapShooter US East IP's
  • Add the IP's to AWS
    • Add Rule
    • Type: MySQL/Auora
    • Source: Custom
    • Source: Paste in the IP address, don't forget to add the /32 on the end
    • SnapShooter Firewall
    • Add description if you wish "SnapShooter Compute"
    • Save Rules

3 - Create a new backup job

  • Login to SnapShooter
  • Go to make new backup job Quick Setup and select MariaDB
  • Give it name

4 - Choose Server or SnapShooter Compute

Decide if you want to use your own server for the backup or want to use SnapShooters compute engine, and enjoy 2h worth of backups a month (Easily enough to backup your repo daily for free) https://i.imgur.com/2cBAyfh.png

5 - Configure RDS MariaDB Backup

  • Provide your username
  • Provide your password (feel free to make a new user)
  • Choose hostname
  • Port should remain 3306 unless changed
  • Database name will depend on what Database you want backed up
  • Flags can be left as default unless you have special requirments
  • Compression level is defaulted at 6 which is mid way, increase if you want small backups, but will take longer

Test and configure MariaDB backup

6 - Choose Storage

If you used your own server you can use any storage provide you wish.

If you used SnapShooter Compute you can use your own S3 or you can use SnapShooter Storage which comes with 500mb free.

7 - Choose Backup Frequency

Free users can enjoy daily backups, other paid plans will allow more frequent backups

https://i.imgur.com/gup59am.png

Press schedule and finish

8 - Run your first Backup

Press backup now link

First MariaDB Backup


Related Backup Recipes