Amazon’s Relational Database Service (RDS) is a managed database service provided by AWS. As such, it’s a perfect solution to store and organize your data in a SQL database in the cloud.
However, you should back up your databases regularly to ensure reliability. When it comes to backing up your AWS RDS and getting the most from the platform, SimpleBackups is the perfect solution.
This post will show you a step-by-step guide to backing up your RDS MySQL database using SimpleBackups.
Before you get started, you’ll need your RDS connection credentials. These will allow you to enable remote MySQL connections for AWS RDS. You’ll first go to your Databases page on your AWS RDS account to get these credentials.
On this page, you’ll see a list of your database instances. You can then choose your RDS database from the list of instances.
Once you’ve clicked on the database instance, a page will open where you’ll find the information for your database.
From here, you’ll need a few pieces of information. First, you’ll need the endpoint and the port of your database. You can get this information under the Connectivity & Security tab.
You’ll also need the database name and username. You can get these under the Configuration tab.
Once you’ve obtained your RDS connection credentials, you can set up your backup in SimpleBackups.
The first step is logging into your SimpleBackups account.
You have a few options for creating a MySQL backup on your dashboard.
You can either click on Backups in the menu bar, click Create on the MySQL Backup tile, or click on Database backup in the right menu.
If you click on the Backups option in the menu bar, you’ll be taken to another screen which displays a list of your backups. To get started, you can then click Create Backup.
No matter which option you choose, you’ll get to a screen where you can configure and create your backup. On this screen, you should ensure that the Databases option is selected.
The first step in configuring your backup is deciding which server you want to use.
Here, you have two options:
Apart from choosing one of these options, you should also select if your database is publicly available.
When it comes to RDS, you’ll typically decide whether the database is publicly available when you create it on AWS.
Finally, depending on your unique setup, you might also need to whitelist SimpleBackups’ IP addresses. Doing this allows SimpleBackups to schedule and run your database backups.
The next step is to connect SimpleBackups to your database:
As you can see from the screenshot, you can also choose the type of backups you’d like to run.
For example, you update all your databases at once, store your backups uncompressed to restore backups quicker, stream your backups to your storage to save storage or perform incremental backups to save resources.
Once you’ve provided all the database details and selected the type of backup you’d like, you can click on Validate Connection.
With your database connection set up, you can now perform the final tasks to create your backup.
Firstly, you’ll need to provide a name for your backup.
Next, you can schedule your backups based on your requirements.
For instance, you can run your backups on demand. You can also run them daily, weekly, or monthly at specified times. It’s also possible to define a custom backup schedule, which allows you to schedule backup intervals of as little as 1 minute.
At this stage, you should also set your backup’s Retention. This is the number of recent backups that you’ll keep. If you reach this threshold, older backups will automatically be deleted.
The final step in creating an RDS backup is choosing your storage. Choose if you’d like to use your own remote storage or SimpleBackups’ storage solution, SimpleStorage.
If you choose to use your own remote storage, you can choose from several options, including Amazon S3, Dropbox, Google Cloud Storage, DigitalOcean Spaces, and more.
To add your storage, you’ll click on the Connect storage button.
Provide the credentials for your storage to connect it to SimpleBackups and the path where you’d like your backups to be stored.
Once you’ve chosen and configured your storage, you can click on Create Backup.
Make sure you can always recover quickly should disaster strike. You don’t even need your own server! And if you’re looking for more robust solutions, SimpleBackups allows you to back up servers and files, replicate your storage across different storage solutions, and get server and volume snapshots.
Free 7-day trial. No credit card required.
Have a question? Need help getting started?
Get in touch via chat or at [email protected]