Shared-Nothing Architecture

Shared-nothing architecture (SNA) is a pattern used in distributing computing in which a system is based on multiple self-sufficient nodes that have their own memory, HDD storage and independent input/output interfaces. Each node shares no resources with other nodes, and there is a synchronization mechanism that ensures that all information is available on at least two nodes.

Shared-nothing architecture is very popular in web applications, because it provides almost infinite horizontal scaling that can be made with very inexpensive hardware. It is widely used by Google, Microsoft and many other companies that need to collect and process massive sets of data.

One of the good examples of using the SNA architecture is a MySQL cluster. It features a Network DataBase (NDB) storage engine that automatically distributes MySQL data across multiple storage nodes and provides great performance in write-heavy applications. Learn more about MySQL clustering...

Shared-Nothing Architecture and Backups

It is very important to understand that although shared-nothing architecture provides very high availability of your applications, it can’t be a replacement for backups. Automated synchronization of storage nodes means that all errors are automatically synchronized too: for instance, if you accidentally drop a database table, it will be deleted from all databases.

Our software, Handy Backup, has a number of powerful plug-ins designed for backup and recovery of databases of different types. We welcome you to try it – it takes less than 2 minutes to setup and create your first backup!




Learn more:

  • Database Dump
    "Database dump is a text file containing a set of SQL statements that need to be run on an SQL server to create a database with the entire internal structure…"
  • MySQL Slave Server
    "MySQL Slave Server is a server in MySQL replication configuration that continuously tracks all modifications of the Master Server′s database and replicates…"
  • Database Storage Engine
    "Database storage engine is a mechanism employed by database management software that defines how it stores and handles data. Different DBMS have different…"


Backup Terms Glossary

Who uses Handy Backup?