Migrating On-Prem MySQL to Google Cloud SQL | Google Cloud Migration | GCP Database Migration

#devopswithcloud#LearnGCPWithSiva
In this video, we will see How to Migrate On-Premises MySQL to CloudSQL.

[@susantaroy6569]

Thanks for sharing

[@premchandveerapalli3315]

Good one !

[@sivahanuman4466]

Great video 👍

[@nichenametlask]

Informative Siva. Keep doing the great work pls..
Can you also pls do a video on migrating the data from Hadoop On-Premise to Google Cloud? Thank you.

[@niladriduttagupta9124]

Thnks, It was very helpful.
How the on prem db is hosted in a GCP Instance on the first place..? do you have a tutorial for that part..?

[@sandhyasubbareddy7405]

Hi gupta do you have any idea about this if know can you please explain to me

[@mojesbellamkonda9482]

Thank you

[@luisdavidrivero1776]

Very good video friend, can you do the same example but using reverse ssh?

[@rajeshkshirsagar6564]

Hi Shiva,
I want to restore SQL Server .bak file on GCP Cloud SQL instance. Please share me video or steps for the same

[@sagarbhooshan]

Good Video, bookmarked it
By the way, could u explain how we can setup a replication from a mysql on-prem instance to GCP CloudSQL via normal Master-Slave replication, that is without using a Data Migration Profile ? I have a specific use case to migrate MariaDB to CloudSQL countinous replication via binlog and not using GTID.

[@sandhyasubbareddy7405]

Hi devopswithcloud your video is good but I want clear explanation on how you hosted onprem db instance in gcp

[@i27academy]

Hie, i have created a GCE instance and configured MySQL (IAAS). From there migrated to cloud SQL(PSAS) MySQL using DMS

[@anandnerurkar8482]

you are creating vm in GCP , then installing mysql on it, then migrating to cloud sql. but to migrate mysql on premise to google cloud, there may additional steps 1.connectivity between onpremise and GCP, set firewall rules so that DMS job can connect to onprem mysql, google cloud sql, then follow the required process. please suggest me .

[@i27academy]

Hi Anand, yes you can include firewall rules based on what you are implementing. You can you use some hybrid n/w and implement using internal ip too. In this video, i have shown from a vm(iaas) to cloud sql(PAAS) using DMS.

[@anandnerurkar8482]

@@i27academy thank you for this wonderful demo.