Using the IBM Cloudant Dashboard

Objectives

1. Open the IBM Cloudant Dashboard.
2. Create a database.
3. Add JSON documents to the database and run a query.
4. Replicate a database.
5. Monitor active tasks.
6. Monitor with IBM Cloudant.

Before you begin

Create a service instance in IBM Cloud before you start this tutorial. You can follow the instructions in the Getting started tutorial to create one.

Opening your service instance on IBM Cloudant Dashboard

Open your IBM Cloudant service instance by following these steps:

1. Go to the IBM Cloud Dashboard.

2. Click Services in the Resource list.

3. From the Services section, click the Cloudant-o7 instance that you created in the Getting started tutorial, and click Launch Dashboard. The IBM Cloudant Dashboard opens.

Now, you can create a database and run queries against it.

Creating a database

In this exercise, you create the dashboard-demo database, which is the database that you use in this tutorial.

1. From the IBM Cloudant Dashboard, click Create database.

   The Create database window opens.

2. Enter the database name dashboard-demo.

3. Select Non-partitioned, and click Create.

   The dashboard-demo database opens automatically.

Now, you can create some documents.

Adding documents to the database

The documents that you create in this exercise include the data that you use to query the dashboard-demo database in later exercises.

1. Click Create document.

   The New Document window opens.

2. Copy the following sample text and replace the existing text in the new document. Use the following sample text for document 1:

   {
     "firstname": "Sally",
     "lastname": "Brown",
     "age": 16,
     "location": "New York City, NY",
     "_id": "doc1"
   }
   

3. Repeat steps 1 and 2 to add the remaining four documents to the database. Use the following sample text for document 2:

   {
     "firstname": "John",
     "lastname": "Brown",
     "age": 21,
     "location": "New York City, NY",
     "_id": "doc2"
   }
   

   Use the following sample text for document 3:

   {
     "firstname": "Greg",
     "lastname": "Greene",
     "age": 35,
     "location": "San Diego, CA",
     "_id": "doc3"
   }
   

   Use the following sample text for document 4:

   {
     "firstname": "Anna",
     "lastname": "Greene",
     "age": 44,
     "location": "Baton Rouge, LA",
     "_id": "doc4"
   }
   

   Use the following sample text for document 5:

   {
     "firstname": "Lois",
     "lastname": "Brown",
     "age": 33,
     "location": "New York City, NY",
     "_id": "doc5"
   }
   

   You populated the dashboard-demo with five documents. You can see the documents from the Table view in the following screen capture:

   

Replicating a database

When you replicate a database, it synchronizes the state of two databases: source and target. A replication copies all the changes that happened in the source database to the target database. When a document is deleted from the source database, the document is also deleted from the target database.

For more information, see Replication.

1. Click Replication.

2. Click New Replication.

   The Job configuration page opens.

   Additionally, you can create a replication from the databases page by clicking Replicate in the Actions column.

3. Enter the following information for your replication job. Use the following information in the Source section:

   • Type - Select Remote database.
   • Name - Enter the database URL: $SERVICE_URL/query-movies.
   • Authentication - Leave as None.

   Use the following information in the Target section:

   • Type - Select New local database.
   • New database - Enter the name for the new database, query-movies.
   • New database options - Do not select the Partitioned option.
   • Authentication - Select IAM Authentication.
   • IAM API Key - Enter the apikey from the Service credentials for your instance.

   For more information, see the section on Locating your service credentials.

   Use the following information in the Options section:

   • Replication type - Leave as One time.
   • Replication document - Leave as Custom ID (optional.

   

4. Click Start Replication.

   The Replication page opens where you can see that your replication job is running.

   

5. See the status when your job finishes change to Completed.

6. Check that the database was created on the databases page.

   

Monitoring active tasks

The Active tasks page displays a list of all running tasks. When you monitor your system's performance, this list can help you find potential issues. You can see a list of active tasks, which includes compaction, replication, and indexing. For more information, see the Managing tasks guide.

If your instance does not have any active tasks, you can return to the previous step, delete the query-movies database, and then replicate it again. If you open the Active Tasks page immediately, you can see your replication.

1. Click Active Tasks.

   The Active Tasks page opens.

   

2. Click the associated tab to see task-specific information.

Monitoring with IBM Cloudant

Monitor your usage with a graph that shows your throughput by reads, writes, and global queries. You can see your current operations, denied requests, and storage usage.

Your service instance contains no data because it is for demonstration purposes only. However, you can see what monitoring information is available to you by following these steps:

1. Click Monitoring.

   The Monitoring page opens to the Current Operations tab. Review recent consumption of provisioned throughput capacity by looking at requests broken down by reads, writes, and global queries. The dotted line is the peak capacity that is allowed for your instance. Peak capacity is based on what is set for your provisioned throughput capacity.

   

2. Click Denied Requests.

   Review the number of denied requests from a given second that are shown by the number of 429: too many requests responses. Requests are denied when they exceed the provisioned throughput capacity set for the instance. The graph shows the denied requests that are broken down by reads, writes, and global queries.

   

3. Click Storage.

   Periodically review your storage, so you are prepared if your plan's provisioning needs to be changed.

   

For more information, see Plans and provisioning.