Get the app
Software Engineers
Software Engineers
on
SqueakyPotato
SqueakyPotato
Piqyu

Migrating database from local machine to Cloud

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.

23mo ago
Jobs
One interview, 1000+ job opportunities
Take a 10-min AI interview to qualify for numerous real jobs auto-matched to your profile 🔑
+322 new users this month
WigglyPotato
WigglyPotato
Zepto23mo

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

SillyMochi
SillyMochi
Stealth23mo

Take a dump first 🙃

WigglyPotato
WigglyPotato
Zepto23mo

🤦‍♂️ its SQL dump

SquishyQuokka
SquishyQuokka
Gojek23mo

Any Cloud provider should be fine in this tbh.

Can explore Azure or AWS. See where you can get the most credits.

JumpyPotato
JumpyPotato
Cred23mo

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

Discover more
Curated from across