Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Cassandra 3.x High Availability

You're reading from   Cassandra 3.x High Availability Achieve scalability and high availability without compromising on performance

Arrow left icon
Product type Paperback
Published in Aug 2016
Publisher
ISBN-13 9781786462107
Length 196 pages
Edition 2nd Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Robbie Strickland Robbie Strickland
Author Profile Icon Robbie Strickland
Robbie Strickland
Arrow right icon
View More author details
Toc

Table of Contents (10) Chapters Close

Preface 1. Cassandras Approach to High Availability FREE CHAPTER 2. Data Distribution 3. Replication 4. Data Centers 5. Scaling Out 6. High Availability Features in the Native Java Client 7. Modeling for Availability 8. Anti-Patterns 9. Failing Gracefully

Multi-key queries


You will recall from the last chapter that Cassandra is most efficient when querying a range of columns on disk. All our examples assumed a replication factor of 3 with QUORUM reads and writes. We will follow the same conventions with the examples in this chapter.

With this in mind, let's make use of the authors schema we introduced in the last chapter:

CREATE TABLE authors ( 
   name text, 
   year int, 
   title text, 
   publisher text, 
   isbn text, 
   PRIMARY KEY (name, year, title) 
); 

Using this schema, let's say we want to retrieve a number of books from a list of known authors. Obviously, we could write a separate query for each author, but Cassandra also provides a familiar SQL-style syntax for specifying multiple partition keys using the IN clause:

SELECT * FROM authors 
WHERE name IN ( 
    'Tom Clancy', 
    'Malcolm Gladwell', 
    'Dean Koontz' 
); 

The question is: how will Cassandra fulfill this request? As we have discussed numerous times throughout this...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at AU $24.99/month. Cancel anytime