Hosted Systems

MySQL Relational

History[06][07]

ClearDB was founded by Cashton Coleman in 2010 as a pioneer of MySQL DBaaS aimed to eliminate the pain of managing MySQL clusters and free developers from supporting database issues. According to RDX, ClearDB was the world's largest MySQL DBaaS provider. In 2019, ClearDb was acquired by RDX.

Checkpoints[08][09]

Same as MySQL

It uses both Fuzzy and Sharp checkpoint. It takes a sharp checkpoint when the database is performing shut down and uses fuzzy checkpoint during normal database operations. When taking a sharp checkpoint, the database flushes all dirty pages of committed transactions to disk and update the MasterRecord to be the lastest committed LSN. Checkpoint behaves the same way as MySQL and is not modified by ClearDB

Compression[10][11][12]

Same as MySQL

InnoDB supports multiple compression algorithms which include Zlib and LZ4. When writing a page to disk, data were first compressed and then written to disk. Then empty blocks will be released by hole punching mechanism, where the system reclaims unnecessary blocks at the end of the page. ClearDB's doesn't change compression from MySQL.

Concurrency Control[13][14]

Same as MySQL

ClearDB doesn't change concurrency control from MySQL. MySQL uses a combination of Multiversion Concurrency Control (MVCC) and row-level locking to achieve better concurrency. Old versions of rows are stored in a rollback segment which could later be used to rollback changes. Rollback segments are partitioned into the insert and update undo logs for different types of rollbacks.

Data Model[15]

Same as MySQL

ClearDB's underlying MySql database uses a relational data model that is not modified by ClearDB.

Foreign Keys[16]

Same as MySQL

The build-in MySQL natively supports foreign key constraints.

Indexes[17]

Same as MySQL

MySQL support multiple types of indexes. Most MySQL tables stored on disks use B-trees. Spatial data uses R-tree for indexes. MySQL also uses hash indexes for memory tables. ClearDB doesn't modify the behavior of indexes from MySQL.

Isolation Levels

Same as MySQL

Joins[18][19][20]

Same as MySQL

ClearDB's change from MySQL doesn't involve Join. MySQL employs both nested loop join as well as hash join algorithms. Nested loop joins are used by default and hash join was used when the join has an equi-join condition and no indexes were used. Block nested loop, as well as Batched Key Access Joins, are used to improve join performance.

Logging[04][21]

To ensure data durability, ClearDB leverages durable storage as well as MySQL transaction log.

Query Compilation

Same as MySQL

Query Execution[22]

Same as MySQL

MySQL follows an iterative processing mode and subqueries are optimized with materialization by storing subquery result in a temporary table. Query execution is not affected by ClearDB's change.

Query Interface[23]

Same as MySQL

ClearDB doesn't change the query interface of the underlying MySQL. MySQL natively supports SQL and stored procedures for query executions.

Storage Architecture[24][04]

Same as MySQL

On a higher level, ClearDB uses cloud-based durable storage. On a lower level, ClearDB MySQL uses InnoDB as the default storage engine and supports multiple other storage engines: MyISAM, Memory (Heap Engine), Merge, Archive, Federated, and NDB.

Storage Model[25][26]

Same as MySQL

InnoDB uses a row storage structure that supports 4 row formats: Redundant, Compact, Dynamic, Compressed. It is not affected by the change from MySQL to ClearDB.

Storage Organization

Same as MySQL

Stored Procedures

Same as MySQL

System Architecture[27][28][29]

ClearDB is a cloud-based database-as-a-service version of MySQL. It wraps multiple software stacks around MySQL 5.5 and runs multiple geo-separated database clusters to reduce the chance of total database failures. It uses shared-nothing architecture, master-master replication, and proprietary routing technology to achieve automatically handle failed nodes. Database replications are done in an asynchronous manner and are realtime. In the event of failure, the SQL routing algorithm will automatically redirect the query to the secondary master and bring the master back when the node recovers.

ClearDB performs daily backup where the backups are compressed and encrypted and will be replicated to master nodes.

ClearDB leveraged a secure configuration from MySQL, and SSL was used for network security .

Views

Same as MySQL