MySQL NDB Cluster: NoSQL
MySQL Cluster enables users to blend the best of both relational and NoSQL technologies into solutions that reduce cost, risk and complexity including:
- Concurrent NoSQL and SQL access to the database;
- Simple multi-master replication with automated failover and recovery within and across data centers;
- Auto-sharding and scale-out across commodity hardware;
- Online scaling and schema changes;
- ACID compliance, Foreign Key constraints (enforced on all APIs) and support for complex queries;
- In-memory computing for real-time performance.
MySQL Cluster presents multiple interfaces to the database, enabling maximum developer agility, while also providing the option to bypass the SQL layer entirely for native, blazing fast access to your tables. Each of the SQL and NoSQL APIs can be used simultaneously, across the same data set
SQL & NoSQL APIs to MySQL Cluster
The MySQL Server provides an industry standard SQL interface to the cluster enabling complex, relational queries to be run, and providing connectivity to all of the standard MySQL connectors including:
- Common web development languages and frameworks, i.e. PHP, Perl, Python, Django, Ruby, Ruby on Rails, etc;
- JDBC (for additional connectivity into ORMs including EclipseLink, Hibernate, etc)
- .NET, ODBC, etc
MySQL Cluster also offers the choice of NoSQL APIs:
- JavaScript Connector for node.js, with a native asynchronous JavaScript interface directly to MySQL Cluster, bypassing the SQL layer
- Scalable, persistent, HA NoSQL Memcache storage using MySQL Cluster
- MySQL Cluster Connect for Java (ClusterJ & Cluster JPA) for connectivity to enterprise applications
- C++ NDB API for real-time web and telecom services (presence, location based, etc.)
- Apache mod_ndb for native HTTP/REST access