Lift-and-Shift to MariaDB SkySQL

Migration is the process of permanently moving data from one database to another.

Lift-and-Shift is a type of migration where no material application or data changes are needed since the underlying database platforms have the same functional capabilities.

Process Compatibility

Lift-and-Shift to MariaDB SkySQL is possible from:

  • Existing SkySQL instances, backed by 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

For migrations from MySQL, Oracle, Microsoft SQL, IBM DB2, etc. see Migration.

Benefits of Moving to MariaDB SkySQL

Benefits of moving from an existing MariaDB Server implementation to MariaDB SkySQL include:

  • New database services deployed on-demand and you pay for what you use.

  • Operations features to reduce customer overhead, including scheduled upgrades, automated nightly backups, configuration management, and monitoring.

  • Support from MariaDB Corporation

  • MariaDB Enterprise Server, which extends the capabilities of the widely-deployed MariaDB Community Server with enterprise-focused advanced features and optimized builds.

  • Ability to access latest MariaDB Enterprise Server (ES) releases for use in production and testing, now featuring ES 10.5 and ES 10.4. Recently expanded features include:

    • Temporal Tables

    • Instant ALTER table with InnoDB

    • Integration with the MariaDB ColumnStore (columnar for analytics) and MariaDB Xpand (distributed SQL) storage engines

    • MariaDB Enterprise Audit

    • Backports to older releases for high-value Enterprise Server features such as backup locks

  • MariaDB Enterprise-backed services which are optimized for transactional (OLTP), analytical (OLAP, DSS, cloud data warehousing), and hybrid (HTAP) workloads.

Lift-and-Shift Process

MariaDB assistance is available at each step of this 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

For assistance, create a new support case via the Customer Support Portal.

Break the Cycle Using SkySQL

Some critics of lift-and-shift migrations point out that despite cost and feature benefits, problems in the source environment are often carried forward into the new environment -- "same mess, new address". MariaDB SkySQL includes features to help break this cycle.

  • MariaDB Enterprise Server maintains extensive feature compatibility with MariaDB Enterprise Server and MariaDB Community Server, enabling friction-less migration to MariaDB SkySQL.

  • MariaDB Enterprise Server's pluggable storage engine architecture enables optimization for highly available transactional workloads, analytical workloads, and for distributed SQL with fault tolerance.

  • With operations activities such as nightly backups, infrastructure management, and version upgrades handled by SkySQL, you free staff time to focus on your core business requirements.

  • SkySQL enables the creation of multiple production-like environments in parallel for on-demand testing, and environments can be stopped when not in use and deleted when they are no longer needed.

  • SkySQL-to-SkySQL migrations can be used to reduce instance sizes, change application architecture, and to test optimizations, all with a fallback path.

  • Features such as SkySQL Monitoring and SkySQL Workload Analysis (available as a Technical Preview), support diagnosis of bottlenecks and opportunities for optimization.