Aiven MySQL
How to backup Managed Neon Postgres databases via SimpleBackups
To create backups for a Aiven-managed MySQL database using SimpleBackups, follow these steps. The process is designed to be straightforward, ensuring that your Aiven MySQL database is securely backed up.
Prerequisites
- A SimpleBackups account.
- Access to your Aiven MySQL service database and permission to create new users/roles.
- Network access from SimpleBackups to your Aiven MySQL database.
Step 1: Create a Backup User in Aiven
- Log in to your Aiven console.
- Navigate to the database service you wish to back up.
- Click on “Overview” then “Connect” or just on the Dashboard, refer to “Connection Details”
- Copy the connection string (make sure you replace the **** by the actual password)
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F877bbb47-2797-4f53-a4ed-4585ee282117%2F96b5f6ff-953b-4bf2-bc28-49c09e20d6f1%2FScreenshot_2024-03-29_at_4.00.48_PM.png?table=block&id=4111fb41-45f3-4d7c-ab11-201b58a6ebdf&cache=v2)
Step 2: Whitelist SimpleBackups IP Addresses
Note: if your database is behind a firewall, follow the following steps.
- In the Aiven console service overview, scroll down to the Allowed IP Addresses section, click on Change
- Add the IP addresses provided by SimpleBackups to the whitelist. This allows SimpleBackups to connect to your database.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F877bbb47-2797-4f53-a4ed-4585ee282117%2Fb2246a12-230e-495f-93de-771104c361e5%2FScreenshot_2024-03-29_at_4.04.23_PM.png?table=block&id=da419a4e-2462-48cc-ab2c-17d12ab23cb3&cache=v2)
Step 3: Create a New Database Backup on SimpleBackups
- Navigate to the "Backups" section and click on "Create Backup."
- Select "Database Backup."
- You may use your own server to dump the backups, but we recommend the “serverless” option.
Step 4: Configure Database Backup Settings
- Choose MySQL as the database type.
- Click “Paste connection string instead”
- Fill in the complete connection string for your Aiven database (make sure the password is added as well and not the asterisks *****)
- Click “Validate Connection”
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F877bbb47-2797-4f53-a4ed-4585ee282117%2F150cb059-8351-4831-8b43-1d4371b34712%2FScreenshot_2024-03-29_at_4.13.51_PM.png?table=block&id=7fa3ab01-bb13-4316-ae4b-c2495dc7c3ff&cache=v2)
Step 5: Schedule and Customize Your Backup
- Set a schedule for your backups according to your needs (e.g., daily, weekly).
- Customize your backup settings, such as retention policies and storage.
![Notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F877bbb47-2797-4f53-a4ed-4585ee282117%2Fe6376737-3a8b-4139-a5d2-7d591cf665a6%2FScreenshot_2024-03-29_at_4.14.25_PM.png?table=block&id=a5c19b68-465c-448d-a020-c0419eac09f9&cache=v2)
Step 6: Save and Activate the Backup
- Review your backup configuration to ensure all details are correct.
- Save your backup configuration. SimpleBackups will automatically start the backup process according to your schedule.
By following these steps, you can ensure that your Aiven-managed PostgreSQL database is securely backed up, protecting your data against accidental loss or corruption.
Did this answer your question?
😞
😐
🤩
Last updated on May 6, 2024