{"id":2358,"date":"2022-12-22T10:18:43","date_gmt":"2022-12-22T10:18:43","guid":{"rendered":"https:\/\/www.easydeploy.io\/blog\/?p=2358"},"modified":"2023-01-12T06:10:46","modified_gmt":"2023-01-12T06:10:46","slug":"upgrade-mysql-version-rds-using-aws-dms","status":"publish","type":"post","link":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/","title":{"rendered":"How to upgrade MySQL version in RDS with zero to minimal downtime using AWS DMS"},"content":{"rendered":"<h2>Introduction<\/h2>\n<ul>\n<li><span style=\"font-weight: 400;\">We can easily Upgrade our <strong>AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 with just modify the DB Instance version<\/strong>. But when you modify your DB instance\u2019s version, it takes the modification time minimum of <strong>15 mins to 4 hours or higher<\/strong>. In real time scenarios it will lead to downtime in our live application at the time of DB upgrading.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Nobody likes interruptions<\/strong>. Here I come with a solution that will give you almost <strong>Zero downtime when upgrading your MySQL RDS Database Instance<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">In this article I will show you how to upgrade your MySQL RDS Database Instance version from<strong> 5.7 to 8.0 or Latest version with Zero downtime using DMS (Data Migration Service)<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>DMS<\/strong> is provided by AWS which helps to Migrate your database from <strong>On-Premise, DB in EC2 Instance<\/strong> or<strong> RDS<\/strong> to the same or any of the types that mentioned above. Let\u2019s get started\u2026<\/span><\/li>\n<\/ul>\n<h2>Create Parameter Groups<\/h2>\n<p><span style=\"font-weight: 400;\">Open your AWS console and search for <strong>RDS<\/strong> and click it.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">On the left side of the <strong>RDS<\/strong> page you can see <strong>parameter groups.<\/strong> Click it again click <strong>Create parameter group<\/strong> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1a.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime create Pg\" class=\"aligncenter wp-image-2252 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime create Pg\" width=\"1877\" height=\"632\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1a.webp 1877w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1a-300x101.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1a-1024x345.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1a-768x259.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1a-1536x517.webp 1536w\" sizes=\"(max-width: 1877px) 100vw, 1877px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Choose the <strong>Parameter group family<\/strong> to <strong>mysql5.7.<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\">Enter <strong>Group name<\/strong> to <strong>mysql-57<\/strong> or whatever you want to provide as your convenience.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Then provide a <strong>description<\/strong> about the parameter group then click <strong>Create.<\/strong><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<blockquote><p>Also Learn: How to setup <a href=\"https:\/\/www.easydeploy.io\/blog\/setup-rds-auto-scaling-in-aws\/\" target=\"_blank\" rel=\"noopener\">RDS auto scaling in AWS\u00a0<\/a><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1b.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime create Parameter group\" class=\"aligncenter wp-image-2253 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime create Parameter group\" width=\"677\" height=\"490\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1b.webp 1017w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1b-300x217.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1b-768x556.webp 768w\" sizes=\"(max-width: 677px) 100vw, 677px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You can see the parameter group could be created.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Select the newly created group click <strong>Parameter group actions<\/strong> followed by <strong>Edit.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1c.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Edit Parameter group 5.7\" class=\"aligncenter wp-image-2254 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Edit Parameter group 5.7\" width=\"1483\" height=\"382\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1c.webp 1483w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1c-300x77.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1c-1024x264.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1c-768x198.webp 768w\" sizes=\"(max-width: 1483px) 100vw, 1483px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Search for <em><strong>binlog_format<\/strong><\/em> and change the <strong>value<\/strong> to <strong>ROW<\/strong> like the picture below.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Click the <strong>Save changes<\/strong> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1d.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Modify Parameter group 5.7\" class=\"aligncenter wp-image-2255 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Modify Parameter group 5.7\" width=\"1466\" height=\"483\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1d.webp 1466w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1d-300x99.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1d-1024x337.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1d-768x253.webp 768w\" sizes=\"(max-width: 1466px) 100vw, 1466px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Create another parameter group with the Parameter group family <strong>mysql8.0.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Group name <strong>mysql-80<\/strong> and give a description and click <strong>Create.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1e.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Edit Parameter group 8.0\" class=\"aligncenter wp-image-2256 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Edit Parameter group 8.0\" width=\"763\" height=\"547\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1e.webp 1037w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1e-300x215.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1e-1024x734.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1e-768x550.webp 768w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Then <strong>Edit<\/strong> the newly created <strong>mysql-80<\/strong> parameter group and search for <em><strong>binlog_format<\/strong><\/em> and change the <strong>value<\/strong> to <strong>ROW<\/strong> then finally click <strong>Save changes.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1f.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Modify Parameter group 8.0\" class=\"aligncenter wp-image-2257 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Modify Parameter group 8.0\" width=\"1473\" height=\"480\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1f.webp 1473w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1f-300x98.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1f-1024x334.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1f-768x250.webp 768w\" sizes=\"(max-width: 1473px) 100vw, 1473px\" \/><\/p>\n<h2>Create RDS Database Instance with MySQL 5.7<\/h2>\n<p><span style=\"font-weight: 400;\">On the left navigation section under the <strong>Amazon RDS<\/strong> Click the <strong>Databases<\/strong> section followed by <strong>Create database.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1g.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database\" class=\"aligncenter wp-image-2258 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database\" width=\"1857\" height=\"467\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1g.webp 1857w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1g-300x75.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1g-1024x258.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1g-768x193.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/1g-1536x386.webp 1536w\" sizes=\"(max-width: 1857px) 100vw, 1857px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Select the <strong>standard create<\/strong> option. <\/span><span style=\"font-weight: 400;\">For Engine choose <strong>MySQL engine.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/2-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Engine\" class=\"aligncenter wp-image-2259 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Engine\" width=\"588\" height=\"490\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/2-4.webp 962w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/2-4-300x250.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/2-4-768x639.webp 768w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">For <strong>MySQL<\/strong> version choose <strong>5.7.34.<\/strong> Because first we are going to create an older version of <strong>MySQL.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">For <strong>Templates<\/strong> choose the <strong>Free tier<\/strong> section. It will reduce the cost for creating a database. Here we are going to create a database for testing purposes only. So free tier is enough for now.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/3-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Engine version\" class=\"aligncenter wp-image-2260 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Engine version\" width=\"729\" height=\"512\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/3-4.webp 950w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/3-4-300x211.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/3-4-768x539.webp 768w\" sizes=\"(max-width: 729px) 100vw, 729px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Under <strong>Settings,<\/strong> for <strong>DB instance identifier<\/strong>, provide a name for your database instance.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For <strong>master username<\/strong> enter <strong><em>admin<\/em><\/strong> and <strong>Master password<\/strong> provide a password for your database username and type the <strong>password again<\/strong> for confirmation.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/4-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database DB Settings\" class=\"aligncenter wp-image-2261 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database DB Settings\" width=\"742\" height=\"554\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/4-4.webp 953w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/4-4-300x224.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/4-4-768x574.webp 768w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Under the <strong>Instance configuration,<\/strong> for <strong>DB Instance class<\/strong> select the least size for this demo.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For <strong>storage<\/strong>\u00a0type choose <strong>gp2<\/strong> and select <strong>10<\/strong> for Allocated storage.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/5-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Instance Config\" class=\"aligncenter wp-image-2262 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Instance Config\" width=\"740\" height=\"580\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/5-4.webp 951w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/5-4-300x235.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/5-4-768x602.webp 768w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">For the <strong>Connectivity<\/strong> section, first select <strong>Don\u2019t connect to an EC2 compute resource<\/strong> option. We can configure it later.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Next the <strong>network-type<\/strong> choose <strong>IPv4,<\/strong> and <strong>VPC,<\/strong> choose any <strong>VPC<\/strong> as you want to use. For myself I choose the <strong>default<\/strong> one.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/6-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Connectivity\" class=\"aligncenter wp-image-2263 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Connectivity\" width=\"717\" height=\"519\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/6-4.webp 955w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/6-4-300x217.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/6-4-768x556.webp 768w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">For the <strong>DB subnet group<\/strong> select <strong>default.<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>Public access,<\/strong> choose <strong>yes.<\/strong> Then only we can connect with our database from outside of the VPC.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Then for the <strong>Security group<\/strong> select the <strong>Create new<\/strong> option and provide a Name for it.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">And choose any of the availability zone that you want.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database DB Network\" class=\"aligncenter wp-image-2264 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database DB Network\" width=\"686\" height=\"516\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7-4.webp 951w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7-4-300x226.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7-4-768x577.webp 768w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Scroll down and expand the <strong>Additional configuration<\/strong> section.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Under the <strong style=\"font-weight: 400;\">DB parameter group<\/strong> choose the parameter group which you create from the beginning of this tutorial for\u00a0<b>MySQL<\/b><b style=\"font-weight: 400;\"> version 5.7<\/b>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7a.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Addtional options\" class=\"aligncenter wp-image-2265 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database Addtional options\" width=\"714\" height=\"389\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7a.webp 886w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7a-300x164.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/7a-768x419.webp 768w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Scroll down to the last, click <strong>Create database.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/8-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database\" class=\"aligncenter wp-image-2266 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Database\" width=\"560\" height=\"333\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/8-4.webp 960w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/8-4-300x178.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/8-4-768x457.webp 768w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now your database is being created. It will take around <strong>10 minutes<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/9-4.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Creating Database\" class=\"aligncenter wp-image-2267 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Creating Database\" width=\"1537\" height=\"592\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/9-4.webp 1537w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/9-4-300x116.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/9-4-1024x394.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/9-4-768x296.webp 768w\" sizes=\"(max-width: 1537px) 100vw, 1537px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">In the meantime we have to modify the <strong>security group<\/strong> which is created by the RDS database.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Go to the <strong>VPC<\/strong> section followed by <strong>security groups<\/strong> section search for the <strong>security group<\/strong> which is created by the RDS.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/10-3.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Security Group\" class=\"aligncenter wp-image-2268 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Security Group\" width=\"1815\" height=\"446\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/10-3.webp 1815w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/10-3-300x74.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/10-3-1024x252.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/10-3-768x189.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/10-3-1536x377.webp 1536w\" sizes=\"(max-width: 1815px) 100vw, 1815px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Select the <strong>security group<\/strong> and select <strong>inbound rules.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Click <strong>Edit inbound rules<\/strong> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/11-3.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Select inbound rules\" class=\"aligncenter wp-image-2269 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Select inbound rules\" width=\"1511\" height=\"278\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/11-3.webp 1511w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/11-3-300x55.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/11-3-1024x188.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/11-3-768x141.webp 768w\" sizes=\"(max-width: 1511px) 100vw, 1511px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You can see a single inbound rule with port range <strong>3306<\/strong> for <strong>mysql<\/strong> database connection.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For source choose <strong>Anywhere<\/strong> and provide <strong>0.0.0.0\/0<\/strong> IP range like the picture below. Then click the <strong>save rules<\/strong> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/12-3.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Edit inbound rules\" class=\"aligncenter wp-image-2270 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Edit inbound rules\" width=\"1783\" height=\"557\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/12-3.webp 1783w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/12-3-300x94.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/12-3-1024x320.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/12-3-768x240.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/12-3-1536x480.webp 1536w\" sizes=\"(max-width: 1783px) 100vw, 1783px\" \/><\/p>\n<h2>Create Tables and add Contents<\/h2>\n<p><span style=\"font-weight: 400;\">After 10 minutes your <strong>MySQL RDS<\/strong> database is successfully created and its status will be <strong>Available.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/13-3.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Available\" class=\"aligncenter wp-image-2271 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Available\" width=\"1490\" height=\"337\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/13-3.webp 1490w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/13-3-300x68.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/13-3-1024x232.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/13-3-768x174.webp 768w\" sizes=\"(max-width: 1490px) 100vw, 1490px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Choose the database that you created now and under the <strong>Connectivity\u00a0&amp; security<\/strong> section you can find the <strong>Endpoint<\/strong> of your database.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/14-3.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Endpoint\" class=\"aligncenter wp-image-2272 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Endpoint\" width=\"740\" height=\"289\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/14-3.webp 1190w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/14-3-300x117.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/14-3-1024x400.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/14-3-768x300.webp 768w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Connect to your <strong>EC2<\/strong> instance via <strong>SSH<\/strong> connection and login as a <strong>root<\/strong> user.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Then run the following command with your main <strong>MySQL database Endpoint.<\/strong><\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">mysql -h &lt;your_main_database_endpoint&gt; -P 3306 -u admin -p<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">It asks for a password and provide the password for the <strong>admin<\/strong> user.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/15-3.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Login\" class=\"aligncenter wp-image-2273 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Login\" width=\"1182\" height=\"324\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/15-3.webp 1182w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/15-3-300x82.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/15-3-1024x281.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/15-3-768x211.webp 768w\" sizes=\"(max-width: 1182px) 100vw, 1182px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now first we are going to create a <strong>database<\/strong> inside of <strong>MySQL<\/strong> database using the following command.\u00a0<\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">CREATE DATABASE &lt;database_name&gt;;<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">Then create a table with the name <strong>Persons.<\/strong><\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">CREATE TABLE &lt;database_name&gt;.Persons (<\/span>\r\n<span style=\"font-weight: 400;\">PersonID int,<\/span>\r\n<span style=\"font-weight: 400;\">LastName varchar(255),<\/span>\r\n<span style=\"font-weight: 400;\">FirstName varchar(255),<\/span>\r\n<span style=\"font-weight: 400;\">Gender varchar(255)<\/span>\r\n<span style=\"font-weight: 400;\">);<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">Now we have to inject a detail of a person using the following command.<\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">INSERT INTO &lt;database_name&gt;.Persons<\/span>\r\n<span style=\"font-weight: 400;\">VALUES ('0023', 'Holland', 'Tom', 'male');<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">Run the following command to view the contents of the table.<\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">It will show the table like the below screenshot.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/16-2.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Create table and Insert\" class=\"aligncenter wp-image-2274 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DB Create table and Insert\" width=\"483\" height=\"478\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/16-2.webp 483w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/16-2-300x297.webp 300w\" sizes=\"(max-width: 483px) 100vw, 483px\" \/><\/p>\n<h2>Create another RDS DB Instance from the Primary Instance.<\/h2>\n<p><span style=\"font-weight: 400;\">Select the main <strong>MySQL RDS database<\/strong>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Select <strong>Modify<\/strong> and click <strong>Restore<\/strong> <strong>to point in time<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/17-2.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Modify Main Database\" class=\"aligncenter wp-image-2275 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Modify Main Database\" width=\"1785\" height=\"752\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/17-2.webp 1785w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/17-2-300x126.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/17-2-1024x431.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/17-2-768x324.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/17-2-1536x647.webp 1536w\" sizes=\"(max-width: 1785px) 100vw, 1785px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Select the <strong>Restore time<\/strong> to\u00a0the <strong>latest restorable time.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">For <strong>DB engine<\/strong> select <strong>MySQL Community Edition<\/strong> and for <strong>DB instance identifier<\/strong> provide a name for your restoring database instance.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/18-1.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time\" class=\"aligncenter wp-image-2276 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time\" width=\"617\" height=\"514\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/18-1.webp 957w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/18-1-300x250.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/18-1-768x640.webp 768w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">For<strong> instance configuration<\/strong> leaves it as default.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>Multi AZ deployment<\/strong> under <strong>Availability &amp; durability<\/strong>, for testing purpose select <strong>do not create a standby instance<\/strong>.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">In a real time production environment choosing to create a standby instance is a recommended way.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/19-1.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time\" class=\"aligncenter wp-image-2277 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time\" width=\"659\" height=\"478\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/19-1.webp 951w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/19-1-300x218.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/19-1-768x557.webp 768w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Scroll down to the bottom. Leave all the other things as default.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Click the <strong>Restore to point in time<\/strong> button to create a new database instance.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/20.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Create\" class=\"aligncenter wp-image-2278 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Create\" width=\"778\" height=\"231\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/20.webp 967w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/20-300x89.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/20-768x228.webp 768w\" sizes=\"(max-width: 778px) 100vw, 778px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now you can see a new restored database instance is being created.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/21.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Creating\" class=\"aligncenter wp-image-2279 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Creating\" width=\"1788\" height=\"518\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/21.webp 1788w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/21-300x87.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/21-1024x297.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/21-768x222.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/21-1536x445.webp 1536w\" sizes=\"(max-width: 1788px) 100vw, 1788px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Once the restored DB instance is created you can see the <strong>Endpoint<\/strong> of the restored database under the <strong>Connectivity &amp; security<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/22.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Created\" class=\"aligncenter wp-image-2280 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Created\" width=\"1440\" height=\"771\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/22.webp 1440w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/22-300x161.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/22-1024x548.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/22-768x411.webp 768w\" sizes=\"(max-width: 1440px) 100vw, 1440px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Using the new Endpoint of the restored database instance run the following command in your EC2 instance to connect with the restored database.<\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">mysql -h &lt;restored_database_endpoint&gt; -P 3306 -u admin -p<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">Run &#8216;<strong><em>SHOW DATABASES;<\/em><\/strong>&#8216; command and you can see the database which is created in the <strong>primary database<\/strong>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Run the following command to see whether the table which we created in the<strong> primary database<\/strong> is replicated in this <strong>restored database<\/strong>.<\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">If your output is like the below picture, your restored database instance is successfully restored from the primary database instance.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Checking\" class=\"aligncenter wp-image-2281 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Restore Database Point In Time Checking\" width=\"1225\" height=\"733\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23.webp 1225w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23-300x180.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23-1024x613.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23-768x460.webp 768w\" sizes=\"(max-width: 1225px) 100vw, 1225px\" \/><\/p>\n<h2>Database Migration Service<\/h2>\n<ul>\n<li><span style=\"font-weight: 400;\">Now we are going to create a replication from the primary database instance to restored or secondary database instance.<\/span><\/li>\n<li>Here what is <strong>replication<\/strong> means, whenever a changes are made from primary database, they will immediately replicated to the secondary database.<\/li>\n<li><span style=\"font-weight: 400;\">Since this is a <strong>homogeneous database migration<\/strong> (the source and target database engines are the same).\u00a0<\/span><\/li>\n<\/ul>\n<h3>Create Replication Instance<\/h3>\n<ul>\n<li><span style=\"font-weight: 400;\">Navigate to the <strong>DMS<\/strong> page in <strong>AWS console<\/strong> and on the left side panel under the <strong>Migrate data<\/strong> section click <strong>Replication instances.<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\"><strong>Replication instances<\/strong> help to <strong>create a connection between the source and target database instances to transfer the data<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click the <strong>Create replication instance<\/strong> button.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/24.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance\" class=\"aligncenter wp-image-2282 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance\" width=\"1875\" height=\"632\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/24.webp 1875w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/24-300x101.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/24-1024x345.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/24-768x259.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/24-1536x518.webp 1536w\" sizes=\"(max-width: 1875px) 100vw, 1875px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Enter a name to your replication instance.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/25.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instances\" class=\"aligncenter wp-image-2283 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instances\" width=\"731\" height=\"459\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/25.webp 1007w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/25-300x188.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/25-768x482.webp 768w\" sizes=\"(max-width: 731px) 100vw, 731px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">For <strong>instance configuration<\/strong> choose a least type of instance class for this tutorial purpose only.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For the <strong>Engine version,<\/strong> choose the <strong>latest version of DMS.<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\">For the <strong>Multi-AZ,<\/strong> choose <strong>Dev<\/strong> <strong>or test workload<\/strong> for testing purpose.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/26.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance Engine Version\" class=\"aligncenter wp-image-2284 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance Engine Version\" width=\"726\" height=\"571\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/26.webp 1001w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/26-300x236.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/26-768x605.webp 768w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">For VPC select the VPC which you select for your primary database instance and the same as the subnet group.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For now select the <strong>public accessible<\/strong> to<strong> enable<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/27.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance Connectivity &amp; Security\" class=\"aligncenter wp-image-2285 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance Connectivity &amp; Security\" width=\"654\" height=\"491\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/27.webp 996w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/27-300x225.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/27-768x576.webp 768w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">For the <strong>availability zone<\/strong>, choose the one where you created your primary database instance. The Database instances and replication instances should be in the same availability zone.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>VPC security groups<\/strong> choose the security group that we created earlier.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click the <strong>create replication instance<\/strong> button.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/28.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance Advanced Settings and Create\" class=\"aligncenter wp-image-2286 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Replication Instance Advanced Settings and Create\" width=\"800\" height=\"637\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/28.webp 1011w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/28-300x239.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/28-768x612.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Replication instances<\/strong> take around <strong>15 to 20<\/strong> minutes to create.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once it is created successfully it shows <strong>Available<\/strong> status like the picture below.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/29.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Created Replication Instance\" class=\"aligncenter wp-image-2287 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Created Replication Instance\" width=\"1452\" height=\"256\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/29.webp 1452w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/29-300x53.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/29-1024x181.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/29-768x135.webp 768w\" sizes=\"(max-width: 1452px) 100vw, 1452px\" \/><\/p>\n<h3>Create Source and Target Endpoints<\/h3>\n<p><span style=\"font-weight: 400;\">On the left side panel under the <strong>Replication instances<\/strong> choose <strong>Endpoints.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Then click the <strong>Create endpoint<\/strong> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/30.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Endpoints\" class=\"aligncenter wp-image-2288 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Create Endpoints\" width=\"1873\" height=\"462\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/30.webp 1873w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/30-300x74.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/30-1024x253.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/30-768x189.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/30-1536x379.webp 1536w\" sizes=\"(max-width: 1873px) 100vw, 1873px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">First we are going to create a <strong>Source endpoint<\/strong>. So choose <strong>Source endpoint<\/strong> for Endpoint type.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Check the Select <strong>RDS DB instance<\/strong> box.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Choose the <strong>Primary RDS DB Instance<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Under <strong>endpoint configuration<\/strong>, for the <strong>Endpoint identifier<\/strong> give a name like the below picture.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Choose the <strong>source engine<\/strong> as <strong>MySQL.<\/strong><\/span><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/31.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Choose Endpoint Type\" class=\"aligncenter wp-image-2289 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Choose Endpoint Type\" width=\"717\" height=\"638\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/31.webp 907w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/31-300x267.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/31-768x683.webp 768w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Choose <strong>Provide access information manually<\/strong> for Access to the endpoint database.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">And the <strong>Server name, Port<\/strong> and the <strong>user name<\/strong> are filled default and for <strong>password,<\/strong> enter the password for the user.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/32.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Provide Endpoint Details\" class=\"aligncenter wp-image-2290 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Provide Endpoint Details\" width=\"711\" height=\"408\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/32.webp 1005w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/32-300x172.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/32-768x441.webp 768w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Expand the <strong>Test endpoint<\/strong> section, choose the VPC which you use for this demo, and choose the<strong> replication instance<\/strong> that you created earlier.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click <strong>Run test<\/strong> to test the connection to the database.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">If the connection was successful it will show like the picture below.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Finally click <strong>Create endpoint<\/strong> button.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/33.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Test Source Endpoint Connection\" class=\"aligncenter wp-image-2291 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Test Source Endpoint Connection\" width=\"791\" height=\"608\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/33.webp 1015w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/33-300x231.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/33-768x590.webp 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now your source endpoint is in <strong>Active<\/strong> status.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Click <strong>Create endpoint<\/strong> button to create<strong> target endpoint<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/34.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Source Endpoint Created\" class=\"aligncenter wp-image-2292 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Source Endpoint Created\" width=\"1467\" height=\"297\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/34.webp 1467w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/34-300x61.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/34-1024x207.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/34-768x155.webp 768w\" sizes=\"(max-width: 1467px) 100vw, 1467px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Choose the <strong>Endpoint type<\/strong> as <strong>Target endpoint<\/strong> and check the box for Select <strong>RDS DB instance<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select <strong>restored database instance as target RDS instance<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>Endpoint identifier<\/strong>, enter a name for the target endpoint\u00a0 and choose the target <strong>engine<\/strong> as <strong>MySQL.<\/strong><\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/35.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Target Endpoint Create\" class=\"aligncenter wp-image-2293 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Target Endpoint Create\" width=\"743\" height=\"653\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/35.webp 912w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/35-300x264.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/35-768x675.webp 768w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Choose <strong>Provide access information manually<\/strong> for Access to the endpoint database.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">And the <strong>Server name, Port<\/strong> and the <strong>user name<\/strong> are filled default with the restored database details and for password, enter the password for the user.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/36.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Target Endpoint details\" class=\"aligncenter wp-image-2294 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Target Endpoint details\" width=\"707\" height=\"463\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/36.webp 997w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/36-300x196.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/36-768x502.webp 768w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Expand the <strong>Test endpoint<\/strong> section, choose the VPC and the replication instance.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click Run test to test the connection to the restored database.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">If the connection was successful it will show like the picture below.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Finally click <strong>Create endpoint<\/strong> button<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/38.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Test Target Endpoint Connection\" class=\"aligncenter wp-image-2295 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Test Target Endpoint Connection\" width=\"715\" height=\"548\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/38.webp 1002w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/38-300x230.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/38-768x589.webp 768w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now our two endpoints are <strong>Active.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Source and target Endpoints\" class=\"aligncenter wp-image-2296 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Source and target Endpoints\" width=\"1463\" height=\"286\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39.webp 1463w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39-300x59.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39-1024x200.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39-768x150.webp 768w\" sizes=\"(max-width: 1463px) 100vw, 1463px\" \/><\/p>\n<h3>Create Database Migration Task<\/h3>\n<p><span style=\"font-weight: 400;\">Now login to your <strong>primary MySQL RDS<\/strong> Database and run the following commands to insert user details to the table and list out the table.<\/span><\/p>\n<p>&nbsp;<\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">INSERT INTO &lt;database_name&gt;.Persons<\/span>\r\n<span style=\"font-weight: 400;\">VALUES ('0024', 'Maguire', 'Toby', 'male');<\/span>\r\n\r\n<span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39a.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Insert User Details into Table in Primary DB\" class=\"aligncenter wp-image-2297 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Insert User Details into Table in Primary DB\" width=\"542\" height=\"257\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39a.webp 542w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/39a-300x142.webp 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Login to the <strong>restored database<\/strong> and run the following command to see the changes made from the <strong>primary database are replicated<\/strong> to this database.<\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">You are not able to see the changes in the restored database.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23-Copy-e1671594664894.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Check Replication In Secondary DB\" class=\"aligncenter wp-image-2361 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Check Replication In Secondary DB\" width=\"468\" height=\"211\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23-Copy-e1671594664894.webp 468w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/23-Copy-e1671594664894-300x135.webp 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/p>\n<ul>\n<li>Because the changes are not replicated to secondary database.<\/li>\n<li><span style=\"font-weight: 400;\">For this we need to create a <strong>Database migration<\/strong> task.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">So click the <strong>Create database migration task<\/strong> button.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/40.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task\" class=\"aligncenter wp-image-2298 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task\" width=\"1883\" height=\"457\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/40.webp 1883w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/40-300x73.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/40-1024x249.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/40-768x186.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/40-1536x373.webp 1536w\" sizes=\"(max-width: 1883px) 100vw, 1883px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">For <strong>Task identifier<\/strong>, provide a name for the task.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Choose the <strong>replication instance<\/strong> which we created for the Replication instance.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>Source database endpoint<\/strong>, choose the endpoint you have created for source and for the <strong>Target database endpoint<\/strong>, choose the endpoint you\u2019ve created for target.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For the <strong>Migration type,<\/strong> choose <strong>Migrate existing data and replicate ongoing changes<\/strong>.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/41.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Configuration\" class=\"aligncenter wp-image-2299 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Configuration\" width=\"711\" height=\"607\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/41.webp 950w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/41-300x256.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/41-768x656.webp 768w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Scroll down and under the <strong>Task settings<\/strong>, for the <strong>Editing mode<\/strong> choose <strong>Wizard.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Change the followings and keep the default values to the remaining options:<\/span><\/p>\n<ol>\n<li><strong>Target table operation mode &#8211; Do nothing<\/strong><\/li>\n<li><strong>Turn on validation &#8211; Enable<\/strong><\/li>\n<li><strong>Turn on Cloudwatch Logs &#8211; Enable<\/strong><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/42.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Settings\" class=\"aligncenter wp-image-2300 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Settings\" width=\"679\" height=\"954\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/42.webp 575w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/42-213x300.webp 213w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Scroll down and expand <strong>Selection rules<\/strong> and Click <strong>Add<\/strong> <strong>new selection rule<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>Schema<\/strong> select <strong>Enter a schema<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>source name<\/strong> Enter the d<strong>atabase name which you want to replicate to the target database<\/strong>.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For my scenario I use the test as a database which is going to be replicated.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For <strong>source table name<\/strong> the <em><strong>%<\/strong> <\/em>symbol indicates all the tables inside the source database. So leave it as default.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/43.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Schema Settings\" class=\"aligncenter wp-image-2301 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Schema Settings\" width=\"711\" height=\"485\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/43.webp 1028w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/43-300x205.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/43-1024x698.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/43-768x524.webp 768w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Scroll down to the bottom and click <strong>Create task.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/44.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Create task\" class=\"aligncenter wp-image-2302 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Create task\" width=\"761\" height=\"391\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/44.webp 1072w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/44-300x154.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/44-1024x525.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/44-768x394.webp 768w\" sizes=\"(max-width: 761px) 100vw, 761px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now your <strong>Database migration task<\/strong> will be in <strong>starting<\/strong> status.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/45.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Creating\" class=\"aligncenter wp-image-2303 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Database Migration Task Creating\" width=\"1467\" height=\"237\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/45.webp 1467w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/45-300x48.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/45-1024x165.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/45-768x124.webp 768w\" sizes=\"(max-width: 1467px) 100vw, 1467px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Once its status is shown like the below screenshot, go to the table <strong>statistics<\/strong> section.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You are able to see the <strong>Table<\/strong>\u00a0<strong>Persons<\/strong> is updated successfully.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/46.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DMS Table Statistics\" class=\"aligncenter wp-image-2304 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime DMS Table Statistics\" width=\"1468\" height=\"706\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/46.webp 1468w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/46-300x144.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/46-1024x492.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/46-768x369.webp 768w\" sizes=\"(max-width: 1468px) 100vw, 1468px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">So login to your <strong>restored database<\/strong> and run the following command to see the updated status.<\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<p><span style=\"font-weight: 400;\">You can see the <strong>second<\/strong> name with the column <strong>PersonID 24<\/strong> will replicated from the <strong>primary database<\/strong>.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/47.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List All in Table in Secondary DB\" class=\"aligncenter wp-image-2305 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List All in Table in Secondary DB\" width=\"458\" height=\"176\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/47.webp 458w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/47-300x115.webp 300w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/><\/p>\n<h3>Check the Replication<\/h3>\n<h4>In Primary Database<\/h4>\n<p><span style=\"font-weight: 400;\">Now login to the <strong>primary database<\/strong> and run the following commands to add a row inside the <strong>Persons<\/strong> table.<\/span><\/p>\n<pre><span style=\"font-weight: 400;\">INSERT INTO &lt;database_name&gt;.Persons<\/span>\r\n<span style=\"font-weight: 400;\">VALUES ('0030', 'Olsen', 'Elizabeth', 'female');<\/span>\r\n\r\n<span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/48.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Insert Row in Table in Primary DB\" class=\"aligncenter wp-image-2306 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Insert Row in Table in Primary DB\" width=\"567\" height=\"280\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/48.webp 567w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/48-300x148.webp 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/p>\n<h4>In Restored Database<\/h4>\n<ul>\n<li><span style=\"font-weight: 400;\">Now login to the <strong>secondary database<\/strong> with its endpoint and run the following command to see the replication status.<\/span><\/li>\n<\/ul>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li><span style=\"font-weight: 400;\">You can now see the replication from the primary database to the restored database is successfully working.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">So from now whatever changes made from the primary database is replicated to the restored database immediately with the delay of milliseconds.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/49.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Users in Table in Secondary DB\" class=\"aligncenter wp-image-2307 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Users in Table in Secondary DB\" width=\"453\" height=\"193\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/49.webp 453w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/49-300x128.webp 300w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/p>\n<h2>Upgrade the RDS Restored Database instance to latest version<\/h2>\n<ul>\n<li><span style=\"font-weight: 400;\">Now select the <strong>restored RDS database instance<\/strong> and click <strong>Modify.<\/strong><\/span><\/li>\n<li><span style=\"font-weight: 400;\">For the <strong>DB engine version<\/strong> choose the <strong>latest version<\/strong> at the time you are working.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">For currently<strong> 8.0.31<\/strong> is the latest version for <strong>MySQL<\/strong>.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/50.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB\" class=\"aligncenter wp-image-2308 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB\" width=\"610\" height=\"241\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/50.webp 1007w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/50-300x119.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/50-768x304.webp 768w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Under the <strong>Additional Configuration,<\/strong> for the <strong>DB parameter<\/strong>\u00a0group choose the one that you created from the beginning of this tutorial for <strong>version 8.0.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/51.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB Parameter group\" class=\"aligncenter wp-image-2309 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB Parameter group\" width=\"701\" height=\"277\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/51.webp 926w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/51-300x119.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/51-768x304.webp 768w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Leave all other things as default and click <strong>Continue.<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/52.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB Continue\" class=\"aligncenter wp-image-2310 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB Continue\" width=\"654\" height=\"352\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/52.webp 988w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/52-300x162.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/52-768x414.webp 768w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Under the <strong>Schedule modification<\/strong> section, for <strong>When to apply modifications<\/strong>, choose <strong>Apply immediately.<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Finally click the <strong>Modify DB instance<\/strong> button.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/53.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB Instance\" class=\"aligncenter wp-image-2311 \" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modify RDS DB Instance\" width=\"734\" height=\"553\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/53.webp 958w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/53-300x226.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/53-768x579.webp 768w\" sizes=\"(max-width: 734px) 100vw, 734px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now your restored RDS database is <strong>upgrading<\/strong> status.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/54.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modifying RDS DB Instance\" class=\"aligncenter wp-image-2312 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Modifying RDS DB Instance\" width=\"1791\" height=\"352\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/54.webp 1791w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/54-300x59.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/54-1024x201.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/54-768x151.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/54-1536x302.webp 1536w\" sizes=\"(max-width: 1791px) 100vw, 1791px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">In the meantime,<strong> login to your primary database<\/strong> and run the following commands to insert a row of data into the <strong>Persons table.<\/strong><\/span><\/p>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">INSERT INTO &lt;database_name&gt;.Persons\r\nVALUES ('0035', 'Evans', 'Cris', 'male');\r\n\r\nSELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/55.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Insert a Row into Primary DB\" class=\"aligncenter wp-image-2313 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime List Insert a Row into Primary DB\" width=\"512\" height=\"306\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/55.webp 512w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/55-300x179.webp 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Wait around 10 minutes to upgrade the database.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Once the upgrade is completed, Select the <strong>restored database<\/strong> and select the <strong>Configuration<\/strong> section.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">You can see the <strong>engine version is 8.0.31<\/strong>. So it is successfully upgraded.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/57.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime RDS DB Successfully Upgraded\" class=\"aligncenter wp-image-2314 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime RDS DB Successfully Upgraded\" width=\"1817\" height=\"752\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/57.webp 1817w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/57-300x124.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/57-1024x424.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/57-768x318.webp 768w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/57-1536x636.webp 1536w\" sizes=\"(max-width: 1817px) 100vw, 1817px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Now we need to check if the table modification from the primary database is replicated into the restored upgraded database.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">So, <strong>login<\/strong> to the <strong>secondary database<\/strong> and run the following command.<\/span><\/li>\n<\/ul>\n<blockquote>\n<pre><span style=\"font-weight: 400;\">SELECT * FROM &lt;database_name&gt;.Persons;<\/span><\/pre>\n<\/blockquote>\n<ul>\n<li><span style=\"font-weight: 400;\">Now you are able to see the table is updated with all details from the primary database.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/58.webp\" alt=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Login to Secondary RDS DB\" class=\"aligncenter wp-image-2315 size-full\" title=\"Upgrade MySQL 5.7 RDS DB Instance to Latest Version with Zero Downtime Login to Secondary RDS DB\" width=\"1256\" height=\"496\" srcset=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/58.webp 1256w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/58-300x118.webp 300w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/58-1024x404.webp 1024w, https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/58-768x303.webp 768w\" sizes=\"(max-width: 1256px) 100vw, 1256px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">We successfully completed to <strong>upgraded RDS database with the latest version<\/strong>.<\/span><\/p>\n<h2 data-pm-slice=\"1 1 []\">Final Step<\/h2>\n<p><span style=\"font-weight: 400;\">To this point whenever changes or updates are made from the old version primary database are parallelly replicated to the secondary database which is upgraded to the latest MySQL version. But we need to set up the latest MySQL version database as the primary one. For this just<strong> point the Secondary database as the primary database inside the application code<\/strong>. Now the application will use the database which was upgraded to the latest version. Then delete the old MySQL version database.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Yeah! All good\u2026<\/span><\/p>\n<p><span style=\"font-weight: 400;\">We are successfully upgrading the RDS database to the latest MySQL version with nearly zero downtime. Yes, During this whole process there is no downtime for your application.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">I hope you all enjoy this article.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction We can easily Upgrade our AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 with just modify the DB Instance version. But when you modify your DB instance\u2019s version, it takes the modification time minimum of 15 mins to 4 hours or higher. In real time scenarios it will lead to downtime in [&hellip;]<\/p>\n","protected":false},"author":20,"featured_media":2441,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2],"tags":[431,434,435],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upgrade MySQL version in RDS using AWS DMS - esydeploy.io<\/title>\n<meta name=\"description\" content=\"Here learn about upgrading AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 by modifying the DB Instance version. Learn More!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade MySQL version in RDS using AWS DMS - esydeploy.io\" \/>\n<meta property=\"og:description\" content=\"Here learn about upgrading AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 by modifying the DB Instance version. Learn More!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\" \/>\n<meta property=\"og:site_name\" content=\"easydeploy.io\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/Jerinrathnam\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-22T10:18:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-12T06:10:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Jerin Rathnam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jerin_rathnam\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jerin Rathnam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"24 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\"},\"author\":{\"name\":\"Jerin Rathnam\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f\"},\"headline\":\"How to upgrade MySQL version in RDS with zero to minimal downtime using AWS DMS\",\"datePublished\":\"2022-12-22T10:18:43+00:00\",\"dateModified\":\"2023-01-12T06:10:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\"},\"wordCount\":2371,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp\",\"keywords\":[\"upgrade MySQL version in RDS\",\"upgrade rds mysql 5.7 to 8\",\"upgrade rds mysql 5.7 to 8 with zero downtime\"],\"articleSection\":[\"Amazon Web Services\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\",\"name\":\"Upgrade MySQL version in RDS using AWS DMS - esydeploy.io\",\"isPartOf\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp\",\"datePublished\":\"2022-12-22T10:18:43+00:00\",\"dateModified\":\"2023-01-12T06:10:46+00:00\",\"description\":\"Here learn about upgrading AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 by modifying the DB Instance version. Learn More!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp\",\"contentUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp\",\"width\":1280,\"height\":720,\"caption\":\"upgrade MySQL RDS Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.easydeploy.io\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to upgrade MySQL version in RDS with zero to minimal downtime using AWS DMS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#website\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/\",\"name\":\"easydeploy.io\",\"description\":\"A Cloud Architect Company\",\"publisher\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.easydeploy.io\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#organization\",\"name\":\"EasyDeploy Technologies Pvt Ltd\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png\",\"contentUrl\":\"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png\",\"width\":536,\"height\":100,\"caption\":\"EasyDeploy Technologies Pvt Ltd\"},\"image\":{\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f\",\"name\":\"Jerin Rathnam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g\",\"caption\":\"Jerin Rathnam\"},\"description\":\"Jerin Rathnam is a proficient DevOps engineer who is dedicated to streamlining software development and deployment processes. He has extensive knowledge of cloud infrastructure, containerization, and CI\/CD pipelines, which enables him to effectively connect development and operations. Jerin specializes in creating numerous Terraform modules for multi-cloud infrastructure and possesses immense expertise in configuring and managing cloud infrastructure. His profound understanding of containerization, along with his experience in orchestration tools like Docker and Kubernetes, further supports his skills as a valuable DevOps engineer.\",\"sameAs\":[\"https:\/\/www.gemjerin.site\",\"https:\/\/www.facebook.com\/Jerinrathnam\",\"https:\/\/www.instagram.com\/gem_jerin_rathnam\/\",\"https:\/\/www.linkedin.com\/in\/jerin-rathnam\/\",\"https:\/\/x.com\/jerin_rathnam\",\"@jerinrathnam\"],\"url\":\"https:\/\/www.easydeploy.io\/blog\/author\/jerin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade MySQL version in RDS using AWS DMS - esydeploy.io","description":"Here learn about upgrading AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 by modifying the DB Instance version. Learn More!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/","og_locale":"en_GB","og_type":"article","og_title":"Upgrade MySQL version in RDS using AWS DMS - esydeploy.io","og_description":"Here learn about upgrading AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 by modifying the DB Instance version. Learn More!","og_url":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/","og_site_name":"easydeploy.io","article_author":"https:\/\/www.facebook.com\/Jerinrathnam","article_published_time":"2022-12-22T10:18:43+00:00","article_modified_time":"2023-01-12T06:10:46+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp","type":"image\/webp"}],"author":"Jerin Rathnam","twitter_card":"summary_large_image","twitter_creator":"@jerin_rathnam","twitter_misc":{"Written by":"Jerin Rathnam","Estimated reading time":"24 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#article","isPartOf":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/"},"author":{"name":"Jerin Rathnam","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f"},"headline":"How to upgrade MySQL version in RDS with zero to minimal downtime using AWS DMS","datePublished":"2022-12-22T10:18:43+00:00","dateModified":"2023-01-12T06:10:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/"},"wordCount":2371,"commentCount":0,"publisher":{"@id":"https:\/\/www.easydeploy.io\/blog\/#organization"},"image":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp","keywords":["upgrade MySQL version in RDS","upgrade rds mysql 5.7 to 8","upgrade rds mysql 5.7 to 8 with zero downtime"],"articleSection":["Amazon Web Services"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/","url":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/","name":"Upgrade MySQL version in RDS using AWS DMS - esydeploy.io","isPartOf":{"@id":"https:\/\/www.easydeploy.io\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage"},"image":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage"},"thumbnailUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp","datePublished":"2022-12-22T10:18:43+00:00","dateModified":"2023-01-12T06:10:46+00:00","description":"Here learn about upgrading AWS MySQL RDS Database Instance from MySQL 5.7 to 8.0 by modifying the DB Instance version. Learn More!","breadcrumb":{"@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#primaryimage","url":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp","contentUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2022\/12\/Easydeploy-How-upgrade-Amazon-Aurora-MySQL-version-with-zero-to-minimal-downtime-using-AWS-DMS.webp","width":1280,"height":720,"caption":"upgrade MySQL RDS Database"},{"@type":"BreadcrumbList","@id":"https:\/\/www.easydeploy.io\/blog\/upgrade-mysql-version-rds-using-aws-dms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.easydeploy.io\/blog\/"},{"@type":"ListItem","position":2,"name":"How to upgrade MySQL version in RDS with zero to minimal downtime using AWS DMS"}]},{"@type":"WebSite","@id":"https:\/\/www.easydeploy.io\/blog\/#website","url":"https:\/\/www.easydeploy.io\/blog\/","name":"easydeploy.io","description":"A Cloud Architect Company","publisher":{"@id":"https:\/\/www.easydeploy.io\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.easydeploy.io\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.easydeploy.io\/blog\/#organization","name":"EasyDeploy Technologies Pvt Ltd","url":"https:\/\/www.easydeploy.io\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png","contentUrl":"https:\/\/www.easydeploy.io\/blog\/wp-content\/uploads\/2019\/02\/easydeploy.png","width":536,"height":100,"caption":"EasyDeploy Technologies Pvt Ltd"},"image":{"@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/939543ac3b33fadea8b5115ab9a1280f","name":"Jerin Rathnam","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.easydeploy.io\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ca2c2ab4a28d380073334816b42aaa40?s=96&d=mm&r=g","caption":"Jerin Rathnam"},"description":"Jerin Rathnam is a proficient DevOps engineer who is dedicated to streamlining software development and deployment processes. He has extensive knowledge of cloud infrastructure, containerization, and CI\/CD pipelines, which enables him to effectively connect development and operations. Jerin specializes in creating numerous Terraform modules for multi-cloud infrastructure and possesses immense expertise in configuring and managing cloud infrastructure. His profound understanding of containerization, along with his experience in orchestration tools like Docker and Kubernetes, further supports his skills as a valuable DevOps engineer.","sameAs":["https:\/\/www.gemjerin.site","https:\/\/www.facebook.com\/Jerinrathnam","https:\/\/www.instagram.com\/gem_jerin_rathnam\/","https:\/\/www.linkedin.com\/in\/jerin-rathnam\/","https:\/\/x.com\/jerin_rathnam","@jerinrathnam"],"url":"https:\/\/www.easydeploy.io\/blog\/author\/jerin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts\/2358"}],"collection":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/comments?post=2358"}],"version-history":[{"count":15,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts\/2358\/revisions"}],"predecessor-version":[{"id":2558,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/posts\/2358\/revisions\/2558"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/media\/2441"}],"wp:attachment":[{"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/media?parent=2358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/categories?post=2358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.easydeploy.io\/blog\/wp-json\/wp\/v2\/tags?post=2358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}