sql vs nosql: the nosql way
TRANSCRIPT
SQL vs NoSQLTHE NOSQL WAY
NoSQL MongoDBISN’T JUST
{“id” : …, “…” : …}
FILLING A NICHE
WHY SO MANY?
SIMPLE DATA STORAGE
CACHE SYSTEM CONFIGURATION
MEMCACHEDREDIS
ZOOKEEPERETCD
Etcd demo
DOCUMENT STORAGE
MONGO COUCHDYNAMO
GRAPH DATA
SOCIAL GRAPHS
ROUTE DATA
NEO4J
RELATIONAL LIKE
BIG TABLE CLONES COLUMN FAMILY
CASSANDRA
Cassandra demo
TIME SERIES DATA
TIME SERIES DATABASES
SPARSE COLUMN STORES
INFLUX CASSANDRA
InfluxDB demo
THE NO IN NoSQL STANDS FOR NOT ONLY
WHEN SHOULD I USE NOSQL?
FREQUENTLY CHANGING
MODEL
LARGE SCALE
SPECIAL USE CASE
WHAT DO I MEAN BY SCALE?
SCALE UP SCALE OUT
JUST ENOUGH DISTRIBUTED
SYSTEMS THEORY
CAP THEORYCONSISTENCY
AVAILABILITYPARTITION TOLERANCE
* NOT REALLY ANYMORE
PICK TWO*
CA’S NOT POSSIBLE
BASIC AVAILABILITY, SOFT STATE, EVENTUAL CONSISTENCY
VS
ATOMIC CONSISTENT, ISOLATED, DURABLE
ACID IS POSSIBLE IN NOSQL
I’VE PICKED MY DATABASE, NOW WHAT?
SHIP IT BUT…
KNOW THE RISKSDISTRIBUTED SYSTEMS AREN’T EASY
CLOUD MAKES IT HARDER STILL
JEPSENHTTP://APHYR.COM/TAGS/JEPSEN
IN CONCLUSIONENSURE YOUR USE CASE IS RIGHT
KNOW THE RISKS
PREPARE FOR FAILURE