From:       To:      

Oracle vs MySQL

[Oracle to MySQL]  [MySQL to Oracle]

Database specialists who intend to migrate databases from Oracle to MySQL or backward should consider all benefits and disadvantages of each DBMS before they start. This article gives an integral picture of cons and pros for Oracle and MySQL.

Installation

Oracle comes with much more complex system requirements and the installation process than MySQL. The DBMS uses special tool named Oracle Universal Installer (OUI) to handle the following installation tasks:

When it is required OUI may start the Oracle Database Configuration Assistant (DBCA) to install default database that contains example schemas. DBCA can also help to create and configure a customized database.

MySQL comes as a set of binary distribution files that includes the standard installation GUI wizard for Windows and compressed .tar.gz files for other platforms.

Security

Oracle database is supplied with great security features, the system provides multi-layered security including such advanced options as controls to prevent unauthorized data disclosure, detect and report on database activities and evaluate risks.

MySQL provides security system based on Access Control Lists (ACLs) for all queries and other operations that a user may attempt to perform on databases. MySQL also supports SSL-encrypted connections between servers and clients.

Backup

Oracle offers dedicated complex backup tool called Recovery Manager (RMAN). RMAN supports sophisticated backup policies and selective restores. There are two options of backup:

MySQL offers two backup utilities: mysqldump for logical backup (SQL statements level) and Percona XtraBackup for binary backup (physical files).

Oracle advantages:

Replication

Oracle offers built-in Data Guard tool for logical and physical replication. When any update (insert/update/delete) is made to a table of primary database, the changes are written into archive log and then replicated to one or more replicas. Replica databases are in recovery phase continuously, verifying and applying changes to keep synchronization with the primary database.

MySQL replication is easy to set up but ongoing maintenance like software upgrades, schema changes, failover and recovery have often been a challenge. It does not require a third party solutions, both master-slave and multimaster replication can be done out of the box.

Oracle disadvantages:

MySQL advantages:

MySQL disadvantages:

If database migration is confirmed after all considerations, it is reasonable to look for dedicated software products for automating the migration process. Intelligent Converters offer two products to convert Oracle to MySQL and MySQL to Oracle handling all database objects except stored procedures and triggers.