Change Data directory and index_path to specific directory path if cluster is built using rolling method

Total Time to perform Activity is:  2hr

The following are the high level Steps from DB side:

Step 1:

1. Disable Auto-Failover
2. Remove node which doesn’t contain Index .
3. Rebalance
4. Stop service
5. remove old data files
6. start service
7. Execute below command

/opt/couchbase/bin/couchbase-cli node-init -c localhost:8091 --node-init-data-path=/couchbase/data -u Administrator -p *******

curl -X POST -u Administrator:****** -d index_path=/couchbase/index http://localhost:8091/nodes/self/controller/settings

Step2

a. Create small Index on 10.17.101.225 if present

10. Add 10.17.101.27 back to cluster
11. Remove node 10.17.103.90
12. Swap Rebalance
13. Stop Service
14. remove old data files
15. start service
16. Execute below command

/opt/couchbase/bin/couchbase-cli node-init -c localhost:8091 --node-init-data-path=/couchbase/data -u Administrator -p *****

curl -X POST -u Administrator:***** -d index_path=/couchbase/index http://localhost:8091/nodes/self/controller/settings

Step 3:

1. Create Index

DROP INDEX <Bucketname>.findAll_operations_index_favorites_active USING GSI;

CREATE INDEX findAll_operations_index_watches_active ON <BucketName>(userId,brandId,_class,deleted,updatedTimestamp) WHERE ((_class = "XXXX") and (deleted = false)) USING GSI WITH {"nodes":["10.17.101.27:8091"]};

10. Add node 10.17.103.90 back to cluster
11. Remove node 10.17.101.225
12. Swap Rebalance
13. Stop Service
14. remove old data files
15. start service
16. Execute below command

/opt/couchbase/bin/couchbase-cli node-init -c localhost:8091 --node-init-data-path=/couchbase/data -u Administrator -p XXXXX

curl -X POST -u Administrator:XXXXXX -d index_path=/couchbase/index http://localhost:8091/nodes/self/controller/settings

10. Add 10.17.101.225 node back to cluster
11. Create Small Index

CREATE INDEX findAll_operations_index_favorites_active ON <BucketName>(userId,brandId,_class,deleted,updatedTimestamp) WHERE ((_class = "xxxxxx") and (deleted = false)) USING GSI WITH {"nodes":["10.17.101.225:8091"]};

DROP INDEX <BucketName>.findAll_operations_index_favorites_active_1 USING GSI;

Step 4:

Go to settings and

1. Enable Auto-Failover
2. Change the Auto compaction settings: 15%.