need help from DevOps and it people about db restoration

[Cenon]

we currently have a aws rds with mysql 5.7 and need to migrate the databases in to separate database servers (aws ec2 instances)
using proxysql and orchestrator.

is there any idea about moving the data from the prod which is running in aws rds in to mysql instance?
we have scripted everything and optimized to 15 mints downtime but client is not ready for a downtime.

cc @devops @DevOps Engineer @DevOps_Boy

 

[lilman]

chatgpt

pastebin.com/sqCQz4XS

 

[jennt]

replica ekak gahala connection eka eekata switch karala barida?

 

[Don GasCan]

තියන එක වගේම අලුත් එකක් හදපන්
රෙප්ලිකේට් කරපන්
ෆුල් රෙප්ලිකේට් උනාම
අලුත් එකට db එක පොයින්ට් කරපන් ඔෆ් පීක් වෙලාවක .
මයිග්‍රේශන් එක වෙලාවෙත් ඩේටා එනවනම් කිව් එක්කට දාල කට් ඔෆ් එක කරපන්
පරණ එක ඩීකමිශන් කරපන්

 

[LZP1992]

we currently have a aws rds with mysql 5.7 and need to migrate the databases in to separate database servers (aws ec2 instances)
using proxysql and orchestrator.

is there any idea about moving the data from the prod which is running in aws rds in to mysql instance?
we have scripted everything and optimized to 15 mints downtime but client is not ready for a downtime.

cc @devops @DevOps Engineer @DevOps_Boy

reason for move db to a ec2 instance instead of move to separate rds?
If you move to a separate rds AWS DMS is the best solution
But in here..... zero downtime....
Any way get a snapshot before do anything

 

[Cenon]

reason for move db to a ec2 instance instead of move to separate rds?
If you move to a separate rds AWS DMS is the best solution
But in here..... zero downtime....
Any way get a snapshot before do anything

existing data are in RDS, and new data are in mysql ec2 instance.
ill check AWS DMS

 

[snm1990]

bumo

 

[anonymouseninja]

AWS DMS ekka Migration Task ekekin wade goda daganna puluwan but 3-4 minutes wage downtime ekak tye

 

[LZP1992]

AWS DMS ekka Migration Task ekekin wade goda daganna puluwan but 3-4 minutes wage downtime ekak tye

Downtime nathiwa nm amarui

 

[Cenon]

rds to onprem bn, e nisa dms cant use wage bros...

 

[LZP1992]

rds to onprem bn, e nisa dms cant use wage bros...

uba dn ec2 kathawk kiwe
eka onprem nemene

 

[Cenon]

uba dn ec2 kathawk kiwe
eka onprem nemene

na bro, rds to ec2 tyna ekakata danna one.