High Level Maria DB Migration Plan

Pre-migration Phase (No -downtime)

• Validate source and target database versions and engines.
• Identify hardware requirements for the target server instance.
• Identify storage requirements (storage type and capacity).
• Choose the proper instance type based on capacity, storage features, and network features.
• Identify the network access security requirements (firewall, port etc. ) for source and target databases.
• Prepare target database
• Configure and start an Amazon RDS DB instance running MariaDB.

 

Migration Phase (downtime)

• Using native tools to migrate database objects and data.
• In the source database, use mysqldump or mariadb-dump to create an output file that contains database objects and data.
• Transfer the backup to target (AWS RDS)
• In the target database, use mysql or mariadb to restore the data.
• Validate the migrated database.

 Post-migration Phase (downtime)

• Handover database to application team
• Switch the application clients over to the new migration database in AWS RDS .
• Application team start validation
• Decide Go-Live /No Go-Live
• Target database golden backup
• Release database and application

Rollback Plan 

• Start source database (Assume no data chnage on target database  after migration)
• Connect & validate Application with source database