INSIGHTS

INSIGHTS

clock icon

2 min read

Blog thumbnail
Published on 06/23/2021
Last updated on 02/05/2024

Data Migration from MariaDB to Redshift using AWS Data Migration Service (DMS)

Share

The AWS Database Migration Service (DMS) helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. With the AWS Database Migration Service, you can migrate your data to and from most widely used commercial and open-source databases.

The following steps explain how to migrate a database from the AWS MariaDB to AWS Redshift using DMS.

Step 1: Create DMS replication instance

From the DMS console, select Replication instances and then Create replication instance.

Data-Migration-1.png

Data-Maigration-2.png

Data-Migration-3.png

Step 2: Create DMS Source Endpoint

From DMS console, select Endpoints: and then Create endpoint. Select the respective ARN under Server name, port and credentials for the MariaDB instance to be connected.

Data-Migration-4.png

Data-Migration-6.png

Step 3: Create DMS Target Endpoint

In order to create a target endpoint for your Redshift cluster, we need the following IAM role associated with a Redshift cluster for DMS to access it.

Data-Migration-7.pngData-Migration-8.png

Data-Migration-9.png

Now from the DMS console, select Endpoints and then Create endpoint. Select respective ARN under Server name, port, credentials and database name to connect the Redshift cluster.

Data-Migration-10.pngData-Migration-11.png

 

Step 4: Create Database Migration Task

Now from the DMS console, select Database migration tasks and Create task.

Select the respective replication instance, source and target endpoints created above from the dropdown list and other specifications as needed.

Data-Migration-12.pngData-Migration-13.pngData-Migration-14.png

Based on the option selected above, the database migration task is automatically started after creating the task. This task can be executed periodically on a specified schedule using a Lambda function.

Once the task is completed (you’ll see Load complete), we should see the db, schema and tables in your target Redshift cluster.

Data-Migration-15.png

The above screenshot shows the schema with countrydata and table. countrycaps is migrated from MariaDB in Redshift.

Once these tables are available, we can execute queries in Redshift on this DB as well as across other DBs within the Redshift cluster.

Data-Migration-16.png

Data-Migration-L.png

Subscribe card background
Subscribe
Subscribe to
the Shift!

Get emerging insights on emerging technology straight to your inbox.

Unlocking Multi-Cloud Security: Panoptica's Graph-Based Approach

Discover why security teams rely on Panoptica's graph-based technology to navigate and prioritize risks across multi-cloud landscapes, enhancing accuracy and resilience in safeguarding diverse ecosystems.

thumbnail
I
Subscribe
Subscribe
 to
The Shift
!
Get
emerging insights
on innovative technology straight to your inbox.

The Shift is Outshift’s exclusive newsletter.

Get the latest news and updates on cloud native modern applications, application security, generative AI, quantum computing, and other groundbreaking innovations shaping the future of technology.

Outshift Background