Database Clustering

Last Updated: May 13, 2020

Definition - What does Database Clustering mean?

Database clustering refers to the ability of several servers or instances to connect to a single database.

An instance is the collection of memory and processes that interacts with a database, which is the set of physical files that actually store data.

Techopedia explains Database Clustering

Database clustering offers two major advantages, especially in high-volume database environments:

Fault Tolerance

Because there is more than one server or instance for users to connect to, clustering offers an alternative, in the event of individual server failure.

Load Balancing

The clustering feature is usually set up to allow users to be automatically allocated to the server with the least load.

Database clustering takes different forms, depending on how the data is stored and allocated resources.

Shared-Nothing Architecture

In this database clustering mode, each node/server is fully independent, so there is no single point of contention. An example of this would be when a company has multiple data centers for a single website.

With many servers across the globe, no single server is a “master.” Shared-nothing is also known as “database sharding.”

Shared-Disk Architecture

All data is stored centrally and then accessed via instances stored on different servers or nodes.

The distinction between the two types has become blurred recently with the introduction of grid computing or distributed caching. In this setup, data is still centrally managed but controlled by a powerful “virtual server” that is comprised of many servers that work together as one.

Share this: