Working with Couchbase

1. Get the Couchbase RPM for version 6 and install it:

wget https://packages.couchbase.com/releases/6.0.0/couchbase-server-community-6.0.0-centos7.x86_64.rpm 

sudo yum install -y couchbase-server-community-6.0.0-centos7.x86_64.rpm 

2. Set the file limits in the limits.conf file:

sudo vim /etc/security/limits.conf

Add these lines:

* soft nofile 75000
* hard nofile 75000

3. Start the Couchbase server:

sudo /opt/couchbase/bin/couchbase-server \-- -noinput -detached 

1. From the GUI, simply add bucket.

2. From the CLI

couchbase-cli bucket-create -c 127.0.0.1:8091 --username Administrator --password Omgpassword! --bucket testdata --bucket-type couchbase --bucket-ramsize 128

3. Connect to couchbase using cbq

   cbq -e http://127.0.0.1:8091 -u=Administrator

4. Locate the data in the ~/data folder. There is a formatted version and there is an unformatted version. Either way, create a query from this data and run it against the bucket.

INSERT INTO `testdata` (KEY,VALUE) VALUES
("Employee_Duck",
{"name":"Donald Duck",
"status":"active",
"phone":{"primary":"5551212","secondary":"8329050"}}),
("Employee_James",
{"name":"Jimmy James",
"status":"active",
"phone":{"primary":"8001234","secondary":"none"}}),
("Employee_Solo",
{"name":"Han Solo",
"status":"retired",
"phone":{"primary":"none","secondary":"none"}}),
("Employee_Bacca",
{"name":"Chew Bacca",
"status":"retired",
"phone":{"primary":"6123478","secondary":"6461234"}});

1. In the GUI, the bucket will show the documents that were created, however, to make the bucket searchable, you will need to create an index:

CREATE PRIMARY INDEX `td_idx` ON `testdata`;

Then confirm that the data can be queried:

Select * from `testdata`;