MySQL Cluster 7.0.6

MySQL Cluster is primarily an in-memory database, but one that also provides optional disk-based data all available via a SQL interface or optionally via a high-performance native C++ or Java interface using the Carrier Grade Edition.

Major Features:

1. ACID Compliant, Transactional Database: MySQL Cluster provides full ACID (atomic, consistent, isolated, durable) transaction support.
   
2. In-Memory Index and Data: To ensure real-time performance, MySQL Cluster stores indexes in memory. Data can also be held and managed in memory when it needs to be accessed for the highest performance, lowest latency applications
3. Disk-Based Data: Data that must be highly available, but does not demand the real time performance characteristics of In-Memory data can be stored on disk. This enables MySQL Cluster to to be used for a broad set of applications, giving users the ability to create even larger database clusters and manage them effectively.
4. Distributed, Shared Nothing Architecture: The architecture of MySQL Cluster is designed to deliver 99.999% availability. This translates into less than 5 minutes downtime per year, including regularly scheduled maintenance operations. MySQL Cluster comprises multiple nodes which can be distributed across hosts to ensure continuous availability in the event of a data node, hardware or network failure. By storing and distributing data in a shared-nothing architecture, (i.e. without the use of a shared-disk) if a Data Node does fail, there will always at least one additional Data Node storing the same information. This allows for requests and transactions to continue to be satisfied without interruption, and data to remain consistent across nodes. 
5. Synchronous Data Replication: Since all data in the database is automatically replicated on multiple data nodes within the same node group, data is synchronously replicated during transactions, i.e. the effect of each transaction is propagated to all the appropriate data nodes during the transaction. When the transaction is ready to be committed, a request is sent to all data nodes involved in the transaction. When all nodes indicate that they are ready, the transaction is committed and the application is informed of the transaction's success. To ensure that the database is always consistent, if a data node fails during a transaction, it is aborted and the application is informed so that it can roll-back and restart the transaction.
6. Automatic Sub-Second Failover & Self-Healing:
   • As all data is already replicated across multiple cluster nodes using Synchronous Replication, and with instant detection of any failures, the fail-over time to another node is achieved in less than a second The shared-nothing architecture of MySQL Cluster ensures that there is no added complexity from shared storage and associated lock managers to slow down the failover process.
   • MySQL Cluster database nodes are able to automatically restart, recover, and dynamically reconfigure themselves in the event of a failure. The MySQL Cluster fail-over and self-healing features are completely transparent to all applications and clients.
7. Variable Sized Records: Variable-sized records are dealt with by MySQL Cluster in a highly efficient manner by ensuring that only the data that is actually resident within the row consumes memory. As a result, there is no wasted memory, more rows per gigabyte can be stored and larger datasets can be leveraged for in-memory data.
8. User-Defined Partitioning: MySQL Cluster offers automatic data partitioning as standard. To further boost linear scalability, MySQL Cluster also allows developers and DBAs to refine access through user-defined partitioning, thus allowing data to be efficiently accessed on a single node, without the need for inter-cluster communication to perform a transaction or a look-up.
9. On-Line Schema Updates and Systems Maintenance:
   • To support continuous operation, MySQL Cluster allows on-line updates to live database schema and upgrades to the underlying hardware & software infrastructure of the cluster.
   • MySQL Cluster supports online schema upgrades, such as adding and removing tables or indexes, as well as changing table schemas, (e.g. adding columns). In MySQL Cluster, adding and removing tables and indexes are performed as normal operations on the cluster, and do not require any rolling upgrade of the cluster.
   • Using a rolling upgrade, individual components are allowed to shutdown, assume the upgrade, and restart, while redundant (replica) parts continue processing client requests. Thereby database sessions can be maintained and upgrades do not cause downtime.
     
10. Scale Up and Scale Out on COTS Systems: 
    • MySQL Cluster runs on all leading commodity hardware and OS platforms, freeing users from proprietary platforms and vendor lock-in to enhance choice and reduce costs. Users can start on commodity Cluster hosts, adding nodes incrementally as their workload or database size grows, all the while keeping acquisition costs ultra-low.
      
    • Using MySQL Cluster's Multi-Threaded Data Nodes, users can scale on hosts equipped with more CPU sockets, cores or threads, delivering higher performance with less hardware resource. As a result, users can reduce hardware sprawl resulting in lower TCO through reduced systems administration, space and energy consumption of the cluster.
      
11. On-Line Back-Up: MySQL Cluster CGE allows a backup to be made on a running cluster. The backup is consistent cluster-wide snapshot of the database that can be archived and copied to a secure, remote location. Backups can later be applied, if necessary, to a database to restore the contents of the database.
12. SQL: MySQL Server nodes enable SQL access to the clustered Data Nodes. This provides developers a standard SQL interface to program against. MySQL Server in turn, handles sending requests to the Data Nodes, thus eliminating the need for cluster specific, low-level programming within the application.
13. NDB API (C / C++):
    • Applications that need the maximum real-time performance from the MySQL Cluster database should use the native NDB API directly. This C++ API is described in detail in the MySQL Cluster API Developer Guide
    • There are also Java and HTTP interfaces to the NDB API for applications to use, thereby providing ultimate developer independence and allowing easy integration of MySQL Cluster with a broad range of web and enterprise applications. 
      
14. On-Line Add Node: 
    • MySQL CGE has the ability to add nodes on-line to a running cluster. This is achieved by re-partitioning data as new node groups are added, ensuring the cluster maintains continuous operation and application connectivity.
    • Using On-Line Add Node, users can dynamically scale capacity and performance by adding more nodes to a live cluster, allowing mission critical applications to scale effortlessly with zero downtime.
15. Data Store for LDAP Directories: MySQL Cluster has been widely deployed for subscriber databases within Communications Service Provider networks. Extending this capability, MySQL Cluster CGE 7.0 and above can serve as the back-end data store for LDAP directory servers, allowing users to preserve and enhance their existing investments in LDAP technology. It allows operators to embark on initiatives that fully exploit user and network data that is currently distributed across legacy applications and networks.  
16. Geographic Replication: The ability to withstand site failures by replicating clusters across multiple remote locations is an important capability for many deployments. Geographic Replication is available as an option with MySQL Cluster Carrier Grade Edition, and ideally suited to those organizations with multiple data centers.  
17. Custom Feature Development: Commercial customers of MySQL Cluster CGE, can sponsor NRE (Non-Recurring Engineering) projects for implementation by MySQL Engineers and Professional Services. These involve the research, development, design, and testing of potential new database enhancements that presents the customer unique capabilities to solve specific business or technical challenges, or create new value-added solutions with MySQL Cluster.

Requirements:

• Memory: Minimum 1GB RAM
• HDD: 3GB
• Network: 1+ nodes (Gigabit Ethernet - TCP/IP)