Severalnines Blog
The automation and management blog for open source databases

How to Migrate from Oracle DB to MariaDB

Jean-Jérôme Schmidt
Posted in:

Migrating from Oracle database to MariaDB can come with a number of benefits: lower cost of ownership, access to and use of an open source database engine, tight integration with the web, an active community of MariaDB database users and more.

Over the years MariaDB has gained Enterprise support and maturity to run critical and complex data transaction systems. With the recent version, MariaDB has added some great new features such as SQL_Mode=Oracle compatibility, making the transition process easier than ever before.

Whether you’re planning to migrate from Oracle database to MariaDB manually or with the help of a commercial tool to automate the entire migration process, you need to know all the possible bottlenecks and methods involved in the process and the results validation.

Watch this webinar replay as we walk you through all you need to know to plan and execute a successful migration from Oracle database to MariaDB.

Agenda

  • A brief introduction to the platform
    • Oracle vs MariaDB
    • Platform support
    • Installation process
    • Database access
    • Backup process
    • Controlling query execution
    • Security
    • Replication options
  • Migration
    • Planning and development strategy
    • Assessment or preliminary check
    • Data type mapping
    • Migration tools
    • Migration process
    • Testing
  • Post-migration
    • Monitoring and Alerting
    • Performance Management
    • Backup Management
    • High availability
    • Upgrades
    • Scaling
    • Staff training

Speaker

Bartlomiej Oles is a MySQL and Oracle DBA, with over 15 years experience in managing highly available production systems at IBM, Nordea Bank, Acxiom, Lufthansa, and other Fortune 500 companies. In the past five years, his focus has been on building and applying automation tools to manage multi-datacenter database environments.

Watch replay