{"id":81,"date":"2026-01-19T17:07:38","date_gmt":"2026-01-19T17:07:38","guid":{"rendered":"https:\/\/ukam-portfolio.com\/?page_id=81"},"modified":"2026-01-28T20:20:20","modified_gmt":"2026-01-28T20:20:20","slug":"database-migration","status":"publish","type":"page","link":"https:\/\/ukam-portfolio.com\/index.php\/database-migration\/","title":{"rendered":"Database Migration"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"81\" class=\"elementor elementor-81\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b8894de e-flex e-con-boxed e-con e-parent\" data-id=\"3b8894de\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7219c434 elementor-widget elementor-widget-text-editor\" data-id=\"7219c434\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>In this lab, a MySQL instance hosted on EC2 was migrated to Aurora RDS for MySQL. In order to accomplish this goal, a replication instance was created to host the migration. Next, two endpoints were created. One to connect the source database, and another to connect the target database. Lastly, a migration task was created to perform the database migration. The results of the migration were verified using MySQL Workbench.<\/p>\n<p><br><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a5b3d17 e-flex e-con-boxed e-con e-parent\" data-id=\"a5b3d17\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cdbeadc elementor-widget elementor-widget-heading\" data-id=\"cdbeadc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Screenshots:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3faacf0 e-grid e-con-boxed e-con e-parent\" data-id=\"3faacf0\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-ef0e7dc e-con-full e-flex e-con e-child\" data-id=\"ef0e7dc\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b86dd4d elementor-widget elementor-widget-image\" data-id=\"b86dd4d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Create replication Instance\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTk4LCJ1cmwiOiJodHRwczpcL1wvdWthbS1wb3J0Zm9saW8uY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI2XC8wMVwvQ3JlYXRlLXJlcGxpY2F0aW9uLUluc3RhbmNlLnBuZyJ9\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"239\" src=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-1024x239.png\" class=\"attachment-large size-large wp-image-198\" alt=\"\" srcset=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-1024x239.png 1024w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-300x70.png 300w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-768x179.png 768w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance.png 1439w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ec0bc17 e-con-full e-flex e-con e-child\" data-id=\"ec0bc17\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1e756fa elementor-widget elementor-widget-image\" data-id=\"1e756fa\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-and-target-endpoints.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Source and target endpoints\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjAwLCJ1cmwiOiJodHRwczpcL1wvdWthbS1wb3J0Zm9saW8uY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI2XC8wMVwvU291cmNlLWFuZC10YXJnZXQtZW5kcG9pbnRzLnBuZyJ9\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"276\" src=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-and-target-endpoints-1024x276.png\" class=\"attachment-large size-large wp-image-200\" alt=\"\" srcset=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-and-target-endpoints-1024x276.png 1024w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-and-target-endpoints-300x81.png 300w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-and-target-endpoints-768x207.png 768w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-and-target-endpoints.png 1431w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e1bb949 e-con-full e-flex e-con e-child\" data-id=\"e1bb949\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3c326d9 elementor-widget elementor-widget-image\" data-id=\"3c326d9\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Create replication Instance\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTk4LCJ1cmwiOiJodHRwczpcL1wvdWthbS1wb3J0Zm9saW8uY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI2XC8wMVwvQ3JlYXRlLXJlcGxpY2F0aW9uLUluc3RhbmNlLnBuZyJ9\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"239\" src=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-1024x239.png\" class=\"attachment-large size-large wp-image-198\" alt=\"\" srcset=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-1024x239.png 1024w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-300x70.png 300w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance-768x179.png 768w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Create-replication-Instance.png 1439w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d357af9 e-flex e-con-boxed e-con e-parent\" data-id=\"d357af9\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-4242202 e-con-full e-flex e-con e-child\" data-id=\"4242202\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-001e753 elementor-widget elementor-widget-image\" data-id=\"001e753\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-Database.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Source Database\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjAxLCJ1cmwiOiJodHRwczpcL1wvdWthbS1wb3J0Zm9saW8uY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI2XC8wMVwvU291cmNlLURhdGFiYXNlLnBuZyJ9\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"862\" height=\"838\" src=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-Database.png\" class=\"attachment-large size-large wp-image-201\" alt=\"\" srcset=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-Database.png 862w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-Database-300x292.png 300w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Source-Database-768x747.png 768w\" sizes=\"(max-width: 862px) 100vw, 862px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3941eb5 e-con-full e-flex e-con e-child\" data-id=\"3941eb5\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5aae52a elementor-widget elementor-widget-image\" data-id=\"5aae52a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Target-Database.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Target Database\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjAyLCJ1cmwiOiJodHRwczpcL1wvdWthbS1wb3J0Zm9saW8uY29tXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDI2XC8wMVwvVGFyZ2V0LURhdGFiYXNlLnBuZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"875\" height=\"842\" src=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Target-Database.png\" class=\"attachment-large size-large wp-image-202\" alt=\"\" srcset=\"https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Target-Database.png 875w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Target-Database-300x289.png 300w, https:\/\/ukam-portfolio.com\/wp-content\/uploads\/2026\/01\/Target-Database-768x739.png 768w\" sizes=\"(max-width: 875px) 100vw, 875px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e05ae12 e-con-full e-flex e-con e-child\" data-id=\"e05ae12\" data-element_type=\"container\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In this lab, a MySQL instance hosted on EC2 was migrated to Aurora RDS for MySQL. In order to accomplish this goal, a replication instance was created to host the migration. Next, two endpoints were created. One to connect the source database, and another to connect the target database. Lastly, a migration task was created [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-81","page","type-page","status-publish","hentry"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/pages\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/comments?post=81"}],"version-history":[{"count":26,"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/pages\/81\/revisions"}],"predecessor-version":[{"id":369,"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/pages\/81\/revisions\/369"}],"wp:attachment":[{"href":"https:\/\/ukam-portfolio.com\/index.php\/wp-json\/wp\/v2\/media?parent=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}