4.1 Couchbase Configuration
- Jenni Wallin
- Kevin Wu
- Former user (Deleted)
After Couchbase has been installed, you can create Couchbase profiles in to automatically generate buckets in the Couchbase cluster. In the Couchbase Web Console, you can also add more nodes to your cluster if you need to extend the database.
Note!
Created or updated Couchbase profiles that are used for PCC do not become effective until you restart the EC/ECSAs.
Couchbase Profiles
A Couchbase profile is used to read and write bucket data in a Couchbase database. This profile can be accessed by workflows using Aggregation, Distributed Storage or PCC.
As a client to Couchbase, the profile operates in synchronous mode. When sending a request to Couchbase, the profile expects a server response, indicating success or failure, before proceeding to send the next one in queue.
To create a new , click on the button in the upper left part of the Desktop window, and then select from the menu.
To open an existing , double-click on the configuration in the Configuration Navigator , or right-click on the configuration, and then select Open Configuration(s)....
In a Couchbase profile, there are three tabs; Connectivity , Management and Advanced.
The Connectivity tab is displayed by default. Couchbase profile - Connectivity tab for Couchbase Releases 5.x - 7.x, and 4.x Note! Note! From Couchbase version 5.0, buckets no longer use bucket-level passwords and you must access the bucket using a user and password that you must create in the Couchbase Web Console if it does not already exist. The following settings are available in the Connectivity tab: Choose between Couchbase release 5.x - 7.x and 4.x. The Bucket Configuration settings are different depending on if you select Couchbase Release 5.x - 7.x or 4.x. Note! If you have upgraded to a Couchbase Release 5.x - 7.x, it is recommended that you select the Couchbase Release 5.x - 7.x version of the Couchbase profile. However, if you have upgraded to a Couchbase Release 5.x - 7.x, but you choose to use the Couchbase Release 4.x version of the Couchbase profile, the user must have the same name as the bucket that you want to use in Bucket Name Enter the bucket that you want to access in Couchbase in this field. User Password If you have selected Couchbase Release 4.x, you can enter an optional password for the bucket in this field. If you have selected Couchbase Release 5.x - 7.x, enter the password for the user who has access to the bucket. Note! If you are using Couchbase Server 5.x - 7.x the password is mandatory. For further information, see https://developer.couchbase.com/documentation/server/current/security/security-authorization.html. Operation Timeout (ms) Enter the number of milliseconds after which you want Couchbase "CRUD" operations, that is, create, read, update, and delete, to timeout. Setting a lower value than the default 1000 ms may have a positive impact on throughput performance. However, if the value is set too low, indicated by a large number of operation timeout errors in the EC/ECSA logs, a lower throughput can be expected. As mentioned, this value is used for timing out CRUD operations in Couchbase. This means that the system sends a request to Couchbase and if an answer is not returned in time, the operation fails, and the system is no longer waiting for an answer. Retry Interval Time (ms) Enter the time interval, in milliseconds, that you want to wait before trying to read the cluster configuration again after a failed attempt. In other words, in case a request sent to Couchbase returns an unsuccessful answer, the number specified here is the time that the system waits before retrying the same request. Max Number Of Retries Enter the maximum number of retries. This is the number of retries done before treating the Couchbase operation as failed Cluster Nodes In this section, add the IP addresses/hostnames of at least one of the nodes in the cluster. This address information is used by the Couchbase profile to connect to the cluster at workflow start and to retrieve the IP addresses of the other nodes in the cluster. If the first node in the list cannot be accessed, the Couchbase profile will attempt to connect to the next one in order. This is repeated until a successful connection can be established. Hence it is not necessary to add all the nodes, but it is good practice to do so for a small cluster. For example, if there are just three nodes, you should add all of them. Hint! The Operation Timeout, Retry Interval Time, and Max Number Of Retries settings together with the Advanced tab setting mz.cb.lock.timeout.in.secs, work jointly. To understand how, see the following explanation. If you for example use the lookup function with transaction, a LOCK ERROR means that the lookup failed because there was already a transaction lock held on the object that the lookup was trying to get from Couchbase. That is, the lookup was not able to get a lock on the object. What is most important here is how the communication between the system and Couchbase works. In case you use the lookup function it works like this: This is why the Operation Timeout parameter does not play a crucial role here. The Operation Timeout parameter is only used when Couchbase is stalling and does not send an answer for a long time. Assuming that the object is locked and This process is repeated until Max Number Of Retries is exhausted or the answer contains a successful result code and the object is retrieved from Couchbase. So, if you for example set Retry Interval Time to 100 ms and Max Number of Retries to 10, you get 100 ms * 10 retries = 1000 ms. However, from an MZ perspective, the timeout of 1000 ms is just for a single lookup attempt and not for the whole lookup operation. To clarify, if you get a failed lookupMany with LOCK_ERROR in the system log, it means that the lookup failed because it tried to get an object with a lock but failed after Max Number Of Retries. That is, some other process (or thread) was holding a lock on that particular object for longer than 1000 ms. This is possible if the Advanced tab setting mz.cb.lock.timeout.in.secs is larger than 1000 ms. In other words, you need to decide what is more important - that the operation succeeds or that the operation is fast. The Management tab contains Cluster Management and Monitoring settings. Couchbase profile - Management tab The following settings are available in the Management tab: Admin User Name If you want to create a new bucket that does not exist in your Couchbase cluster, enter the user name that you stated when installing Couchbase in this field. Admin Password If you want to create a new bucket that does not exist in your Couchbase cluster, enter the password that you stated when installing Couchbase in this field. Bucket Size (MB) Enter the size of the bucket you want to create, in MB. Number of Replicas Enter the number of replicas you want to have. Monitoring - Active Obsolete Frequency (ms) Obsolete Failure Count Obsolete Note! The Couchbase monitoring has become obsolete. Refer to Important Information to find out more. If the bucket you want to access in Couchbase does not exist, the In the Advanced tab you can configure additional properties. These can typically be left unchanged in the standard Couchbase configuration. It is recommended that you change these properties when using the Couchbase profile in Aggregation. For more information about using the Couchbase profile in Aggregation, see Performance Tuning with Couchbase Storage in 9.3.5.3 Aggregation Agent Configuration - Real-Time. Couchbase profile - Advanced tab Note on Client Management Timeout See the text in the Properties field for further information about the properties that you can set. You can use the property To enable this property, set the value to If you set the property value to If you set the property value to The Couchbase statistics that you can log include the following:Connectivity Tab
Setting Description Couchbase Release , and you must enter the mandatory password as the bucket password, which you specify in the Couchbase profile as the Bucket Name and Bucket Password. For further information on creating a bucket, see 11.1 Adding and Removing Buckets.
Bucket User Enter the user who has access rights to the bucket. 
received an answer with LOCK_ERROR, the system will wait for the amount of time specified in Retry Interval Time and then retry the request towards Couchbase.Management Tab
Setting Description Couchbase profile can be used for creating the bucket in runtime for you, provided that the Admin User Name and Admin Password for your Couchbase cluster have been entered in the Management tab. If the bucket you want to access already exists in your cluster, these two fields do not have to be filled in.
Advanced Tab
Logging Couchbase Statistics
mz.cb.statistics.class if you want to log Couchbase statistics to file. The default value is com.digitalroute.mimexposer.statistics.NoDbStatistics.com.digitalroute.mimexposer.statistics.MemDbStatistics or com.digitalroute.mimexposer.statistics.FileDbStatistics.com.digitalroute.mimexposer.statistics.MemDbStatistics, you can use the MIM agent to send statistics to System Insight. To do this, you must configure a workflow with a MIM agent. For further information, see 9.79.6 MIM Agent.com.digitalroute.mimexposer.statistics.FileDbStatistics, you can use the MIM agent to send statistics to System Insight or you can log to file. If you want to log to file only, you do not require the MIM agent. The log file is stored in $MZ_HOME/log per bucket, for example, <bucket name>_couchbase_stats.log, and the file is flushed every 60 seconds by default. If you want to modify how often the file is flushed, set the property mz.cb.statistics.flush.period.in.seconds with the required value in the EC.
Note!
To control Couchbase client managment timeout as described in https://docs.couchbase.com/java-sdk/2.7/client-settings.html check 8.5 Couchbase Profile.
Adding a Server to the Couchbase Cluster
To add a server in the Couchbase Web Console:
Install Couchbase on the server node you want to add, and ensure that you select the option Join Existing Cluster.
In the Dashboard, select Servers.
Click the Add Server Node button.
The Add Server Node dialog is displayed.
Enter the Hostname/IP Address, Username, and Password for the server, and click the Add Server button.
You get a warning saying that all data will be removed from the server.
Click the Add Server button to confirm.
The dialog closes and you return to the Dashboard.
Repeat steps 3 to 5 for all the servers you want to add in your cluster.
When you have added all the servers, click the Rebalance button.
You will now see all the servers that have been added and are pending a rebalance operation.Click the Rebalance button.
The rebalancing will start, and you will see a progress bar at the top of the Dashboard.
If, for any reason, you want to stop the rebalancing, you can click the Stop Rebalance button.
Once the rebalancing is finished, you will see a message saying "Rebalance is finished" flash by, and the Rebalance button will return to the initial state.