Get the app
Software Engineers
Software Engineers
on
SqueakyPotato
SqueakyPotato
26mo
by
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.

26mo ago
WigglyPotato
WigglyPotato
Zepto
26mo

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
Stealth
26mo

Take a dump first 🙃

WigglyPotato
WigglyPotato
Zepto
26mo

🤦‍♂️ its SQL dump

SquishyQuokka
SquishyQuokka
Gojek
26mo

Any Cloud provider should be fine in this tbh.

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

JumpyPotato
JumpyPotato
Cred
26mo

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