Mysql和Oracle的区别


写在前面

一、Mysql / Oracle

1.1、Mysql

MySQL database server is reliable, fast and very easy to use.

1.2、Oracle

Oracle Database allows you to quickly and safely store and retrieve data. Here are the integration benefits of the Oracle Database:

  • Oracle Database is cross-platform. It can run on various hardware across operating systems including Windows Server, Unix, and various distributions of GNU/Linux.
  • Oracle Database has its networking stack that allows application from a different platform to communicate with the Oracle Database smoothly. For example, applications running on Windows can connect to the Oracle Database running on Unix.
  • ACID-compliant – Oracle is ACID-compliant Database that helps maintain data integrity and reliability.
  • Commitment to open technologies – Oracle is one of the first Database that supported GNU/Linux in the late 1990s before GNU/Linux become a commerce product. It has been supporting this open platform since then.
    Oracle Database has several structural features that make it popular:

Logical data structure – Oracle uses the logical data structure to store data so that you can interact with the database without knowing where the data is stored physically.

  • Partitioning – is a high-performance feature that allows you to divide a large table into different pieces and store each piece across storage devices.
  • Memory caching – the memory caching architecture allows you to scale up a very large database that still can perform at a high speed.
  • Data Dictionary is a set of internal tables and views that support administer Oracle Database more effectively.
  • Backup and recovery – ensure the integrity of the data in case of system failure. Oracle includes a powerful tool called Recovery Manager (RMAN) – allows DBA to perform cold, hot, and incremental database backups and point-in-time recoveries.
  • Clustering – Oracle Real Application Clusters (RAC) – Oracle enables high availability that enables the system is up and running without interruption of services in case one or more server in a cluster fails.

Mysql 可能更方便使用，Oracle更利于数据库、表的管理，优化监控等