Migrations

MariaDB Cloud migration paths: REST-API-managed migrations and self-managed logical-dump and replication options, supporting on-premise and cloud sources from major database platforms.

MariaDB Cloud provides a range of options to suit different migration scenarios.

• Databases can be migrated to MariaDB Cloud from many different database platforms, including Oracle, MySQL, PostgreSQL, Microsoft SQL Server, IBM DB2, and more.

• MariaDB Cloud supports migration from both on-premise and cloud-based infrastructure and provides a range of options to suit different migration scenarios.

Below are the most common scenarios for database migration to MariaDB Cloud.

Prerequisites

1. An active MariaDB Cloud account.

2. An existing source database with the IP added to your MariaDB Cloud allowlist.

Considerations

Ensure that your MariaDB Cloud service deployment configuration is compatible with the one for your existing source database, including:

• Deployment region - Ensure that the MariaDB Cloud deployment region is the same as the source database region.

• Topology - Mariadb Server Single node or with Replica(s).

• Server version - Ensure that the MariaDB Cloud server version is compatible with the source database version.

• Instance size - Ensure that the MariaDB Cloud instance is compatible with the source database instance type and size.

• Storage - Ensure that the MariaDB Cloud storage type and size is compatible with the source database.

CloudDBA Assisted Migration

• Existing customers can submit a support case to request assistance with a migration.

• New customers can contact us to begin the migration planning process.

Our CloudDBA team can help design a migration plan to suit your needs.

CloudDBA Assisted Migration Approach

We use a multi-step process to assist customers with migrations:

• Assessment of application requirements, inventory, and identified challenges.

• Schema Migration including tables, constraints, indexes, and views.

• Application Code Migration by porting and testing SQL and application code.

• Data Migration and Replication with import of data, with conversion to the new schema, and ongoing inbound replication of new data.

• Quality Assurance to assess data validity, data integrity, performance, accuracy of query results, stored code, and running code such as client applications, APIs, and batch jobs.

• Cutover including final database preparation, fallback planning, switchover, and decommissioning of old databases.

Self-Service Migration to MariaDB Cloud

MariaDB Cloud provides two different options for self-service migration.

Option 1: Migrate Using the MariaDB Cloud REST API

MariaDB Cloud Managed Migration is a REST-based service that handles the migration process, including data migration, schema migration, and user migration. It provides a follow us steps to set up a live replication of your database to MariaDB Cloud and various insights to monitor the migration process.

• MariaDB Cloud Managed Migration Tutorial

Option 2: Custom Migration

For most small, mid-size and large migrations MariaDB Cloud Managed Migration is the quickest and safest option. However, for large migrations or migrations with specific requirements, you and your team may require more flexibility and control over the migration process. In these cases, you and your team can design a custom migration plan considering the options suggested below.

• Migrating Using a Logical Dump and Replication

• Importing data using Mariadb Import

• Importing using CSV Data

• Replicating Data from an External DB