Migrate from Heroku to AWS

one click deploy https //docs microtica com/strapi serverless#ygkqs click the deploy with microtica button below and follow the template steps to migrate your existing heroku application to your aws account this is a step by step tutorial on how to migrate your existing project from heroku to aws, using microtica’s ready made infrastructure and application templates this guide applies to developers that have a running application on heroku with postgresql or mysql database and covers setup of infrastructure on aws importing your existing application migrating postgresql/mysql database from heroku to aw s if you want to deploy a new application on aws, here is a guide on how to create an application from a template 1\ create an eks cluster on aws you can provision a complete kubernetes cloud infrastructure through microtica, or you can connect your existing kubernetes cluster running on basically any cloud provider or on premise microtica k8s is fully integrated with microtica pipelines so you can easily define your automation to build, test and deploy services on kubernetes in one place to create a kubernetes infrastructure on your aws account follow the complete guide below amazon eks docid rujo5jl0abva2gjrlr3y a step by step guide on how to create a kubernetes cluster on your aws account 2\ import your existing app using our templates you can import any application you already have on your git account we support all the popular git providers, like github, gitlab, bitbucket, and codecommit import your repository, select a cluster and deploy your app follow the tutorial below import an existing app docid\ iijdabdzjg masae1p5zh a step by step guide on how to import your existing application and deploy it on aws 3\ migrate database from heroku to aws download all data from the heroku database locally to export the data from your heroku postgres database , create a new backup and download it, using the following commands postgresql heroku pg\ backups\ capture app example app heroku pg\ backups\ download app example app to export the data from your heroku mysql database , dump the heroku database on your local development environment using mysqldump tool mysql mysqldump set gtid purged=off single transaction hhost here uuser here p port here p db name here > heroku db \# set gtid purged=off required property for rds because you don’t have full permission in rds \# single transaction – use to ensure that all of the data loaded from the local database is consistent with a single point in time if there are other processes changing the data while mysqldump is reading it, using this option helps maintain data integrity \# h hostname of the db no space between h and the value \# u – use to specify a user name no space between u and the value \# p mysql port \# p once the command is run you’ll be asked for the db password \# db name here the name of the database you want to download locally if you get this error message " unknown table 'column statistics' in information schema ", add the command column statistics=0 the command adds analyze table statements to the output to generate histogram statistics for dumped tables when the dump file is reloaded if you get this error message " access denied; you need (at least one of) the process privilege(s) for this operation ", add the command no tablespaces the suppresses all create logfile group and create tablespace statements in the output of mysqldump connect to amazon rds database https //docs microtica com/access the rds database to establish a connection between your local development environment and aws please follow the https //docs microtica com/deploy an existing strapi app access the rds database guide once the connection is established, you can proceed with moving the local copy of the data to aws move local database copy to aws load the dump into your amazon rds postgresql using the pg restore http //www postgresql org/docs/current/static/app pgrestore html tool postgresql pg restore verbose clean no acl no owner h localhost u dbuser d strapi latest dump load the dump into your amazon rds mysql database using the http //www postgresql org/docs/current/static/app pgrestore html mysql https //dev mysql com/doc/refman/8 0/en/mysql html tool mysql mysql udbuser h localhost p 3306 p strapi < heroku db