NDB Cluster

NDB Cluster

Ndb Cluster is the distributed database system underlying MySQL Cluster. It can be used independently of a MySQL Server.

From the MySQL Server perspective the Ndb Cluster is a Storage engine for storing tables of rows. From the Ndb Cluster perspective, a MySQL Server instance is an 'API process' connected to the Cluster. Ndb Cluster can concurrently support access from other types of API processes. All API processes can operate on the same tables and data stored in the Ndb Cluster.

Contents

Standalone Ndb Cluster

Ndb Cluster has the following capabilities independent of any attached MySQL Server :

  • Persistent, distributed storage of tables with unique or ordered indexes
    • Redo logging, checkpointing, system recovery
  • Primary key, unique key, table scan and ordered index scan
    • Parallel scan execution with 'pushed-down' filters
  • Row locks, transactional updates
  • Synchronous data replication within the cluster, automatic failover + recovery
    • Automatic connection failover for 'API' processes
  • Standard SQL datatypes including Blobs etc.
  • Storage of data on disk
  • Asynchronous data change triggers mechanism
  • DDL operations (although independent DDL will not currently be recognised by any attached MySQL servers)
  • Online index add, online table alter
  • Online add node, table reorganisation
  • Online backup
  • Online upgrade

MySQL Cluster (Ndb Cluster + MySQL Server(s))

MySQL Cluster currently uses the MySQL Server to provide the following capabilities on top of Ndb Cluster:

  • SQL parsing / optimising / execution capability
    • Connectors to applications via JDBC, ODBC ...
  • Cross-table join mechanism
  • User authentication and authorisation
  • Asynchronous data replication to other systems

Usage

Ndb Cluster is often configured as a MySQL Cluster (An Ndb Cluster with attached MySQL Server processes) with one or more non-MySQL Server API processes attached.

All API processes including the MySQL Server use the NDBAPI[1] C++ client library to connect to the Ndb Cluster and perform operations.

It is currently recommended that at least one MySQL Server is connected to an Ndb Cluster to perform DDL operations.

References

  1. ^ [1] The MySQL Cluster API Developer Guide

Wikimedia Foundation. 2010.

Игры ⚽ Нужна курсовая?

Look at other dictionaries:

  • NDB — may refer to: Nachrichtendienst des Bundes, Switzerland s federal intelligence service National Development Bank NDB Clan, Group of Forest Walk individuals On Xbox360 and Starcraft Gaming Ndb Cluster, a database storage engine Nerima Daikon… …   Wikipedia

  • NDB — Cette page d’homonymie répertorie les différents sujets et articles partageant un même nom. NDB peut se référer à : Une balise non directionnelle Network Database, le moteur de base de données de MySQL Cluster Le dictionnaire de… …   Wikipédia en Français

  • MySQL Cluster — MySQL clúster es una tecnología que permite el clustering de bases de datos en memoria en un ambiente de no compartición. La arquitectura de no compartición permite que el sistema gestor de base de datos (SGBD) funcione utilizando hardware no muy …   Wikipedia Español

  • MySQL Cluster — ist eine Speicher Engine des freien Datenbanksystems MySQL in der aktuell verfügbaren Version 7.1. Sie ermöglicht die Installation der Datenbank auf einem Computercluster, das in einer Shared Nothing Architecture aufgebaut ist. Das bedeutet, dass …   Deutsch Wikipedia

  • MySQL Cluster — Structure d une grappe de serveurs MySQL. MySQL Cluster est la base de données distribuée de MySQL. Elle permet de répartir des données sur plusieurs serveurs sans avoir de point individuel de défaillance. Contrairement aux moteurs MyISAM et… …   Wikipédia en Français

  • MySQL Cluster — is a technology which provides shared nothing clustering capabilities for the MySQL database management system. It was first included in the production release of MySQL 4.1 in November 2004. It is designed to provide high availability and high… …   Wikipedia

  • MYSQL — Entwickler: Sun Microsystems (bis Februar 2008: MySQL AB) Aktuelle Version: 5.1.34 (Community Server) (7. April 200 …   Deutsch Wikipedia

  • MySql — Entwickler: Sun Microsystems (bis Februar 2008: MySQL AB) Aktuelle Version: 5.1.34 (Community Server) (7. April 200 …   Deutsch Wikipedia

  • Mysql — Entwickler: Sun Microsystems (bis Februar 2008: MySQL AB) Aktuelle Version: 5.1.34 (Community Server) (7. April 200 …   Deutsch Wikipedia

  • MySQL — Entwickler Oracle Corporation (bis Februar 2008: MySQL AB, bis Januar 2010: Sun Microsystems) Aktuelle Version …   Deutsch Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”