sqlfire lightning talk

13
vFabric SQLFire Fast meets scalable in VMware's distributed SQL database.

Upload: carter-shanklin

Post on 26-Jan-2015

107 views

Category:

Technology


0 download

DESCRIPTION

SQLFire Lightning Talk, presented at the inaugural NewSQL meetup April 16, 2012.

TRANSCRIPT

Page 1: SQLFire lightning talk

vFabric SQLFire

Fast meets scalable in VMware's distributed SQL database.

Page 2: SQLFire lightning talk

SpeedIn-memory for maximum

speed and minimum latency.

SQLFire: Speed, Scale, SQL.Scale

Completely dynamic horizontal scalability.

SQLA real SQL interface.

Page 3: SQLFire lightning talk

SQLFire: Speed Through In-Memory Design

SQLFire Database

1Writes aresynchronously

persisted acrosstwo servers

2Later asynchronouslypersisted to disk

Page 4: SQLFire lightning talk

Dynamic Scalability

SQLFire Database

1Add new nodesany time load spikes.

3Remove nodeswhen load returns

to normal

2Data is automatically rebalanced to new nodes.

Page 5: SQLFire lightning talk

Speed: More Than 1 Million Queries Per Second

Page 6: SQLFire lightning talk

Speed: Fast For Updates Too

Page 7: SQLFire lightning talk

Built-In High Availability

SQLFire Database

1Data resides ona node that fails

2Access is automaticallyrerouted to a replica

node

Page 8: SQLFire lightning talk

• SQLFire syntax is based on the SQL-92 standard.• SQLFire extensions are to Data Definition

Language (DDL) only, e.g. CREATE TABLE.• DML 100% standards compatible.• JDBC and ADO.NET drivers.– Built-in, transparent high availability.

A Real SQL Interface

Page 9: SQLFire lightning talk

Same database in multiple datacenters or the cloud.Asynchronous, row-level replication.

Synchronize Data Globally

Page 10: SQLFire lightning talk

• SQLFire makes it easy to link to existing databases.• Read-through, write-through, caching and more.• Solve DB scalability challenges – with a SQL model.

Connect With Existing Data

Page 11: SQLFire lightning talk

• Banking Customer.• Seasonal workload, needed high performance

and high availability.• Traditional vendor required extremely expensive

and dedicated solution.• Chose SQLFire for a more cloud-friendly

approach.

Use Case: Don’t Pay For The Peak

Page 12: SQLFire lightning talk

• SQLFire’s in-memory design provides extreme write scalability.

• Combined with write-behind capabilities to batch inserts to a traditional database.

Use Case: SQLFire For Fast Data Ingest

Page 13: SQLFire lightning talk

• Available today!– Free for development up to 3 nodes.– http://vmware.com/go/sqlfire

• Follow us on Twitter:– @cshanklin, @vfabricsqlfire

Download SQLFire Today!

Scan To Learn More