Database Clustering

Why Trust Techopedia

What Does Database Clustering Mean?

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

Advertisements

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.

Advertisements

Related Terms

Margaret Rouse
Editor

Margaret jest nagradzaną technical writerką, nauczycielką i wykładowczynią. Jest znana z tego, że potrafi w prostych słowach pzybliżyć złożone pojęcia techniczne słuchaczom ze świata biznesu. Od dwudziestu lat jej definicje pojęć z dziedziny IT są publikowane przez Que w encyklopedii terminów technologicznych, a także cytowane w artykułach ukazujących się w New York Times, w magazynie Time, USA Today, ZDNet, a także w magazynach PC i Discovery. Margaret dołączyła do zespołu Techopedii w roku 2011. Margaret lubi pomagać znaleźć wspólny język specjalistom ze świata biznesu i IT. W swojej pracy, jak sama mówi, buduje mosty między tymi dwiema domenami, w ten…