Migrations
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
An active MariaDB Cloud account.
An existing source database with the IP added to your MariaDB Cloud allowlist.
Considerations
Ensure that your MariaDB Cloud servce deploymned configuration is compatible with your existing source database one, 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 diffeent 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.
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.
Last updated
Was this helpful?