DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

ClearDB


ClearDB is a distributed, cloud-hosted, database-as-a-service version of MySQL. Its primary purpose is to eliminate the management cost of MySQL databases and provide automatic database replication and failover. By adding software stacks on top of MySQL and leveraging geo-separated data clusters, ClearDB is able to guarantee 100% uptime. ClearDB supports major commercial cloud which includes Amazon EC2 and Windows Azure and also support customized data centers or a hybrid of the two.[03][04]

Developer
Country of Origin
US
Start Year
2010 [08]
Acquired By
Project Type
Commercial
Written in
C++
Derived From
MySQL
Embeds / Uses
MySQL
Operating System
Hosted
License
Proprietary

Database Entry

ClearDB


ClearDB is a distributed, cloud-hosted, database-as-a-service version of MySQL. Its primary purpose is to eliminate the management cost of MySQL databases and provide automatic database replication and failover. By adding software stacks on top of MySQL and leveraging geo-separated data clusters, ClearDB is able to guarantee 100% uptime. ClearDB supports major commercial cloud which includes Amazon EC2 and Windows Azure and also support customized data centers or a hybrid of the two.[03][04]

Checkpoints[05]


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.

Compression[06][07]


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.

Data Model


Query Interface


SQL

Storage Architecture


System Architecture


Revision #6