So you want to develop an application using the ClustrixDB. The main thing you need to know about ClustrixDB is that it speaks MySQL SQL, but was built from the ground up to be a distributed shared-nothing database. Even though there is no MySQL code used in ClustrixDB, ClustrixDB looks like a MySQL database "on the wire." Any application that uses a MySQL client or JDBC/ODBC drivers, like Ruby on Rails or Hibernate, can connect to ClustrixDB without issue and use standard MySQL constructs to interact. In other words, MySQL processes connecting to ClustrixDB see a MySQL instance, with SQL syntax.
ClustrixDB was built from the ground up to be MySQL compatible with a distributed architecture to provide scale.
ClustrixDB aims to provide support for most standard MySQL functionality. While we do not attempt to synchronize our feature development with MySQL releases, we strive to provide the features and functions required by our customers and critical to running successful production deployments. We monitor both our customers' requirements and new MySQL functionality to determine our feature roadmap and use recent shipping releases of MySQL as part of an automated QA process for compatibility.
ClustrixDB provides a host of tools that can be used to help you evaluate compatibility, including: a list of unsupported features and feature differences in our and a Developer version of ClustrixDB, now available on AWS.
About ClustrixDB Internals:
ClustrixDB is a clustered, distributed database built from the ground up for scale, concurrency, and performance as well as ease of use. While ClustrixDB seeks to be MySQL compatible, contains no actual MySQL source code.
Here is more on ClustrixDB internals:
- Written primarily in C
- Distributed, shared-nothing architecture with:
- Implements a transactional storage engine that most closely matches the specifications for InnoDB, including providing support for referential integrity and foreign key constraints
- Automatically retains multiple copies of all data to provide redundancy and fault tolerance
ClustrixDB most closely emulates the interface of the InnoDB storage engine. All tables in ClustrixDB are fully transactional and ACID-compliant and use the MVCC model for concurrency control. If an Engine Type is specified, ClustrixDB will accept the syntax but ignore and do nothing.
- ClustrixDB supports most standard data types, signed and unsigned integers, BLOB, BINARY, CHAR, DATE, DATETIME, DOUBLE, ENUM, FLOAT, TEXT, TIMESTAMP, VARCHAR, VARBINARY, YEAR