
MariaDB is an open-source, multi-threaded, relational database management system (RDBMS). Starting with version 10.3, MariaDB has introduced Oracle Compatibility features in MariaDB, which can be leveraged by configuring SET SQL_MODE = ‘Oracle’. This enable MariaDB to understand majority of the Oracle PL/SQL syntax, Stored Procedures, Triggers, Functions and Oracle style packages.
According to the MariaDB post, with SQL_MODE = ORACLE, MariaDB is now able to parse, depending on the case, approximately 80 percent of the legacy Oracle PL/SQL without rewriting the code.
Using the core Oracle PL/SQL compatibility in MariaDB TX 3.0, the Development Bank of Singapore (DBS) has been able to migrate more than half of their business-critical applications in just 12 months from Oracle Database to MariaDB. In fact, vast parts of your Oracle PL/SQL code can be migrated seamlessly, including:
Our team recently completed a successful proof-of-concept (PoC) for a bank, to migrate Oracle RAC being used by their internet banking application, to MariaDB.
It was a great learning experience with a satisfying and successful outcome, wherein MariaDB was able to meet both functional as well as technical requirement of the bank. The migration from Oracle RAC to MariaDB will result in huge cost savings for the bank and will also pave the way to migrate other applications from Oracle to MariaDB.
Our learnings can be summarised as follows:
Crest Infosolutions is best described as a team of as youthful, ambitious, passionate and committed technology professionals