Forum Discussion
Jul 22, 2019
AWS RDS MySQL migration to Azure Database for MySQL
Hi, The current setup of MySQL on AWS uses the following features/services, what are the possible ways to address the following requirements without third-party tools/services; A way to exec...
ParikshitSavjani
Jul 25, 2019Former Employee
Azure DB for MySQL service performs automatic backups and allows point in time restore. There is no option for end user to trigger automatic backups but you can trigger a restore to a new server at any time to restore a backup as of specified time. You can do this through ARM templates or REST APIs. If you want, you can also take mysqldump and perform mysql restore using bash script when you want.
2. To perform on-premise restoration, mysqldump/restore is again your best option.
3. To whitelist IP addresses in server firewall to connect to server, you can refer following
https://docs.microsoft.com/en-us/azure/mysql/concepts-firewall-rules