Sebastian Estevez

<section>The&nbsp;<a href="https://www.datastax.com/dev/blog/large-graph-loading-best-practices-strategies-part-1">previous post</a>&nbsp;introduced DSE Graph and summarized some key considerations related to dealing with large graphs. This post aims to:
<p>&nbsp;</p>

<ol>
	<li>describe the tooling available to load large data sets to DSE Graph</li>
	<li>point out tips, tricks, and key learnings for bulk loading with DSE Graph Loader</li>
	<li>provide code samples to simplify your bulk loading process into DSE Graph</li>
</ol>

<h3 id="tooling">Tooling</h3>

<p>DSE Graph Loader (DGL) is a powerful tool for loading graph data into DSE Graph. As shown in the marchitecture diagram below, the DGL supports multiple data input sources for bulk loading and provides high flexibility for manipulating data on ingest by requiring custom groovy data mapping scripts to map source data to graph objects. See the&nbsp;<a href="http://docs.datastax.com/en/latest-dse/datastax_enterprise/graph/dgl/graphloaderTOC.html">DataStax docs</a>&nbsp;which cover the DGL, it's API, and DGL mapping scripts in detail.</p>

<p>This article breaks down the tactics for efficient data loading with DGL into the following areas:</p>

<ul>
	<li>file processing best practices</li>
	<li>mapping script best practices</li>
	<li>DGL configuration</li>
</ul>

<h3 id="codeandtactics">Code and Tactics</h3>

<p>Code to accompany this section can be found at:</p>

<p><a href="https://github.com/phact/rundgl">https://github.com/phact/rundgl</a></p>

<p><em>Shout out to Daniel Kuppitz, Pierre Laporte, Caroline George, Ulisses Beresi, Bryn Cooke among others who helped create and refine this framework. Any bugs / mistakes are mine.</em></p>

<p>The code repository consists of:</p>

<ul>
	<li>a wrapper bash script that is used for bookkeeping and calling DGL</li>
	<li>a mapping script whith some helpful utilities and * a generic structure that can be used as a starting point for your own custom mapping scripts</li>
	<li>a set of analysis scripts that can be used to monitor your load</li>
</ul>

<p>The rest of this article will be focused on DGL loading best practices linking to specific code in the repo for clarity.</p>

<h4 id="filebucketing">File Bucketing</h4>

<p>The main consideration to take when loading large data volumes is that DGL performance will suffer if fed too much data in a single run. At the time of this article (2/28/2017), the DGL has features designed for non-idempotent graphs (including deduplication of vertices via an internal vertex cache) that limit its performance with large idempotent graphs.</p>
<img alt="Data Ingestion Graph" data-align="center" data-entity-type="file" data-entity-uuid="a3e939ef-2dc7-4e61-9c8b-d2e58d2b589d" height="189" src="https://www.datastax.com/sites/default/files/inline-images/dgl.png" width="396" /></section>

<p><strong>UPDATE:</strong>&nbsp;In modern versions of the graph loader, custom vertices are no longer cached. This means there should not be a performance impact of large files for this kind of load. Chunking may still be useful for percentage tracking / restarting / etc.</p>

<section>The rundgl script found in the repo is designed to traverse a directory and bucket files, feeding them to DGL a bucket at a time to maximize performance.
<p>&nbsp;</p>

<h4 id="trackyourprogress">Track your progress</h4>

<p>The analysis directory in the rundgl repo contains a script called chart. This script will aggregate statistics from the DGL loader.log and generate throughput statistics and charts for the different loading phases that have occurred (Vertices, Edges, and Properties).</p>

<p><strong><em>Note</em></strong><em>- these scripts have only been tested with DGL &lt; 5.0.6</em></p>

<p>Navigate to the analysis directory and run&nbsp;<code>./charts</code>&nbsp;to get a dump of the throughput for your job:</p>

<p>It will also start a simple http server in the directory for easy access to the png charts it generates, here is an example chart output:</p>

<p><em>Thank you Pierre for building and sharing the analysis scripts</em></p>

<h4 id="monitordglerrors">Monitor DGL errors</h4>

<p>When the DGL gets timeouts from the server it does not log them to STDOUT, they can only be seen in logger.log. In a busy system, it is normal to see timeouts. These timeouts will be handled by retry policies which are baked into the loader. Too many timeouts may be a sign that you are overwhelming your cluster and need to either slow down (reduce threads in the loader) or scale out (add nodes in DSE). You will know if timeouts are affecting your cluster if your overall throughput starts trending down or if you are seeing backed up threadpools or dropped mutations in OpsCenter.</p>

<p>Aside from Timeouts, you may also see errors in the DGL log that are caused by bad data or bugs in your mapping script. If enough of these errors happen the job will stop. To avoid having to restart from the beginning on data related issues, take a look at the bookeeping section below.</p>

<h4 id="dontuses3">Don't use S3</h4>

<p>If you are looking to load significant amounts of data, do not use S3 as a source for performance reasons. It will take less time to parallel rsync your data from s3 to a local SSD and then load it than to load directly from s3.</p>

<p>DGL does have S3 hooks and from a functionality perspective it works quite well (including aws authentication) so if you are not in a hurry, the repo also includes an example for pulling data from S3. Just be aware of the performance overhead.</p>

<h4 id="groovymapperbestpractices">Groovy mapper best practices</h4>

<p>Custom groovy mapping scripts can be error prone and the DGL's error messages sometimes leave a bit to be desired. The framework provided aims to simplify the loading process by providing a standard framework for all your mapping scripts and minimizing the amount of logic that goes into the mapping scripts.</p>

<h4 id="usethelogger">Use the logger</h4>

<p>DGL mapping scripts can use the log4j logger to log messages. This can be very useful when troubleshooting issues in a load, especially issues that only show up at runtime with a particular file.</p>

<p>It also allows you to track when particular loading events occur during execution.</p>

<p>INFO, WARN, and ERROR messages will be logged to logger.log and will include a timestamp.</p>

<h4 id="dgltakesarguments">DGL takes arguments</h4>

<p>If you need to pass an argument to the groovy mapper just pass it with&nbsp;<code>- &lt;argname&gt;</code>&nbsp;in the command line.<br />
The variable argname will be available in your mapping script.</p>

<p>For example, ./rundgl passes&nbsp;<code>-inputfilename</code>&nbsp;to DGL&nbsp;<a href="https://github.com/phact/rundgl/commit/6d008c86e98403c001c4164fcd8772ee9c2fa9bd#diff-ee4a3dcdb94cf3b56f6b0f191b4d4fd9R51">here</a>&nbsp;leveraging this feature. You can see the mapping script use it&nbsp;<a href="https://github.com/phact/rundgl/commit/6d008c86e98403c001c4164fcd8772ee9c2fa9bd#diff-46c8d2f865ad43987bc511d246a4b159R101">here</a>.</p>

<p>The argument&nbsp;<code>inputfilename</code>&nbsp;is a list of files to process to the DGL. This helps us avoid having to do complex directory traversals in the mapping script itself.</p>

<p>By traversing files in the wrapper script, we are also able to do some bookeeping.</p>

<h4 id="bookeeping">Bookeeping</h4>

<p><code>loadedfiles.txt</code>&nbsp;tracks the start and end of your job as well as the list of files that were loaded and when each particular load completed. This also enables us to "resume" progress by modifying the&nbsp;<code>STARTBUCKET</code>.</p>

<p><code>STARTBUCKET</code>&nbsp;represents the first bucket that will be processed by&nbsp;<code>./rundgl</code>, if you stopped your job and want to continue where you left off, count the number of files in&nbsp;<code>loadedfiles.txt</code>&nbsp;and divide by the&nbsp;<code>BUCKETSIZE</code>, this will give you the bucket you were on. Starting from that bucket will ensure you don't miss any files. Since we are working with idempotent graphs, we don't have to worry about duplicates etc.</p>

<h4 id="dglvertexcachetempdirectory">DGL Vertex Cache Temp Directory</h4>

<p>Especially when using EBS, make sure to move the default directory of the DGL Vertex Cache temp directory.</p>

<p>IO contention against the mapdb files used by DGL for its internal vertex cache will overwhelm amazon instances' root EBS partitions</p>

<p><code>Djava.io.tmpdir=/data/tmp</code></p>

<h4 id="leavesearchforlast">Leave search for last</h4>

<p>If you are working on a graph schema that uses DSE Search indexes, you can optimize for overall load + indexing time by loading the data without the search indexes first and then creating the indexes once the data is in the system.</p>

<h3 id="somescreenshots">Some screenshots</h3>

<p>Here are some screenshots from a system using this method to load billons of vertices. The spikes are each run of the DGL kicked off in sequence by the rundgl mapping script. You can see the load and performance are steady throughout the load giving us dependable throughput.<br />
Like with other DSE workloads, if you need more speed, scale out!</p>

<h4 id="throughput">Throughput:</h4>

<h4 id="osload">OS Load:</h4>

<h3 id="conclusion">Conclusion</h3>
<img alt="Results" data-align="center" data-entity-type="file" data-entity-uuid="4e3defed-f6a1-4b34-a028-a1272372bb4b" src="https://www.datastax.com/sites/default/files/inline-images/dgl_results.png" /></section>


Large Graph Loading Best Practices: Tactics (Part 2)

Sebastian EstevezDataStax

Discover more

Share

Share

More Technology

How Winweb Built its AI Assistant with DataStax Astra DB and LangChain

Vercel + Astra DB: Get Data into Your GenAI Apps Fast

Simplifying Agent Development with Astra DB Connector for Vertex AI Search

Making Astra DB easier for MongoDB developers

One-stop Data API for Production GenAI