Tag: Index

Divide and Conquer: Couchbase GSI Index partitioning.

In Couchbase, data is always partitioned using the consistent hash value of the document key into vbukets which are stored on the data nodes.  Couchbase Global Secondary Index (GSI) abstracts the indexing operations and runs as a distinct service within...

/ April 11, 2018

Understanding Index Grouping And Aggregation in Couchbase N1QL Query

Couchbase N1QL is a modern query processing engine designed to provide SQL for JSON on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL supports enhanced SQL...

/ April 3, 2018

Index Partitioning in Couchbase Server 5.5

Index partitioning is a new feature available in Couchbase Server 5.5. Check out the Couchbase Server 5.5 Developer Build announcement and download the release for free right now. In this post, I’m going to cover: Why you might want to use index...

New Features in Index Service in Couchbase Server 5.5

In the last major release, Couchbase Server 5.0, we introduced Plasma – New Storage Engine and also the support for Index Replicas in the Index Service. We have continued to build on these new features in our upcoming release. The themes...

Indexing Best Practices

Prelude: Asynchronous Indexing: Global Secondary Indexes in Couchbase can be created, updated and deleted without impacting the reads and writes on the JSON documents in Data nodes. This means that index inserts/updates/deletes happen asynchronously and index workloads are isolated from...

SQL for JSON Query

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, brings a plethora of new features and enhancements. We discussed one such enhancement, namely the new replication protocol between in an earlier blog post on Replication 2.0. In this blog post, we will introduce you...

Create the Right Index, Get the Right Performance.

Introduction There are three things important in database systems: performance, performance, performance.  For NoSQL database systems, there are three important things: performance at scale, performance at scale, performance at scale. Understanding the index options, creating the right index, with the...

/ November 12, 2017

Optimizing Database Pagination using Couchbase N1QL.

Background: How does Google do it? When you google something or anything, it gives you back top relevant results, tells you an approximate number of documents for your topic — all under a second.   Here are some high-level pointers: https://www.google.com/search/howsearchworks/algorithms/...

/ November 2, 2017

Blazing Fast Index Performance with Plasma

In the earlier post, we got an opportunity to introduce Plasma as the new performant storage engine that powers Global Secondary Indexes in Couchbase 5.0(beta out!). We saw some of the features of Plasma and how it is designed with...

How to transition from Equivalent Indexes to Index Replicas?

In the previous post, we saw the benefits of using index replicas over equivalent indexes.  Let’s say you are on Couchbase Server 4.x and have the following 3 equivalent indexes spread across 3 nodes; and with Couchbase 5.0 Beta available,...