Migrate an on-premises MariaDB database to Amazon RDS for MariaDB using native MySQL tools - AWS Prescriptive Guidance

Migrate an on-premises MariaDB database to Amazon RDS for MariaDB using native MySQL tools

R Type: Replatform

Source: Databases: Relational

Target: Amazon RDS for MariaDB

Created by: AWS

Environment: PoC or pilot

Technology: Databases

Workload: Open-source

Summary

This pattern provides guidance for migrating an on-premises MariaDB database to Amazon Relational Database Service (Amazon RDS) for MariaDB using native MySQL tools such as mysqldump and mysql.

Prerequisites and limitations

Prerequisites

  • An active AWS account

  • A MariaDB source database in an on-premises data center

Limitations

  • Database size limit: 64 TB

Product versions

  • MariaDB versions 10.0-10.3 (for the latest list of supported versions, see MariaDB on Amazon RDS in the AWS documentation)

Architecture

Source technology stack

  • MariaDB database in an on-premises data center

Target technology stack

  • Amazon RDS for MariaDB DB instance

Target architecture

Data migration architecture

Tools

  • Native MySQL tools: mysqldump and mysql

Epics

Task Description Skills required
Validate source and target database versions and engines. DBA
Identify hardware requirements for the target server instance. DBA, SysAdmin
Identify storage requirements (storage type and capacity). DBA, SysAdmin
Choose the proper instance type based on capacity, storage features, and network features. DBA, SysAdmin
Identify the network access security requirements for source and target databases. DBA, SysAdmin
Identify the application migration strategy. DBA, SysAdmin, AppOwner
Task Description Skills required
Create a virtual private cloud (VPC). SysAdmin
Create security groups. SysAdmin
Configure and start an Amazon RDS DB instance running MariaDB. SysAdmin
Task Description Skills required
Use native MySQL tools or third-party tools to migrate database objects and data. In the source database, use mysqldump to create an output file that contains database objects and data. In the target database, use mysql to restore the data. DBA
Validate the data. Check the source and target databases to confirm that the data migration was successful. DBA
Task Description Skills required
Follow the application migration strategy. DBA, SysAdmin, AppOwner
Task Description Skills required
Switch the application clients over to the new infrastructure. DBA, SysAdmin, AppOwner
Task Description Skills required
Shut down the temporary AWS resources. SysAdmin
Review and validate the project documents. DBA, SysAdmin, AppOwner
Gather metrics around time to migrate, % of manual vs. tool cost savings, etc. DBA, SysAdmin, AppOwner
Close out the project and provide feedback. DBA, SysAdmin, AppOwner

References

Tutorials and videos