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!
Recommended Solution
$249 per license
Handy Backup Small Business
The Small Business edition of our utility allows backing up and restoring MS SQL, MySQL, Oracle, and other databases. Try small business backup software for 30 days for free!
Learn more:
- 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…" - MySQL Clustering
"MySQL clustering is a technology that allows distributing the MySQL database across multiple independent nodes, to eliminate every possibility of failure.…" - MySQL Master Server
"MySQL Slave Server is a server configured for MySQL replication. It constantly monitors and replicates all changes made to the database on the Master Server.…"