Migrating your existing Production DB
Databases can be migrated to MariaDB SkySQL from many different database platforms, including Oracle, MySQL, PostgreSQL, Microsoft SQL Server, IBM DB2, and more
Lift-and-shift from a compatible version of MySQL/MariaDB to SkySQL
To perform a lift-and-shift migration to SkySQL, use the following process:
- Identify requirements for your MariaDB SkySQL implementation including:
- Topology
- Instance size
- Storage requirements
- Desired server version
- Deploy the desired configuration on MariaDB SkySQL
- On the source database (MySQL or MariaDB) obtain the Binlog file name and its current position. Essentially, we want to track all DB changes from a certain point in time. See ‘Replicating data’ page for the command.
- Next, take a dump of your source database using mysqldump or mariadb-dump
- Import into your target SkySQL DB using this logical “dump” (SQL)
- Finally, turn ON the replication using the SkySQL ‘start_replication’ procedure as noted below.
Assisted Migration to SkySQL MariaDB
SkySQL customers can receive assistance from SkySQL Inc when migrating a database to SkySQL:
- SkySQL Inc's migration process divides a migration into multiple well-defined stages with distinct validation criteria at each stage
- SkyDBAs and SkySQL support can assist with many migration steps
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
Migration Process
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
For additional information, see "Whitepaper: Migrate to MariaDB from Oracle".
Migrate to MariaDB SkySQL using AWS DMS
This blog article details how to Migrate RDS MySQL to SkySQL MariaDB Using AWS Data Migration Service
Replicating data from an External DB
Click here for a detailed walk through of the steps involved.
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