We have our database and data in MySQL local machine. Monthly data storage and fetch is <1M rows. would like to migrate this to AWS. how do we do this? Would like to explore free credits service provider until we exhaust and explore. Intent to maintain a centralised database and running queries.
Stop application so writes are stopped
Take a dump
Create RDS in AWS or host MYSQL on EC2
Restore dump on AWS RDS/EC2
Point your application to new DB
Start application and make sure new DB is getting connections
Take a dump first 🙃
🤦♂️ its SQL dump
Any Cloud provider should be fine in this tbh.
Can explore Azure or AWS. See where you can get the most credits.
If you don't want to stop your application,
You can start dual writes. Basically writing to both databases.
And then migrate the older data to new db.
And then you can point your reads to new db.
If everything is fine you delete the older db