Donnie Roberson

Many architects and developers today are targeting <a href="https://www.datastax.com/why-datastax/apache-cassandra">Apache Cassandra</a>&trade;and <a href="https://www.datastax.com/products/datastax-enterprise">DataStax Enterprise (DSE)</a> as their database of choice because of its ability to easily scale and perform under extreme workloads. Developers like the fact that no modifications are required on their part if the application is initially written to just use one DSE node, but scales into hundreds in the future.
According to the <a href="https://insights.stackoverflow.com/survey/2018#technology-developers-primary-operating-systems">2018 Stack Overflow Developer Survey</a> Microsoft Windows was the number one platform used by developers at 49.9%, followed by MacOS at 26.7%. Many times these developers need a complete environment to do their work, and this translates into having a fully functioning copy of the database their application will target running on their Windows workstation or laptop.
Years ago, we recommended running DSE in virtual machines for Windows, but developers found this would take hours of effort getting the OS and DSE setup inside the virtual machine. With Docker, you can have a DSE instance up and running on Windows in a matter of minutes.
This article will show you how to easily work with DSE, our visual developer tool (<a href="https://www.datastax.com/tools/studio">DataStax Studio</a>), and our management console (<a href="https://www.datastax.com/tools/enterprise-ops-center">DataStax OpsCenter</a>) on Windows.
<h2>Prerequisites</h2>
<ul>
<li>Basic understanding of Docker images and <a href="https://github.com/jpetazzo/intro-to-docker">containers</a>.</li>
<li>A machine running Windows 10 64-bit with <a href="https://docs.docker.com/docker-for-windows/install/">Docker installed</a>.</li>
<li>A <a href="https://docs.datastax.com/en/landing_page/doc/landing_page/supportedPlatforms.html#supportedPlatforms__browser-support">Supported Browser</a> in Chrome or Firefox for OpsCenter and Studio use.</li>
<li>When using Docker for Windows, the default resources allocated to the linux VM running docker are 2GB RAM and 2 CPU's. Make sure to adjust these resources to meet the resource requirements for the containers you will be running. For this article, I suggest 6GB of Ram and 2 CPUs. More information can be found here on adjusting the resources allocated to docker.</li>
</ul>
<h2>Getting Started</h2>
In this article we will be running three DataStax Containers:
<ul>
<li><a href="https://downloads.datastax.com/#enterprise">DataStax Enterprise</a></li>
<li><a href="https://www.datastax.com/tools/enterprise-ops-center">DataStax OpsCenter</a></li>
<li><a href="https://www.datastax.com/tools/studio">DataStax Studio</a></li>
</ul>
Once you have your Windows environment setup with Docker running, you can jump right in, opening a PowerShell by pressing the windows key + R, typing PowerShell and pressing enter.
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2011.20.34%20AM.png" alt="Run Docker" data-entity-type="file" data-entity-uuid="e8948e93-a865-4a9c-a9cb-30ba9e4c042d" />
<h2>Starting a DSE container</h2>
By default, the DSE server image is set up as a general purpose operational/transactional database node. To set up the node with DSE advanced functionality, add the option that enables that feature to the end of the docker run command.
<div class="zdb-database-table">
<table>
<tbody>
<tr>
<td>
DSE start switches
</td>
<td>
Description
</td>
</tr>
<tr>
<td>
-s
</td>
<td>
Enables and starts&nbsp;<a href="https://www.datastax.com/products/datastax-enterprise-search">DSE Search</a>.
</td>
</tr>
<tr>
<td>
-k
</td>
<td>
Enables and starts&nbsp;<a href="https://www.datastax.com/products/datastax-enterprise-analytics">DSE Analytics</a>.
</td>
</tr>
<tr>
<td>
-g
</td>
<td>
Enables and starts&nbsp;<a href="https://www.datastax.com/products/datastax-enterprise-graph">DSE Graph</a>.
</td>
</tr>
</tbody>
</table>
</div>
You can combine the options to run more than one feature. For more examples, see the getting started <a href="http://docs.datastax.com/en/dse/6.7/dse-admin/datastax_enterprise/operations/startStop/startDseStandalone.html">DSE documentation</a>.
Let's begin by starting the DSE server. Note that when the container starts for the first time, it will take a minute to bootstrap.
To start the DSE container, we are using the docker run command with the environment variable (-e DS_LICENSE=accept) to accept the DataStax License, --name my-dse (names our container) -d detaches from the terminal (runs in the background), and we are using the latest DSE image datastax/dse-server (we can add a specific version of dse by adding a tag to the end for the version we want to use, for example, to use run DSE 6.7.1 we would use datastax/dse-server:6.7.1).
<code>docker run -e DS_LICENSE=accept --name my-dse -d datastax/dse-server</code>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-06%20at%208.34.11%20PM.png" alt="DSE Server" data-entity-type="file" data-entity-uuid="db713ec3-62af-4000-a02e-c6655b469629" />
Once started, we can take a quick look at the DSE logs to ensure all is well:
<code>docker logs my-dse</code>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-06%20at%208.36.32%20PM.png" alt="DSE Container" data-entity-type="file" data-entity-uuid="f6445193-62f5-4f14-98a1-53cf503310dd" />
Now that you have a running DSE container, let&rsquo;s get familiar with how to run some of the commands you will use on a regular basis. You will need your PowerShell here. The general syntax for commands against your dse container will be:
<code>docker exec -it</code>
For example, to get a cqlsh prompt that allows you to enter Cassandra Query Language (CQL; an SQL-like language) against the DSE Server, type:
<code>docker exec -it my-dse cqlsh</code>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.28.13%20PM.png" alt="Cassandra Query Language" data-entity-type="file" data-entity-uuid="564ff231-e930-40a0-af3f-e6ed6c14644c" />
To exit the shell, type &lsquo;exit&rsquo;; and press enter or CTRL D.
To see the basic status of your personal DSE server, you can use the nodetool command line utility in conjunction with the &lsquo;status&rsquo; command:
<code>docker exec -it my-dse nodetool status</code>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.26.42%20PM.png" alt="Personal DSE Server" data-entity-type="file" data-entity-uuid="64524745-26ff-48ce-a7d6-456461c086a8" />
To see different information about your single node &lsquo;ring&rsquo; / cluster, use dsetool &lsquo;ring&rsquo; command:
<code>docker exec -it my-dse dsetool ring</code>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%202.19.13%20PM.png" alt="dsetool ring command" data-entity-type="file" data-entity-uuid="a8727745-7b78-4dff-8c0d-174fa0f7fb60" />
These are only a few of the commands that are available. See the official DSE <a href="https://docs.datastax.com/en/dse/6.7/dse-admin/datastax_enterprise/tools/nodetool/toolsNodetool.html">Admin Guide</a> for advanced usage and more commands.
Since most personal laptops have limited resources, we will stop and remove this DSE container for our next exercise (note that this will remove its state and any changes made will be lost).
<code>docker rm -f my-dse</code>
Monitoring with OpsCenter
Next, let&rsquo;s create both a DSE container and an DSE OpsCenter container to administer and monitor DSE.
First, create an OpsCenter container:
<code>docker run -e DS_LICENSE=accept --name my-opscenter -d -p 8888:8888 datastax/dse-opscenter</code>
When using <code>docker run</code>, if the images do not exist locally, Docker will automatically pull the image, store it locally, and start the container. This could take a few minutes depending on your internet connection.
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2011.29.32%20AM.png" alt="Internet Connection" data-entity-type="file" data-entity-uuid="eb75a079-7da1-4ea0-a201-334cb3040f50" />
Next, create a DSE container, providing the &lsquo;--link&rsquo; flag to the OpsCenter container. By providing --link, the DataStax agent will be &lsquo;automagically&rsquo; configured and started.
<code>docker run -e DS_LICENSE=accept --link my-opscenter:opscenter --name my-dse -d datastax/dse-server</code>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-07%20at%2012.18.23%20PM.png" alt="DSE Server" data-entity-type="file" data-entity-uuid="645175f8-b99f-4184-8b2f-147c7e22826a" />
Third, find the IP address of your new DSE node:
<code>docker inspect my-dse | FINDSTR "IPAddress"</code>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.02.16%20PM.png" alt="OpsCenter" data-entity-type="file" data-entity-uuid="e5cb8a27-a50a-4389-946f-04d60633cc41" />
Then, open a browser and point to http://localhost:8888. The Welcome to DataStax OpsCenter dialog displays.
Click Manage existing cluster.
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.08.08%20PM.png" alt="OpsCenter Manage Cluster" data-entity-type="file" data-entity-uuid="52821272-2822-4c16-8d50-927df7fae9e0" />
Then, enter the IP address for the DSE Node (from the previous step):
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.07.23%20PM.png" alt="DSE Node" data-entity-type="file" data-entity-uuid="1e511caa-28c3-452a-8ad2-1a3fe08cf3b0" />
Choose Install agents manually and close. The agent is already installed.
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.10.27%20PM.png" alt="Install Agents" data-entity-type="file" data-entity-uuid="3e382e59-9e8b-406f-9c65-d1241146d9b2" />
You have now added your DSE container to the OpsCenter container, which lets you manage and monitor your DSE node.
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.13.04%20PM.png" alt="DSE Container" data-entity-type="file" data-entity-uuid="30280585-eef7-437b-b7e9-14091147288c" />
See the <a href="http://docs.datastax.com/en/opscenter/6.7/">OpsCenter documentation</a> for further info on usage/configuration. Note that OpsCenter&rsquo;s LifeCycle Manager is currently not supported in containerized environments. Other tasks like restarting nodes are also not supported.
<h2>Developing with DataStax Studio</h2>
DataStax provides Studio, a visual notebook-styled IDE for developers to help with development in CQL, DSE Graph and Spark SQL.
To use Studio with your DSE node, first create a Studio container and link it to your DSE container:
<code>docker run -e DS_LICENSE=accept --link my-dse --name my-studio -p 9091:9091 -d datastax/dse-studio</code>
Then, open your browser and point it to <a href="http://localhost:9091/">http://localhost:9091</a>
<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%2012.53.38%20PM.png" alt="Local Host" data-align="center" data-entity-type="file" data-entity-uuid="fd949e4d-d16d-4aea-9f38-4494a8a134bd" />
To use the provided notebooks, you will need to modify the default connection to use the IP address or linked name of your DSE container. To do that, follow these steps:
<ol>
<li>Click the <img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%201.27.47%20PM.png" alt="menu" data-entity-type="file" data-entity-uuid="6e09ef22-b969-495b-b011-60790dbfa120" /> at the top left</li>
<li>Click connections</li>
<li>Click default localhost, change the Host/IP to your container and click test<img src="https://www.datastax.com/sites/default/files/inline-images/Screen%20Shot%202019-03-04%20at%201.31.03%20PM.png" alt="LocalHost" data-entity-type="file" data-entity-uuid="b29041c3-116d-41cc-b552-ca0ebc98c501" /></li>
<li>
Save your configuration
</li>
<li>
You can now go back to your notebooks and explore the Working With CQL notebook and begin creating notebooks of your own.
<ol>
<li>
Note that to utilize the other notebooks you would need your workload to be running analytics and/or graph.
</li>
</ol>
</li>
</ol>
Visit the <a href="https://docs.datastax.com/en/studio/6.7/index.html">Studio documentation</a> for further instructions.
<h2>Summary</h2>
We&rsquo;ve shown in this article how you can easily create a development environment using Docker for Windows to monitor and develop on DSE. For the next steps:
<ul>
<li>Check out the <a href="https://docs.datastax.com/en/docker/doc/index.html">DataStax Docker Docs</a> for more advanced configuration.</li>
<li>Check out the <a href="https://github.com/datastax/docker-images">DataStax Docker Github Repo</a> to learn how to customize the images and help make them better</li>
</ul>
Visit <a href="https://academy.datastax.com/">DataStax Academy</a> for free, self-paced DSE training.

Build and scale cloud native apps

Discover the benefits of DBaaS and why your apps deserve an upgrade.

Learn about NoSQL Databases

Learn about NoSQL databases with Apache Cassandra and Astra DB.

2022 Recap: A Year for Customers, Community, and Real-Time Data

Highlights from 2022 and a glimpse into the year ahead.

ViewingTechnical How To’s

Running DSE on Microsoft Windows Using Docker

Sign up for our Developer Newsletter