Comparison between Oracle and MySQL [content from the network]

Comparison of supported features:

Https://www.quora.com/Whats-the-difference-between-Oracle-and-MySQL

Comparison of Oracle and MySQL in terms of security, data type, storage type.

Https://docs.oracle.com/cd/E25259_01/doc.31/e18461/oracle_mysql_compared.htm

Ali go to Oracle, using the MySQL event:

https://www.zhihu.com/question/29088685

RAC is an Oracle database high availability solution. High availability consists of two parts: the first is to ensure that the data is not lost under this solution, which is fundamental and must be ensured, and secondly, to ensure that the Oracle database remains in a normal state of operation and avoids the loss of downtime to the customer.

Oracle RAC supports the oracle9i, 10g, and 11G,12C editions, supports a database application system of 7 effective, builds a high availability database system on low-cost servers, and deploys applications without the need to modify code.

In Oracle RAC Environments, Oracle integration provides clustering software and storage management software that lowers application costs for users. When the scale of application needs to be expanded, the user can expand the system as needed to ensure the performance of the system.

(1) Multi-node load balancing;

(2) Provide high availability: fault-tolerant and seamless switching, minimizing the impact of hardware and software errors;

(3) Improve transaction response time by parallel execution technology----usually used in data analysis system;

(4) Increase the number of transactions per second and the number of connections by scale-out----usually for online transaction systems;

(5) Save hardware cost, can use many inexpensive PC server instead of expensive small machine or mainframe, and save the corresponding maintenance cost;

(6) Scalability is good, you can easily add delete nodes, expand Hardware resources.

Comparison between Oracle and MySQL [content from the network]