You Know You Want To: Migrate from Oracle to MariaDB

Posted on 2月 27, 2020 by

Over the past few years, MariaDB Corporation has heard from countless Oracle database users seeking to replace their database platform to achieve a lower cost and increased operational flexibility. Our new whitepaper, “Lower TCO without Lowering Standards: Migrate to MariaDB Platform from Oracle” provides a roundup of key decision points and our experiences in guiding customers through successful application migrations. What did we learn along the way?

MariaDB Platform frees companies from the costs, constraints, and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing applications.

MariaDB Has a Feature Advantage

MariaDB Platform can achieve a consolidation of architecture, can simplify deployments, and can use the same functionality throughout the ecosystem. With performance scale-out through hardware and no notion of limited additions, it’s cost-effective.

MariaDB Platform includes features not found in proprietary database platforms:

  • MariaDB’s pluggable storage engines can be used on a per-table basis, allowing you to tailor your database to application demands for write-intensive, general purpose, and columnar data storage. Transactions can query and join across multiple storage engines.
  • A fully cloud-native storage architecture, capable of storing data in row format on block storage for transactional workloads, and columnar format on object storage for analytical workloads. MariaDB ColumnStore can use any object storage compatible with the Amazon S3 API, whether on public cloud or on-premises software/hardware.
  • Built-in smart transactions. MariaDB Platform is the only open source relational database to use both row and columnar storage. This enables standard transactions to be infused with analytics for smarter transactions.
  • Multi-threaded architecture to scale performance with the number of cores/processors. MariaDB Platform improves scalability and performance using an advanced database proxy and multiple, purpose-built storage engines.

MariaDB Has a TCO Advantage

We’ve included a cost comparison in the whitepaper, using published list prices based on a minimal configuration capable of meeting standard enterprise requirements for a database.

We found that after three years running on three on-premises servers, each with two, 16-core processors, the total cost of Oracle is 84x higher than MariaDB Platform, and organizations can save over $9 million after three years by choosing MariaDB Platform.

The savings are very real for our customers. The largest bank in Southeast Asia, the Development Bank of Singapore (DBS), saved 90% of their total cost for databases by migrating mission-critical applications to MariaDB Platform.

MariaDB Has Feature Parity Where It Counts

Trusted by organizations like Deutsche Bank, DBS, Nasdaq, Red Hat, ServiceNow, Verizon, and Walgreens – MariaDB Platform meets the same core requirements as proprietary databases, but at a fraction of the cost.

MariaDB provides the functionality you count on from an enterprise class DBMS including:

  • ACID compliance, referential integrity, transactions
  • Unicode UTF-8
  • Transparent data encryption
  • Foreign keys
  • UNION, INTERSECT, EXCEPT, Joins
  • Common Table Expressions (CTE), Window Functions
  • Temporal tables (System Versioned, Application Time-Period, Bitemporal)
  • Cursors, triggers, functions, events, procedures, dynamic SQL, sequences
  • Set operators, table value constructors
  • User-defined aggregate functions, ordered-set aggregate functions
  • Partitioning and sharding
  • Point-in-time rollback
  • Invisible columns, generated or virtual columns

There Is a Clear Migration Path

MariaDB has helped numerous companies save money and improve operations by migrating from Oracle. MariaDB Enterprise Server includes features specifically designed to smooth the transition and reduce migration time and costs, and enable DBAs and developers to continue to apply their Oracle Database knowledge. These features, such as the PL/SQL compatibility parser – called SQL/PL in MariaDB Server – are described in more detail in the white paper.

Learn more about the 6-step migration methodology MariaDB experts have developed in “Lower TCO without Lowering Standards: Migrate to MariaDB Platform from Oracle.”