Get the App
SLTechnology News&Howtos  ›  Database  › 

What are the differences between oracle rac and distributed database

Shulou Source: shulou.com Published: 2022-05-31 20:03:58 09月13日 Update

This article mainly introduces the differences between oracle rac and distributed database, the article is very detailed, has a certain reference value, interested friends must read it!

1. Distributed databases are multiple databases, while rac is just a library with multiple instances.

There is no coordination problem in 2.rac transactions, while distributed databases need transaction coordination because they are multiple libraries.

3. Distributed database data is scattered in each node, but the devices are generally cheap devices, often node failures, but transparent to users; .RAC is an ORACLE cluster, data is shared storage, there is only one copy, and each node does not store data. Nodes can go down, but data will not be lost.

4. Distributed database supports more nodes, and the number of nodes increases linearly, while the number of nodes supported by rac is small, and the performance of nodes does not increase linearly.

The biggest problem with 5.Oracle is the architecture of shared everything, which leads to the limited processing power and scalability of IO, while the distributed database is shared nothing architecture.

These are all the contents of the article "what's the difference between oracle rac and distributed databases". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Tags: Data database distributed node multiple transaction content limited architecture article linear capability device problem storage support maximum value interest just Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Huawei MySQL macOS MariaDB