Lift-and-Shift to MariaDB SkySQL

Overview

Databases can be migrated from MariaDB Server to MariaDB SkySQL using a list-and-shift approach:

  • With a lift-and-shift migration, the underlying database platforms on the source and migration target have the same functional capabilities, so no material application or data changes are required

  • SkySQL offers multiple workload-optimized services for transactional (OLTP) and analytical (OLAP, DSS, cloud data warehousing) workloads

  • SkySQL provides multiple support options to help manage your database

  • SkySQL monitors your databases using SkySQL Monitoring

  • SkySQL helps diagnose bottlenecks and discover opportunities for optimization using SkySQL Workload Analysis (Technical Preview)

For migrations from other database platforms, see Migration.

For assistance with a 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

Use Cases

MariaDB SkySQL supports using a lift-and-shift approach to migrate from MariaDB Server environments, such as:

  • Existing SkySQL services that use MariaDB Enterprise Server

  • On-premises deployments of MariaDB Enterprise Server

  • On-premises deployments of MariaDB Community Server

  • Amazon RDS for MariaDB, based on MariaDB Community Server

  • Microsoft Azure for MariaDB, based on MariaDB Community Server

  • Other cloud, VPS, shared, or hosted database services backed by MariaDB Community Server

Compatibility

  • Distributed Transactions

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

Lift-and-Shift Process

To perform a lift-and-shift migration to SkySQL, use the following process:

  1. Identify requirements for your MariaDB SkySQL implementation including:

  2. Deploy the desired configuration on MariaDB SkySQL

  3. Back up your existing database and restore to MariaDB SkySQL

  4. Establish inbound replication to MariaDB SkySQL

  5. Perform application testing against MariaDB SkySQL

  6. Plan your cutover, including fallback planning

  7. Execute a scheduled application cutover to MariaDB SkySQL

  8. Perform application testing against MariaDB SkySQL