Wednesday, September 27, 2017

Transitioning From Equivalent Indexes to Index Replicas

DZone Database Zone
Transitioning From Equivalent Indexes to Index Replicas
Transitioning 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 three equivalent indexes spread across three nodes; and with Couchbase 5.0 Beta available, you want to migrate these equivalent indexes to index replicas.

//old 4.x equivalent indexes create index eq_index1 on bucket(field1); create index eq_index2 on bucket(field1); create index eq_index3 on bucket(field1);

Note: If you want to use the same nodes to create the replicas, do make sure that they have the required memory and compute resources for the both the index replicas and equivalent indexes to coexist.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...