Clustrix Parallelized Clustered Database Source:

Mellor, Chris. “Size doesn't matter to database thrusting Clustrix.

” The Register. November 18, 2011. http://www.theregister.co.uk/2011/11/18/clustrix / Presented by Ashutosh Dhiman and David Gloe

           Clustrix-The company Clustrix-The product Clustrix-Technical background The overview Architecture Overview Data Layout Select Insert Relationship to class Conclusions References

Outline

Clustrix-The company

 Co-founded by founder of Isilon Paul Mikesell  Isilon uses clustered nodes for unstructured data  Product to be launched next year  New CEO Robin Purohit  Previously of HP, Mercury, and Veritas

Clustrix-The product

 Parallelized Clustered Database (CDS)  Designed for Online Transaction Processing (OLTP)  Much cheaper than comparable Oracle product  Fifteen customers are evaluating the technology with no data loss  Including PhotoBox, AOL, TheLadders, EMBL-EBI, and iOffer

Clustrix-Technical background

 Hardware   Multiple server nodes clustered with Infiniband Intel SSDs for increased throughput  Software    Local queries only access one server node Wider queries access a subset of nodes Queries running on separate nodes run in parallel

The Overview

• • • • • • • MySQL Drop-In Replacement No Sharding High Performance SQL at Scale Automatic Fault Tolerance Incremental Scalability Online Schema Changes Delivered as an Appliance

Architecture Overview

Data Layout

Select

Insert

Relationship to class

 Physical Database Design   Uses SSDs for faster access times Separates data onto multiple drives for parallel queries

Conclusion

 Localizes data to individual nodes  Software minimizes required node communication  Currently being evaluated with promising initial results  Look for Clustrix to provide a scalable OLTP system next year

References

http://www.theregister.co.uk/2011/11/18/clustrix/ http://www.clustrix.com/uploads/documents/Clustri x_A_New_Approach.pdf

http://www.clustrix.com/