{"id":221,"date":"2021-10-27T15:14:16","date_gmt":"2021-10-27T15:14:16","guid":{"rendered":"http:\/\/18.141.20.153\/?p=221"},"modified":"2025-08-22T08:06:38","modified_gmt":"2025-08-22T08:06:38","slug":"how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms","status":"publish","type":"post","link":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/","title":{"rendered":"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?"},"content":{"rendered":"<span class=\"rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\">7<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span>\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/Zd1IRsz_kuagtZFvueDRck2fg92FlWGyI9URKmFcqfSFvfU7PUI2YW1ojuexLPXmPaOqNKlaaJQrOFaeHe2kkrT22RpWZzBZHcLfrj4xn_btxklUXkDN8BOZWAxebRxI1RDxkMZ4\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p class=\"has-text-align-justify\">Do you want to migrate data from one type of DB engine (MySQL) to another type of DB engine(PostgreSQL) with little or no downtime? In today&#8217;s fast-paced environment, application, and database availability must be considered 24 hours a day, seven days a week. Some of your applications may be unable to tolerate substantial downtime while migrating data from one type of DB engine to another type of DB engine. The ideal solution in this case is AWS Relational Database Service (RDS). Let\u2019s assume that you are running a streaming application that is hosted in an EC2 instance or Lambda functions in the AWS cloud. Currently, you are using the RDS MySQL database engine. Now you are going to add new functionalities which require long-running queries to handle JSON, XML, etc. In this case, you can migrate from the existing RDS MySQL database to RDS PostgreSQL to take advantage of the PostgreSQL database. You can do this migration easily with little or no downtime using AWS DMS.<\/p>\n\n\n\n<p class=\"has-text-align-justify\">AWS Database Migration Service (AWS DMS) is a cloud service that is one of the easiest ways to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. In this blog, we will demonstrate how to migrate the RDS MySQL database to the RDS PostgreSQL database using AWS Database Migration Service.<\/p>\n\n\n\n<h2>AWS Database Migration Service(DMS)<\/h2>\n\n\n\n<p class=\"has-text-align-justify\">The AWS Database Migration Service (AWS DMS) is a cloud service that makes migrating relational databases, data warehouses, NoSQL databases, and other data storage simple. AWS DMS may be used to migrate data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), and between cloud and on-premises deployments. It also helps us to migrate databases of different Database Engines.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/Jr8-8Fvm2l6CnLOI4XSFQKc1_NLJX4-8X3iMIpFUv1bsNhFyIS62wE89XDKz2q4i3mQtsx0RY-vrw1wkIpDzFi6IUJnoMrNenB-P9xwLxNS9GVcXflbPp4eqZvjJtZihFYDCp58m\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<h2>Hands-On<\/h2>\n\n\n\n<h1><img src=\"https:\/\/lh6.googleusercontent.com\/mESwMj64lbQdnGNSulKHVDolq7qpb5Knni9XrXCemBPUgDkOO6Y_2o6D5yM9XPEoaaQrcWpu6PcjSKR2W9ePracYxAqvuluJ_FwqUdsijI-Agzk8Aw0hXUm9hrgwreu3k9jyANrO\" style=\"width: undefinedpx;\"><\/h1>\n\n\n\n<p><strong>Prerequisites:<\/strong><\/p>\n\n\n\n<p>To continue this hands-on, you should be having followings:<\/p>\n\n\n\n<ul><li>An RDS DB instance running with MySQL DB Engine.&nbsp;<\/li><li>An RDS DB instance running with PostgreSQL DB Engine.<\/li><\/ul>\n\n\n\n<p><strong>In this hands-on, we will do following:<\/strong><\/p>\n\n\n\n<ul><li>Setup a Replication Instance<\/li><li>Creating an Endpoint for Source Database (RDS MySQL)<\/li><li>Creating an Endpoint for Target Database (RDS PostgreSQL)<\/li><li>Creating Database Migration Task<\/li><\/ul>\n\n\n\n<h4>Setup a Replication Instance<\/h4>\n\n\n\n<p>To setup a replication instance, go to AWS DMS console<\/p>\n\n\n\n<p>Click create replication instance<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/UtFm4nWB-RI4AnZ__CeGnIiBo_Yq7rIFO7eU-Okag0lnUKNcRTsN2Epp1AgXCBu4UOm5n9zN24Ah1b7irL4v3Bil61oqSpVYXZomJzmCmdVD6zNBQYRR0pkcUuo0SjrQFTVYfFc2\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>We have to configure the replication instance<\/p>\n\n\n\n<p>Enter the name for the replication instance.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/CSarAdLRhFHZZizXliJwOO3VwTGrVrJ84v83uriO7jcx7uqXqzvZrNr7Ubmv55lhAU9QI52D2n7fRu3WUoUm2tiJ_21rJJ1s9uLLxzAiOftrSKe6GBo8QJFfl3-JBgyJ-LqZ6dPl\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>For the Instance class, choose the preferred instance type and the Engine Version be a default.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/dbHvU1_Q-2QNug7Ovh0jCr9sV1Tg5rqALhfEbA0bSaEWjNQr7rJMc1dPidSJTCwCYfkuGmXI3r4VQoH14Z3SROh8DpeGmY9fL5TQaL3Ma_FcbcvRjdll2D8YN2vN_fYjpX9-_sW2\" alt=\"\"\/><\/figure>\n\n\n\n<p>Enter the size of the storage required for the replication instance.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/BJaFGe17ud-bRlD_8yo7YOaMaYJg7Jy0OZ7D5ypBGogzUlZN5IxjKcjUL33mqrReYXwElcD6J0jZNDyL6r5ywUXA7vOCSoIycMNa-4h0Stxqa7zVCtiDalQ3J40vnR1TDpSb-Odv\" alt=\"\"\/><\/figure>\n\n\n\n<p>Choose the VPC where the replication instance should be created.<\/p>\n\n\n\n<p>If you want the replication instance to be deployed in Multi AZ mode, select it.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/VEwDk0qNMhloOKs8_vunktQ7n2JVpED9c_KDdnOP1MHA35JCVYJA7o9e6FxoqfaMO3YsY26frp-BTbRx6QSzPn9yWd_La-uv3yX0KkQz-84KsiOklv-z5Al2oZ0ccTcvUzIK8_aW\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>Under advanced security and network configuration,&nbsp;<\/p>\n\n\n\n<p>Select the default VPC subnet group.<\/p>\n\n\n\n<p>For the VPC security group(s), choose the default security group.<\/p>\n\n\n\n<p>The default KMS master key will be used.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/8Vdiyare62hqAb34AxEDgiY835fJQMrPbmT1AYWFWObV6ywFB8Fe-MdZhVDRItlkTm37wm0HCa4bFAkyFOVQe8w2zec2h39wYrpWvv5hM1ILkVEOVbROBbcKcftBJ12LOq7yvE-5\" alt=\"\"\/><\/figure>\n\n\n\n<p>And finally click create.<\/p>\n\n\n\n<p>The Replication instance has been created.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/9wFsYOflBG7BqcPaYrJYFFphKG9yAQHFlI7n0GkFBniPdncjEjQhMjugeiBUhrQea8epdvvARYAqZHcGKHtxpNzhMvi1kUqkLhGvQb7C_u1wELAhcw8GDNL56HRyheFijkAs16Wz\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>The Replication instance is successfully created and is available.<\/p>\n\n\n\n<h4>Creating Endpoint for Source Database (MySQL)<\/h4>\n\n\n\n<p>In the navigation pane, click endpoints and then choose Create endpoint.<\/p>\n\n\n\n<p>For the endpoint type, choose Source endpoint.<\/p>\n\n\n\n<p>Check, select RDS DB Instance and then choose the Source RDS DB Instance which is MySQL.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/ex_uikdLpKE6XMPrNaywX6TwiP0Sux1VAZz8iRRWOMC3KMAPNhXisY98AmmQzA1Z6URQ7ycmeMqaw64EMbaoOnQ2jh4tbn5Z8lIdd9MsL27k4Y2hRx_nvLByC9N4U-zxo-JVIOQn\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/K3AX01DhgCgutHnIpImHxCPAkgCTatVXr45qllna5R4wqL_DSZquC9c0h9GpucJFzO5uXCJZA5u-yk38bWO5nVD6TVWTvIpynuXIuv7NhTIJNjLpxAAWfARXr4ym0R9LyTzHioQT\" alt=\"\"\/><\/figure>\n\n\n\n<p>For the Endpoint configuration, enter the Endpoint identifier (It is fetched by default after choosing the RDS DB instance).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/2s0iQ5-98SCzZem68DNg7TDG5D2hZf2VgqV7IJ9nYX81IM1LHodHCtves_X19HsZZZo3F3wNT0LxbqMMpqnl-9JPGfAQvsHOXWYoBp03p6QsdnmtQ0kbZWP1N6piQ_e5I8p51179\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>For Source Engine, choose MySQL.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/3ldS9Ndk0VFQrQfo34LdGWJHUAti5R25yVIKMolYk0XHdE4SuWndHb8EdQvYi5U4YOoEXsbdlkylybMgLf1mSIeEsOUu9prtELlCKWbE-xCTRM92gxWHbQns3dord4HLt-oJXjAU\" alt=\"\"\/><\/figure>\n\n\n\n<p>For access to the endpoint database, select Provide access information manually.<\/p>\n\n\n\n<p>Which will automatically fetch the source DB endpoint, Port, and the User name.<\/p>\n\n\n\n<p>Make the changes if required and Enter the Password of the MySQL RDs DB instance.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/SUSKW0FIS4ZPWPxxjVsdtgNwNSwGgX099GCeTX2DyIGfo2oG24G0yZy150K-vRufCp-jhn9N72TDMd4IM06whUl6ASe-52AB-hVhoLoIz6v4vNtk2UavXpg-uaTrBFRK-nrE5rXJ\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>We can test the connectivity to the RDS MySQL DB instance, by doing so.<\/p>\n\n\n\n<p>Expand test endpoint connection (optional)<\/p>\n\n\n\n<p>Choose the VPC and select the Replication instance then click Run test.<\/p>\n\n\n\n<p>If all the provided information is correct, then the status should be successful.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/-zBypgFO51njURKsLKGZGYp4nNboh6etGx9E95l_9nDd1CzZnn47vnp1PU0titN136RW1ZUBywTjjXsBZeocRnHYpFeMGXX44mzRviq24gDZXCxlhm2oouXBzQqkR2-9S0sWVfYE\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>And finally click create Endpoint.<\/p>\n\n\n\n<p>The Endpoint for the RDS MySQL instance is created and is Active.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/LgVTAAwMDH9Ohys_ak1vf-IAnY35PWSQt7_1kQiys9nLd-Nfj-KRxbjw9KwEE4KDwo9duFWirA06xYDiK09OLgFvaSAH83AXFnmjAlBdB5Dpq45Emid15JX4SL_YperEYyz69ZC7\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<h4>Creating Endpoint for Target Database (PostgreSQL)<\/h4>\n\n\n\n<p>Click Create endpoint.<\/p>\n\n\n\n<p>For the Endpoint type, choose Target endpoint.<\/p>\n\n\n\n<p>Select RDS DB Instance and then select the Target RDS DB Instance which is PostgreSQL.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/YXZJ8m70fk2-7ksBVqwCphTVzUeB3LnNEXYcBct9t7aJeTjmly1SDRag4yQqEp92CM34K1Qs-Tgg3-8lXR11EDDxlvvt1EmQ5Qne50147NV6IGvwuOa8HQCPrq04vrlKlrNiDnao\" alt=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/zo-a9x4G5N3UCbhyqd4O_46vFuhfhtENGpVEFA86WyrqnJNPGvtEZqF_eUSTsCgyw8cSIcgo0Mk4PjK6IURA9nq0KanYUik2JE5PUU8TzdwL_ykPkgLN0a1E4pRHruAAnmosB_WR\" alt=\"\"\/><\/figure>\n\n\n\n<p>For the Endpoint configuration, enter the Endpoint identifier (It is fetched by default after choosing the RDS DB instance).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/wdPXoASJ2dSNGik8tjMfZl78zJu835ngO86eas6s_FmeiVeJ6chDFd2S6qIrmSnqggDe0SQB2qcDX8zfZiKNkI9uWS5tY2hgviB97c9XKNBCDScYWoDjvrYyb1AvihoB1hJiXqjr\" alt=\"\"\/><\/figure>\n\n\n\n<p>For the Target engine, choose PostgreSQL.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/xl23jpA11T8Nak0F3KtzZiEhaVHXGaVcgF4aYOQCSLcK8ZEPsYk6qJT_xPMCNjViwFyMyqOZG-v_hUw6H45Y2XjdwpZO82DAY01yWZVO90qfGyYAV2moGEFk5-NShY-jCqm7U-AD\" alt=\"\"\/><\/figure>\n\n\n\n<p>Access to the endpoint database, choose to provide access information manually.<\/p>\n\n\n\n<p>It automatically fetches the Target DB endpoint, Port, and User name.<\/p>\n\n\n\n<p>Make the required changes if any and Enter the Password of the PostgreSQL RDS DB instance.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/SUSKW0FIS4ZPWPxxjVsdtgNwNSwGgX099GCeTX2DyIGfo2oG24G0yZy150K-vRufCp-jhn9N72TDMd4IM06whUl6ASe-52AB-hVhoLoIz6v4vNtk2UavXpg-uaTrBFRK-nrE5rXJ\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>And Enter the Target Database name.<\/p>\n\n\n\n<p>We can test the connectivity to the RDS PostgreSQL DB instance, to expand test endpoint connection (optional).<\/p>\n\n\n\n<p>Choose the VPC and the Replication instance and then click Run test.<\/p>\n\n\n\n<p>If the provided information is correct, the connectivity test should be successful.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/3wKTUCGDwekR-Q9ATrsOAQ2Rvc0qQNCjH3k7PdZedHzxd6dqzOeisbks5yp6opKwBgWsXQ3NxHe-oHuH18F__vpX5vJ_Eln5qGjVr4eQmCzZ79tEV9oekxx949qXcRo-EnkreJiA\" alt=\"\"\/><\/figure>\n\n\n\n<p>And at last click Create endpoint.<\/p>\n\n\n\n<p>The Endpoint for the RDS PostgreSQL instance is created successfully and is Active.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/1wCWHrbGUp5gIScAuQ5hB-NE72U-nIPbbDhTZSCP9YDlWTo2bbCE4TDTncIsXB_AG3r0i9STXs-FTX-wVs-mJ6zfc8bIDiAVmMQJeueazGXdwfsEmjgSy4PIId7j0k1l1h5X7QSK\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<h4>Creating Database Migration Task<\/h4>\n\n\n\n<p>To create a migration task, in the navigation pane, click Database migration tasks.<\/p>\n\n\n\n<p>Click create task, enter the name for the task.<\/p>\n\n\n\n<p>Select the Replication instance that you have created.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh5.googleusercontent.com\/KwWLTnOjPYdPi3g4aFwyElaj4NZKCldWk-XwYRj1O3r6dUxnt45SByBpy2t7wf-BTynMttqBsscHEw_YEdX8hxW07kqGu1aMQ_qzoGndcCxGu0RfvkcS1LkuAnn_uKCEqpOIx1yf\" alt=\"\"\/><\/figure>\n\n\n\n<p>Select the Source database endpoint and the target database endpoint.<\/p>\n\n\n\n<p>For the Migration type, select Migrate existing data.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/kSOuiw4B_EpFH-B3zbeyew5fCg68ZqdptRsq6pZM43GV_wExT6mCIbXCIZpPfGg0g6HnK4taGQVbGYIe-PCEyHzkapoKdLkhxL4GIIlWbguHVTtIMWawl1MMxhgT1AJWPNClWSJl\" alt=\"\"\/><\/figure>\n\n\n\n<p>As we perform migration from MySQL to PostgreSQL engine, the AWS schema conversion tool will automatically convert the database scheme.<\/p>\n\n\n\n<p>Under Task settings,<\/p>\n\n\n\n<p>For the Target table preparation mode, choose Do nothing<\/p>\n\n\n\n<p>To Include LOB columns in replication, choose Limited LOB mode and the Maximum LOB size be 32KB.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/F7QyQUOZ8P4y-wlRxKsOXv6HjHoTucvQ3tH2TlyNwIiLUI5ogsT-MXuy_fRpxXoSNd7vMBDQ8tbfhL5SS8jrN5WhSw4BenRmbKyB04VE9kjsBRb-FdO3ndiwNK_zWCTx-JoMpilE\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>For Table mappings, add a new selection rule.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/fvoCazH1_pQNbBvvGLT4gpnax60QmBRqOrcJcov_svSLgZgMoY81wPtqSAVLzrNfLzXjfDyrHOI2NhZANiHAEjAQ5_DptIMVAmVfExRlaJgjI6uazh4FZTlwY7v2lSHQl9ohyuxn\" alt=\"\"\/><\/figure>\n\n\n\n<p>For Migration task startup configuration, choose Automatically on create.<\/p>\n\n\n\n<p>And finally click create task which will start the migration process immediately.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/pdnTHU3S0zexb3JNjIeVzNuceZpcfYu0gHG2GZIUcAibPd9YbZAm0FZFwM-GkpNGsO5DUKGzx1v8TJWnyM8h0uxEb_zvca2N4XhKxlofHN9zFTV_0OEO_F3IlfIA_kTdHdAlvrGf\" alt=\"\"\/><\/figure>\n\n\n\n<p>The Database migration task creation is in progress.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh3.googleusercontent.com\/QvoxpTFTJLGrhdLhADnsEfdzVJbAaw6lJP1RcwUeg4TDe_6TNOSLLbobZYsveIuDG6dxv_NrcwN5ACb2NrbskjF-SRD4PmV828a5z_ix8NMTi99HOX6yCu2XRelJPuWfWriupCeZ\" alt=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"\/><\/figure>\n\n\n\n<p>The Migration task is ready now.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh6.googleusercontent.com\/YOxReNIh1DMLqFiHuTzuZndTQ2J6E3TokaUuekHfgRKpF_JfOcT_0EU3PYFqYQXZxd2ur50ycd1XLOLjktKipTMeLMpFxsn3Gz6R4IfnSo6dSecfHvyg-MGSJTc5RlVFk3nB8340\" alt=\"\"\/><\/figure>\n\n\n\n<p>And you can see the migration process has started immediately.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/lh4.googleusercontent.com\/cjVQuV02TLvN2cRscDArPmnp1sW19eQb7uhrC4IwpSVu-9btV7e4Uvn6duuyrJpBYiDMkU3L1z4Fz1zLVj8ZX7xbQ7Cgh8We2vrb2oiX1-D2vOmy4NNcOJmAG11zixNv8dxGnsSi\" alt=\"\"\/><\/figure>\n\n\n\n<h2>Conclusion<\/h2>\n\n\n\n<p class=\"has-text-align-justify\">AWS Database Migration Service supports homogeneous migrations such as MySQL to MySQL, and also heterogeneous migrations between different database platforms, such as MySQL to PostgreSQL. In this blog, we have successfully migrated from the RDS MySQL DB instance to the RDS PostgreSQL DB instance using AWS Database Migration Service. The existing migration task can be used for replicating new data inserted into the MySQL DB engine. You can use AWS DMS to migrate your data to and from the most widely used commercial and open-source databases such as Oracle, Amazon Redshift,&nbsp; Microsoft SQL Server, Amazon Aurora, PostgreSQL, MariaDB, and MySQL. Stay tuned to keep getting all updates about our upcoming new blogs on AWS and relevant technologies.<\/p>\n\n\n\n<p>Meanwhile \u2026<\/p>\n\n\n\n<p><strong>Keep Exploring -&gt; Keep Learning -&gt; Keep Mastering<\/strong><\/p>\n\n\n\n<p class=\"has-text-align-justify\">This blog is part of our effort towards building a knowledgeable and kick-ass tech community. At <a href=\"http:\/\/www.workfall.com\">Workfall<\/a>, we strive to provide the best tech and pay opportunities to AWS-certified talents. If you\u2019re looking to work with global clients, build kick-ass products while making big bucks doing so, give it a shot at <a href=\"http:\/\/workfall.com\/partner\">workfall.com\/partner<\/a> today.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\">7<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span> Do you want to migrate data from one type of DB engine (MySQL) to another type of DB engine(PostgreSQL) with little or no downtime? In today&#8217;s fast-paced environment, application, and database availability must be considered 24 hours a day, seven days a week. Some of your applications may be unable to tolerate substantial downtime while [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":222,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":""},"categories":[2],"tags":[3,4,48,49,50,51,6],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)? - The Workfall Blog<\/title>\n<meta name=\"description\" content=\"AWS DMS is a cloud service that is one of the easiest ways to migrate relational databases, data warehouses, and other types of data stores.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)? - The Workfall Blog\" \/>\n<meta property=\"og:description\" content=\"AWS DMS is a cloud service that is one of the easiest ways to migrate relational databases, data warehouses, and other types of data stores.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/\" \/>\n<meta property=\"og:site_name\" content=\"The Workfall Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/workfall\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-27T15:14:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-22T08:06:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@workfall\" \/>\n<meta name=\"twitter:site\" content=\"@workfall\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Workfall\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#organization\",\"name\":\"Workfall - Hire #Kickass Coders On Demand\",\"url\":\"https:\/\/learning.workfall.com\/learning\/blog\/\",\"sameAs\":[\"https:\/\/www.instagram.com\/workfall\/\",\"https:\/\/www.linkedin.com\/company\/workfall\/\",\"https:\/\/facebook.com\/workfall\",\"https:\/\/twitter.com\/workfall\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400\",\"contentUrl\":\"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400\",\"width\":400,\"height\":400,\"caption\":\"Workfall - Hire #Kickass Coders On Demand\"},\"image\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#website\",\"url\":\"https:\/\/learning.workfall.com\/learning\/blog\/\",\"name\":\"The Workfall Blog\",\"description\":\"#Tech #Remote #Jobs\",\"publisher\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learning.workfall.com\/learning\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#primaryimage\",\"url\":\"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png\",\"contentUrl\":\"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png\",\"width\":1200,\"height\":628,\"caption\":\"AWS Database Migration Service\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#webpage\",\"url\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/\",\"name\":\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)? - The Workfall Blog\",\"isPartOf\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#primaryimage\"},\"datePublished\":\"2021-10-27T15:14:16+00:00\",\"dateModified\":\"2025-08-22T08:06:38+00:00\",\"description\":\"AWS DMS is a cloud service that is one of the easiest ways to migrate relational databases, data warehouses, and other types of data stores.\",\"breadcrumb\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learning.workfall.com\/learning\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#webpage\"},\"author\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/person\/cab8236044692bc5b27606b13167794a\"},\"headline\":\"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?\",\"datePublished\":\"2021-10-27T15:14:16+00:00\",\"dateModified\":\"2025-08-22T08:06:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#webpage\"},\"wordCount\":1164,\"publisher\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png\",\"keywords\":[\"AWS\",\"Cloud\",\"cloudmigration\",\"databasemigration\",\"mysql\",\"postgresql\",\"workfall\"],\"articleSection\":[\"AWS Cloud Computing\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/person\/cab8236044692bc5b27606b13167794a\",\"name\":\"Workfall\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_1_1693914404-96x96.png\",\"contentUrl\":\"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_1_1693914404-96x96.png\",\"caption\":\"Workfall\"},\"sameAs\":[\"https:\/\/www.workfall.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)? - The Workfall Blog","description":"AWS DMS is a cloud service that is one of the easiest ways to migrate relational databases, data warehouses, and other types of data stores.","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:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/","og_locale":"en_US","og_type":"article","og_title":"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)? - The Workfall Blog","og_description":"AWS DMS is a cloud service that is one of the easiest ways to migrate relational databases, data warehouses, and other types of data stores.","og_url":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/","og_site_name":"The Workfall Blog","article_publisher":"https:\/\/facebook.com\/workfall","article_published_time":"2021-10-27T15:14:16+00:00","article_modified_time":"2025-08-22T08:06:38+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_creator":"@workfall","twitter_site":"@workfall","twitter_misc":{"Written by":"Workfall","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#organization","name":"Workfall - Hire #Kickass Coders On Demand","url":"https:\/\/learning.workfall.com\/learning\/blog\/","sameAs":["https:\/\/www.instagram.com\/workfall\/","https:\/\/www.linkedin.com\/company\/workfall\/","https:\/\/facebook.com\/workfall","https:\/\/twitter.com\/workfall"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400","contentUrl":"https:\/\/i1.wp.com\/18.141.20.153\/learning\/blog\/wp-content\/uploads\/2021\/10\/cropped-WF_logo.png?fit=400%2C400","width":400,"height":400,"caption":"Workfall - Hire #Kickass Coders On Demand"},"image":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#website","url":"https:\/\/learning.workfall.com\/learning\/blog\/","name":"The Workfall Blog","description":"#Tech #Remote #Jobs","publisher":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learning.workfall.com\/learning\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#primaryimage","url":"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png","contentUrl":"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png","width":1200,"height":628,"caption":"AWS Database Migration Service"},{"@type":"WebPage","@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#webpage","url":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/","name":"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)? - The Workfall Blog","isPartOf":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#primaryimage"},"datePublished":"2021-10-27T15:14:16+00:00","dateModified":"2025-08-22T08:06:38+00:00","description":"AWS DMS is a cloud service that is one of the easiest ways to migrate relational databases, data warehouses, and other types of data stores.","breadcrumb":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learning.workfall.com\/learning\/blog\/"},{"@type":"ListItem","position":2,"name":"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?"}]},{"@type":"Article","@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#article","isPartOf":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#webpage"},"author":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/person\/cab8236044692bc5b27606b13167794a"},"headline":"How to migrate RDS MySQL database to RDS PostgreSQL database using AWS Database Migration Service(DMS)?","datePublished":"2021-10-27T15:14:16+00:00","dateModified":"2025-08-22T08:06:38+00:00","mainEntityOfPage":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#webpage"},"wordCount":1164,"publisher":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/#organization"},"image":{"@id":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-migrate-rds-mysql-database-to-rds-postgresql-database-using-aws-database-migration-servicedms\/#primaryimage"},"thumbnailUrl":"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png","keywords":["AWS","Cloud","cloudmigration","databasemigration","mysql","postgresql","workfall"],"articleSection":["AWS Cloud Computing"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/person\/cab8236044692bc5b27606b13167794a","name":"Workfall","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learning.workfall.com\/learning\/blog\/#\/schema\/person\/image\/","url":"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_1_1693914404-96x96.png","contentUrl":"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2023\/09\/avatar_user_1_1693914404-96x96.png","caption":"Workfall"},"sameAs":["https:\/\/www.workfall.com"]}]}},"jetpack_featured_media_url":"https:\/\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/10\/DMS.png","jetpack-related-posts":[{"id":614,"url":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-do-database-migration-using-aws-database-migration-service-dms-from-on-premise-ec2-to-rds\/","url_meta":{"origin":221,"position":0},"title":"AWS DMS: Migrating On-Premise\/EC2 Databases to RDS Made Simple","date":"November 11, 2021","format":false,"excerpt":"Do you want to migrate your on-premise databases to AWS with minimal or no downtime? In today\u2019s fast-paced world,\u00a024\/7 application and database availability are the basic criteria to consider. In this case, some of your applications may not be able to afford significant downtime while migrating on-premises databases. In this\u2026","rel":"","context":"In &quot;AWS Cloud Computing&quot;","img":{"alt_text":"Database Migration using AWS Database Migration Service (DMS)","src":"https:\/\/i0.wp.com\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/11\/DMS.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":554,"url":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-improve-application-availability-with-amazon-rds-proxy\/","url_meta":{"origin":221,"position":1},"title":"How to improve Application Availability with Amazon RDS Proxy?","date":"November 10, 2021","format":false,"excerpt":"If you are running applications with unpredictable workloads which require frequent open and close database connections and you also want to maintain high availability during transient database failure, the Amazon RDS proxy is the solution! It minimizes application disruption from outages affecting the availability of DB, by automatically connecting to\u2026","rel":"","context":"In &quot;AWS Cloud Computing&quot;","img":{"alt_text":"Amazon RDS Proxy Application - Workfall","src":"https:\/\/i2.wp.com\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/11\/RDSProxy.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":785,"url":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-perform-an-amazon-aurora-database-deployment-that-replicates-data-and-spans-across-multiple-aws-regions\/","url_meta":{"origin":221,"position":2},"title":"How to perform an Amazon Aurora Database deployment that replicates data and spans across multiple AWS regions?","date":"November 30, 2021","format":false,"excerpt":"Amazon Web Services provides us with the flexibility of managing the data in the databases with ease. The flexibility is thus provided by an AWS Service called Amazon Aurora. An Amazon Aurora cluster contains one or more DB instances and a cluster volume that helps us manage the data for\u2026","rel":"","context":"In &quot;AWS Cloud Computing&quot;","img":{"alt_text":"Amazon Aurora Database Deployment","src":"https:\/\/i0.wp.com\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/11\/CoverImages_1200x628px-8.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":596,"url":"https:\/\/learning.workfall.com\/learning\/blog\/demand-backups-and-restore-the-backup-for-amazon-rds-using-aws-backuppart-2\/","url_meta":{"origin":221,"position":3},"title":"How to create on-demand backups and restore the backup for Amazon RDS using AWS Backup(Part 2)?","date":"November 11, 2021","format":false,"excerpt":"AWS Backup enables you to centralize and automate data protection across AWS services. AWS Backup is a low-cost, fully managed, policy-based solution that makes data protection at scale even easier. AWS Backup also assists you in meeting your regulatory compliance duties and business continuity objectives. In this article, we'll look\u2026","rel":"","context":"In &quot;AWS Cloud Computing&quot;","img":{"alt_text":"Amazon Backup - Workfall","src":"https:\/\/i0.wp.com\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/11\/CoverImages_1200x628px-2.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1680,"url":"https:\/\/learning.workfall.com\/learning\/blog\/create-a-no-code-graphql-server-using-hasura-and-postgresql\/","url_meta":{"origin":221,"position":4},"title":"Create a No-code GraphQL Server Using Hasura and PostgreSQL","date":"March 28, 2023","format":false,"excerpt":"To handle CRUD, authorization, and business logic, backend developers frequently need to write several lines of code. All of this code must be tested, debugged, and maintained for the duration of the project. This consumes a significant amount of time that developers could be used to create new features. This\u2026","rel":"","context":"In &quot;Backend Development&quot;","img":{"alt_text":"No-code GraphQL Server Using Hasura and PostgreSQL","src":"https:\/\/i0.wp.com\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2023\/03\/Cover-Images_Part2-1-3.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":541,"url":"https:\/\/learning.workfall.com\/learning\/blog\/how-to-build-a-serverless-event-driven-workflow-with-aws-glue-and-amazon-eventbridgepart-1\/","url_meta":{"origin":221,"position":5},"title":"How to build a serverless event-driven workflow with AWS Glue and Amazon EventBridge(Part 1)?","date":"November 10, 2021","format":false,"excerpt":"Have you ever wondered how huge IT companies construct their ETL pipelines for production? Are you curious about how TBs and ZBs of data are effortlessly captured and rapidly processed to a database or other storage for data scientists and analysts to use? The answer is the serverless data integration\u2026","rel":"","context":"In &quot;AWS Cloud Computing&quot;","img":{"alt_text":"AWS Glue","src":"https:\/\/i1.wp.com\/learning.workfall.com\/learning\/blog\/wp-content\/uploads\/2021\/11\/Glue.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/posts\/221"}],"collection":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":7,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"predecessor-version":[{"id":2241,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/posts\/221\/revisions\/2241"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/media\/222"}],"wp:attachment":[{"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learning.workfall.com\/learning\/blog\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}