{"id":75995,"date":"2020-09-25T16:00:50","date_gmt":"2020-09-25T13:00:50","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-migrate-your-database-to-aws-cloudsavvy-it\/"},"modified":"2020-09-25T16:00:50","modified_gmt":"2020-09-25T13:00:50","slug":"how-to-migrate-your-database-to-aws-cloudsavvy-it","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-migrate-your-database-to-aws-cloudsavvy-it\/","title":{"rendered":"#How to Migrate Your Database to AWS \u2013 CloudSavvy IT"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2e208b03117\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2e208b03117\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-migrate-your-database-to-aws-cloudsavvy-it\/#Use_AWSs_Database_Migration_Service\" >Use AWS\u2019s Database Migration Service<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-migrate-your-database-to-aws-cloudsavvy-it\/#Setting_Up_a_Replication_Instance\" >Setting Up a Replication Instance<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-migrate-your-database-to-aws-cloudsavvy-it\/#Setting_Up_the_Endpoints_and_Beginning_the_Transfer\" >Setting Up the Endpoints and Beginning the Transfer<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Migrate Your Database to AWS \u2013 CloudSavvy IT&#8221;<\/strong><\/p>\n<div id=\"article-content-area\">\n<img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-2161 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/8450d8fafc9e33d3309ae0038fe118b5\/p\/uploads\/2019\/10\/ffcebd58.png\" alt=\"Neverending database\" width=\"700\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Database migration can be lengthy and tiresome. AWS provides an easy-to-use service to make the process of modernizing your on-premises or legacy database and moving to AWS\u2019s RDS managed hosting platform easy.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Use_AWSs_Database_Migration_Service\"><\/span>Use AWS\u2019s Database Migration Service<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you have a small database, you might be able to simply take a backup of the database schema and contents using <code>mysqldump<\/code>, create a new RDS instance, then restore from backup by importing the dumped file. This will effectively clone your database, and you\u2019ll be able to switch over to the RDS instance with relative ease.<\/p>\n<p>However, if you have a large database, <code>mysqldump<\/code>\u00a0is not practical to use, and will simply take far too much time. You could just leave it to run for a few days, but the issue there is that any writes made to the source database may not be reflected in the dump file, and you\u2019ll have inconsistencies in the two databases by the end of the process. If you\u2019re transferring over an enterprise production database, this is a massive problem.<\/p>\n<p>The solution is <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/aws.amazon.com\/dms\/?tag=reviewgeek-20\">AWS\u2019s Database Migration Service<\/a>. Once started, DMS will connect to your source and begin syncing all the data to the target database in RDS. Any changes to the source database made during the transfer will be synchronized and reflected in the target database. Even if your data takes many months to transfer to the cloud, you\u2019ll be able to transition to your new database with relative ease.<\/p>\n<p>Database migration uses EC2 Instances to handle the transfer. You have to <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/aws.amazon.com\/dms\/pricing\/?tag=reviewgeek-20\">pay the On-Demand price<\/a> for running these instances as well as any associated storage costs. However, if you\u2019re migrating to an Amazon Aurora, Redshift,\u00a0 DynamoDB, or DocumentDB database, usage of this instance is free for up to six months. Of course, you still incur standard AWS data charges for importing and exporting data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Setting_Up_a_Replication_Instance\"><\/span>Setting Up a Replication Instance<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Head over to the <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"http:\/\/redirect.viglink.com?u=https%3A%2F%2Fconsole.aws.amazon.com%2Fdms&amp;key=204a528a336ede4177fff0d84a044482\">Database Migration Service Management Console<\/a>, and click \u201cCreate Replication Instance.\u201d<\/p>\n<p>Give it a name, and choose the underlying instance type you wish to use. Faster instances will speed up the replication process.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4299\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/ce3bd1ea01e370872ac55629d56d745d\/p\/uploads\/2020\/03\/bd69c76e.png\" alt=\"replication instance settings\" width=\"700\" height=\"382\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select a VPC, and allocate some storage for the instance, mostly used for logs and cache. If you\u2019d like, you can also deploy two replication instances in different AZs, which will be more fault tolerant.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4300\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/bc5736f90ab91857999e647f2f7f2448\/p\/uploads\/2020\/03\/fe06a07b.png\" alt=\"replication instance settings\" width=\"700\" height=\"325\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you\u2019re planning on having this run for a while, you\u2019ll need to allocate a specific time for maintenance, so AWS can perform upgrades and patches to the DMS software.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4301\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/d49fe5687516c5fcfaef342d226b5dc8\/p\/uploads\/2020\/03\/bef5ea89.png\" alt=\"replication instance settings\" width=\"700\" height=\"391\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click create, then wait a few minutes for the replication instance to start up.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Setting_Up_the_Endpoints_and_Beginning_the_Transfer\"><\/span>Setting Up the Endpoints and Beginning the Transfer<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Under \u201cEndpoints\u201d in the sidebar, create a new endpoint. Select \u201cSource\u201d as the type, and under \u201cEndpoint configuration, select the type of database. You\u2019ll need to configure DMS with your database address, port, username, and password.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-4302 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/9e0418615defe39ce783321ff046c902\/p\/uploads\/2020\/03\/f58a0363.png\" alt=\"Setting up and configuring endpoints\" width=\"700\" height=\"676\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Repeat this process for the target endpoint, but this time simply select an RDS instance from the list:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-4303 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/1f8a419854962fed1b52810f5742dd74\/p\/uploads\/2020\/03\/a1026d83.png\" alt=\"Setting up and configuring the target endpoint\" width=\"700\" height=\"293\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Everything is set up, and all that is left is to begin the transfer. Under \u201cDatabase Migration Tasks\u201d in the sidebar, create a new task. Select the replication instance to use, and select the source and target endpoints. If you want everything to continue syncing, make sure to change the migration type to \u201cMigrate existing data and replicate ongoing changes.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-4304 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/bbf6ac953c0ba0b26c8fe1a15c549ccd\/p\/uploads\/2020\/03\/95597aa4.png\" alt=\"Create the new task in Task Configuration\" width=\"700\" height=\"420\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you create the task, the migration should start. You can view the progress from the tasks tab in the console.\n<\/p><\/div>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.cloudsavvyit.com\/4296\/how-to-migrate-your-database-to-aws\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Migrate Your Database to AWS \u2013 CloudSavvy IT&#8221; Database migration can be lengthy and tiresome. AWS provides an easy-to-use service to make the process of modernizing your on-premises or legacy database and moving to AWS\u2019s RDS managed hosting platform easy. Use AWS\u2019s Database Migration Service If you have a small database, you might&#8230;<\/p>\n","protected":false},"author":1,"featured_media":75996,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.cloudsavvyit.com\/p\/uploads\/2019\/10\/ffcebd58.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-75995","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/75995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=75995"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/75995\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/75996"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=75995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=75995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=75995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}