Clustrix Parallelized Clustered Database

1
Clustrix Parallelized Clustered Database
Presented by Ashutosh Dhiman and David
Gloe
Source Mellor, Chris. Size doesn't matter to
database thrusting Clustrix. The Register.
November 18, 2011. http//www.theregister.co.uk/20
11/11/18/clustrix/
2
Outline

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

3
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

4
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

5
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

6
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

7
Architecture Overview
8
Data Layout
9
Select
10
Insert
11
Relationship to class

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

12
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

13
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/