urn:noticeable:projects:bYyIewUV308AvkMztxixSherlock changelogwww.sherlock.stanford.edu2022-12-03T02:57:36.261ZCopyright © SherlockNoticeablehttps://storage.noticeable.io/projects/bYyIewUV308AvkMztxix/newspages/GtmOI32wuOUPBTrHaeki/01h55ta3gs1vmdhtqqtjmk7m4z-header-logo.pnghttps://storage.noticeable.io/projects/bYyIewUV308AvkMztxix/newspages/GtmOI32wuOUPBTrHaeki/01h55ta3gs1vmdhtqqtjmk7m4z-header-logo.png#8c1515urn:noticeable:publications:lWJ0NjSCycX68eP1aVpU2022-12-03T02:57:22.756Z2022-12-03T02:57:36.261ZClusterShell on SherlockEver wondered how your jobs were doing while they were running? Keeping a eye on a log file is nice, but what if you could quickly gather process lists, usage metrics and other data points from all the nodes your multi-node jobs are running<p>Ever wondered how your jobs were doing while they were running? Keeping a eye on a log file is nice, but what if you could quickly gather process lists, usage metrics and other data points from all the nodes your multi-node jobs are running on, all at once?<br><br>Enter <a href="https://cea-hpc.github.io/clustershell/?utm_source=noticeable&amp;utm_campaign=sherlock.clustershell-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.lWJ0NjSCycX68eP1aVpU&amp;utm_medium=newspage" rel="noopener nofollow" target="_blank" title="ClusterShell">ClusterShell</a>, the best parallel shell application (and library!) of its kind.<br><br>With ClusterShell on Sherlock, you can quickly run a command on all the nodes your job is running on, to gather information about your applications and processes, in real time, and gather live output without having to wait for your job to end to see how it did. And with its tight integration with the job scheduler, no need to fiddle with manual node lists anymore, all it needs is a job id!<br><br>You allocated a few nodes in an interactive session and want to distribute some files on each node’s local storage devices? Check: ClusterShell has a <a href="https://clustershell.readthedocs.io/en/latest/tools/clush.html?utm_source=noticeable&amp;utm_campaign=sherlock.clustershell-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.lWJ0NjSCycX68eP1aVpU&amp;utm_medium=newspage#file-copying-mode" rel="noopener nofollow" target="_blank" title="File copy mode">copy mode</a> just for this.<br><br>Want to double-check that your processes are correctly laid out? Check: you can run a quick command to check the process tree across the nodes allocated to your job with:</p><pre><code>$ clush -w @job:$JOBID pstree -au $USER</code></pre><p>and verify that all your processes are running correctly.<br><br>You’ll find more details and examples in our Sherlock documentation, at <a href="https://www.sherlock.stanford.edu/docs/software/using/clustershell/?utm_source=noticeable&amp;utm_campaign=sherlock.clustershell-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.lWJ0NjSCycX68eP1aVpU&amp;utm_medium=newspage#local-storage" rel="noopener nofollow" target="_blank">https://www.sherlock.stanford.edu/docs/software/using/clustershell</a><br><br>Questions, ideas, or suggestions? Don’t hesitate to reach out to <a href="mailto:[email protected]" rel="noopener nofollow" target="_blank">[email protected]</a> to let us know!</p>Kilian Cavalotti[email protected]urn:noticeable:publications:vRTJK87T55GDHGLpRetu2021-10-29T17:29:35.955Z2021-10-29T23:46:48.271ZKeep up to date with software updatesTo help users stay on top of software changes on Sherlock, we’ve recently introduced a new software updates RSS feed. It’s available from the Sherlock software list page, and you can directly add it to your RSS reader of choice. And if<p>To help users stay on top of software changes on Sherlock, we’ve recently introduced a new <a href="https://www.sherlock.stanford.edu/docs/software/updates.xml?utm_source=noticeable&amp;utm_campaign=sherlock.keep-up-to-date-with-software-updates&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.vRTJK87T55GDHGLpRetu&amp;utm_medium=newspage" rel="noopener nofollow" target="_blank" title="Sherlock software updates RSS feed">software updates RSS feed</a>. <br></p><figure><img src="https://storage.noticeable.io/projects/bYyIewUV308AvkMztxix/publications/vRTJK87T55GDHGLpRetu/01h55ta3gs5brgqrjmt3drcfj8-image.png" alt="" loading="lazy" title=""></figure><br>It’s available from the <a href="https://www.sherlock.stanford.edu/docs/software/list/?utm_source=noticeable&amp;utm_campaign=sherlock.keep-up-to-date-with-software-updates&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.vRTJK87T55GDHGLpRetu&amp;utm_medium=newspage" rel="noopener nofollow" target="_blank" title="Sherlock software list">Sherlock software list</a> page, and you can directly add it to your <a href="https://rss.com/blog/how-do-rss-feeds-work/?utm_source=noticeable&amp;utm_campaign=sherlock.keep-up-to-date-with-software-updates&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.vRTJK87T55GDHGLpRetu&amp;utm_medium=newspage" rel="noopener nofollow" target="_blank">RSS</a> reader of choice.<br><br>And if you’re already following our <a href="https://www.sherlock.stanford.edu/docs/?utm_source=noticeable&amp;utm_campaign=sherlock.keep-up-to-date-with-software-updates&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.vRTJK87T55GDHGLpRetu&amp;utm_medium=newspage#user-community" rel="noopener nofollow" target="_blank" title="Sherlock Slack channels">Slack channels</a>, you can subscribe to the new <a href="https://app.slack.com/client/T8DCR4HPU/C02KLUE8XCK?utm_source=noticeable&amp;utm_campaign=sherlock.keep-up-to-date-with-software-updates&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.vRTJK87T55GDHGLpRetu&amp;utm_medium=newspage" rel="noopener nofollow" target="_blank" title="#sherlock-software-updates">#sherlock-software-updates</a> channel to get automatically notified of new software updates on Sherlock, directly from Slack.<br><br>Happy computing! And as usual, please feel free to&nbsp;<a href="mailto:[email protected]" rel="noopener" target="_blank">reach out</a>&nbsp;if you have comments or questions.<p></p>Kilian Cavalotti[email protected]urn:noticeable:publications:VhydQm59DPSiHOomcZcW2019-12-13T18:29:00.001Z2019-12-13T19:55:23.129ZSecure TensorBoard sessions with Sherlock OnDemandIf you're into machine learning (and who isn't these days?), you probably know all about TensorBoard already. If you don't, TensorBoard is TensorFlow's visualization toolkit. It provides the visualization and tooling needed for machine...<p>If you’re into machine learning (and who isn’t these days?), you probably know all about <a href="//www.tensorflow.org/tensorboard" target="_blank" rel="noopener">TensorBoard</a> already.</p> <p>If you don’t, TensorBoard is <a href="//www.tensorflow.org" target="_blank" rel="noopener">TensorFlow</a>'s visualization toolkit. It provides the visualization and tooling needed for machine learning workflows: it enables tracking experiment metrics like loss and accuracy, visualizing model graphs, viewing histograms of weights, biases, or other tensors as they change over time, or profiling TensorFlow programs. All kinds of cool and useful stuff.</p> <p><img src="https://storage.noticeable.io/projects/bYyIewUV308AvkMztxix/publications/VhydQm59DPSiHOomcZcW/01h55ta3gsyjxd2gfr2pg26psr-image.png" alt="tb.png"></p> <h2>TensorBoard (lack of) security model</h2> <p>But one thing that TensorBoard doesn’t do is user authentication and authorization: there is no notion of user session, credentials, nor access control in TensorBoard, and <a href="//github.com/tensorflow/tensorboard/issues/267" target="_blank" rel="noopener">no plan to implement any</a>.</p> <p>What it means in practice, is that TensorBoard is a great solution if you’re developing and testing things on your own laptop, where you’re the only user. But on shared environments like HPC clusters in general and <a href="//www.sherlock.stanford.edu" target="_blank" rel="noopener">Sherlock</a> in particular, running a TensorBoard instance on a compute node means that any user on the cluster can connect to it, and interact with it, as if they were you: TensorBoard runs under your account, and through its unprotected web interface, it exposes your files and processes to any user that can connect to its web interface. There is no authentication mechanism.</p> <p>Which is, for lack of better term, "not great".</p> <h2>Your own private and secure TensorBoard, on demand</h2> <p>Because it would be a shame to not be able to use such a valuable tool on our clusters, <a href="//srcc.stanford.edu" target="_blank" rel="noopener">we</a> came up with a solution to let users on Sherlock run TensorBoard in a secure and private way, without adding any additional configuration or access burden.</p> <p>The <a href="//login.sherlock.stanford.edu/pun/sys/dashboard/batch_connect/sys/sh_tensorboard/" target="_blank" rel="noopener">TensorBoard OnDemand app</a>, which is accessible through the <a href="//www.sherlock.stanford.edu/docs/user-guide/ondemand/" target="_blank" rel="noopener">Sherlock OnDemand</a> portal, implements an authenticating reverse proxy that ensures that only the user who started the session can access it.</p> <p>In a nutshell, by setting a browser cookie in the OnDemand interactive app page, we can make sure that the authenticating reverse proxy we developed and that controls access to the TensorBoard web interface, only authorize requests that come from the user authenticated through the OnDemand web page.</p> <p>Without that cookie, access to the TensorBoard web interface is denied. And if the cookie is ever lost, users can simply re-create it by visiting the “My Interactive Sessions” page and clicking the “Connect” button again.</p> <p><img src="https://storage.noticeable.io/projects/bYyIewUV308AvkMztxix/publications/VhydQm59DPSiHOomcZcW/01h55ta3gsys647ma04scdqt0j-image.png" alt="tbood.png"></p> <p>And if you’re curious about the details, or if you’re not using Sherlock and would like to implement a similar solution at your site, our TensorBoard OnDemand app is available on <a href="//github.com/stanford-rc/sh_ood-apps/tree/master/sh_tensorboard/" target="_blank" rel="noopener">GitHub</a>.</p> <h2>TL;DR</h2> <p>TensorBoard sessions on Sherlock are secure and private, in a completely transparent way.</p> <p>It’s a little thing, but we hope it can make working on Sherlock more secure, without putting any additional configuration burden on the users.</p> <p>So happy experimenting in TensorBoard, and as usual, please don’t hesitate to <a href="[email protected]" target="_blank" rel="noopener">reach out</a> if you have any comments or questions.</p> Kilian Cavalotti[email protected]urn:noticeable:publications:pdsPdRdNtXcXpsmcpdqS2019-04-24T18:55:00.001Z2019-04-24T19:44:25.781ZModule versions get a facelift If you're a Sherlock user who often needs to load specific module versions, but don't care or can't remember specific minor version numbers, you're in luck! Starting today, Sherlock allows loading modules via an extended default system...<p>If you’re a Sherlock user who often needs to load specific module versions, but don’t care or can’t remember specific minor version numbers, you’re in luck!</p> <p>Starting today, Sherlock allows loading modules via an <em>extended default</em> system which will automatically load the best available version, based on what users request.</p> <h2>Too many versions</h2> <p>There are too many version numbers to remember. For instance, take CUDA:</p> <pre><code class="hljs language-shell"><span class="hljs-meta">$</span><span class="bash"> ml av cuda</span> --------------- devel -- compilers, MPI, languages, libs --------------- cuda/8.0.61 (g) cuda/9.2.148 (g) cuda/9.0.176 (g,D) cuda/10.0.130 (g) cuda/9.1.85 (g) cuda/10.1.105 (g) cuda/9.2.88 (g) Where: g: GPU support D: Default Module </code></pre> <p>There are a number of versions of the CUDA module, that follow the <a href="https://semver.org?utm_source=noticeable&amp;utm_campaign=sherlock.module-versions-get-a-facelift&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.pdsPdRdNtXcXpsmcpdqS&amp;utm_medium=newspage" target="_blank" rel="noopener">semantic versioning</a> scheme of <code>major.minor.patch</code> version numbers.</p> <p>This is great, but in practice, most of us only care about the <code>major</code> version number. Sometimes <code>major.minor</code>, but mostly, we just want to get the latest <code>patch</code> version. Without having to look it up, let alone remember it.</p> <h2>Extended defaults</h2> <p>Enter <em>extended defaults</em>, a new module mechanism to simplify all of this.</p> <p>Starting now, you can simply load a module using its major version number, and you’ll get the best module that matches your request.</p> <p>For instance:</p> <pre><code class="hljs language-shell"><span class="hljs-meta">$</span><span class="bash"> ml cuda/10.1</span> </code></pre> <p>will automatically load <code>cuda/10.1.105</code></p> <p>If you want to specific a minor version, but don’t care about the patch number, you can too:</p> <pre><code><span class="hljs-meta">$</span><span class="bash"> ml cuda/9.2</span> </code></pre> <p>will load <code>cuda/9.2.148</code></p> <p>Finally, if you don’t specify any version at all, the highest version number will automatically be loaded, unless a default is defined (noticeable with the <code>D</code> flag in <code>ml av</code> output) which will be used instead.</p> <p>We hope this will make things easier, and if you have any question, don’t hesitate to reach out at <a href="mailto:[email protected]" target="_blank" rel="noopener">[email protected]</a></p> Kilian Cavalotti[email protected]urn:noticeable:publications:W89yPLTsDFBdz1a4jB7v2018-11-13T22:31:00.001Z2018-12-13T16:39:04.927ZSherlock goes container-nativeIn recognition of the fast-moving software landscape and the emerging needs of our users, we're pleased to announce, from the SC18 Supercomputing conference in Dallas, TX, that Sherlock is going container-native. Starting today, users...<p>In recognition of the fast-moving software landscape and the emerging needs of our users, we’re pleased to announce, from the <a href="https://sc18.supercomputing.org/?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">SC18 Supercomputing conference</a> in Dallas, TX, that Sherlock is going container-native.</p> <p>Starting today, users won’t need to load any software module to run their <a href="https://www.sylabs.io/singularity/?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">Singularity</a> or <a href="https://www.docker.com/why-docker?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">Docker</a> containers on Sherlock. <a href="https://news.sherlock.stanford.edu/posts/running-containers-on-sherlock?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">Singularity is now available</a> natively on each and every login and compute node on Sherlock, and containers can be executed directly, no preliminary command required.</p> <p>Oh, and just because we like to go all-in, we’re also throwing a brand new Singularity version into the mix. <a href="https://www.sylabs.io/2018/08/a-glimpse-into-singularity-3-0/?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">Singularity 3.0 brings many new features</a> to the table, including:</p> <ul> <li>base code re-write into Go</li> <li><a href="https://www.sylabs.io/2018/03/sif-containing-your-containers/?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">Singularity Image Format</a> (SIF)</li> <li>key management Platform (based in PGP) for signing and verification</li> <li>integration With <a href="https://www.sylabs.io/2018/05/sylabs-container-library-manage-secure-containers/?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">SyCloud services</a>: Remote Build Service, Container Library Service, Key Management Service.</li> </ul> <p>And more! For complete details, see <a href="https://www.sylabs.io/singularity?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">https://www.sylabs.io/singularity</a>.</p> <p>To get started running your first containers on Sherlock, please check out our documentation about how to use Singularity on Sherlock at <a href="https://www.sherlock.stanford.edu/docs/software/using/singularity/?utm_source=noticeable&amp;utm_campaign=sherlock.sherlock-goes-container-native&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.W89yPLTsDFBdz1a4jB7v&amp;utm_medium=newspage" target="_blank" rel="noopener">https://www.sherlock.stanford.edu/docs/software/using/singularity/</a></p> Kilian Cavalotti[email protected]urn:noticeable:publications:5qJRM8gfxWZZgwRcUoUZ2018-10-09T23:34:00.001Z2018-10-09T23:48:06.096ZRunning containers on SherlockHave you ever wanted to run Docker containers on Sherlock, and skip the hassle of figuring out your application dependencies, installing them, compiling the code, resolving compilation errors, finding missing libraries, or making sure...<p>Have you ever wanted to run Docker containers on Sherlock, and skip the hassle of figuring out your application dependencies, installing them, compiling the code, resolving compilation errors, finding missing libraries, or making sure your application was performing optimally?</p> <p>Well, thanks to <a href="https://www.sylabs.io/singularity/?utm_source=noticeable&amp;utm_campaign=sherlock.running-containers-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.5qJRM8gfxWZZgwRcUoUZ&amp;utm_medium=newspage" target="_blank">Singularity</a>, a container system especially designed to replace Docker on HPC systems, you can!</p> <p>Singularity has been available on Sherlock since its early versions, but we just added <a href="https://www.sherlock.stanford.edu/docs/software/using/singularity?utm_source=noticeable&amp;utm_campaign=sherlock.running-containers-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.5qJRM8gfxWZZgwRcUoUZ&amp;utm_medium=newspage" target="_blank">new documentation</a> that will show you how to use Singularity on Sherlock, and provide more examples of what you can do with containers.</p> <p>You’ll find information on how to run Docker containers with Singularity, how to download and run GPU-accelerated applications from the <a href="https://www.nvidia.com/en-us/gpu-cloud/?utm_source=noticeable&amp;utm_campaign=sherlock.running-containers-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.5qJRM8gfxWZZgwRcUoUZ&amp;utm_medium=newspage" target="_blank">NVIDIA GPU Cloud</a> registry, and more.</p> <p>Head over to <a href="https://www.sherlock.stanford.edu/docs/software/using/singularity?utm_source=noticeable&amp;utm_campaign=sherlock.running-containers-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.5qJRM8gfxWZZgwRcUoUZ&amp;utm_medium=newspage" target="_blank">https://www.sherlock.stanford.edu/docs/software/using/singularity</a> for more details, and as usual, feel free to reach out to <a href="mailto:[email protected]" target="_blank">[email protected]</a> if you have any question!</p> Kilian Cavalotti[email protected]urn:noticeable:publications:gLZOzClZm0KYooxwj18F2018-07-25T01:11:00.001Z2018-09-09T20:46:50.817ZSherlock now welcomes lab-contributed softwareHave you ever spent hours compiling and tuning software, put together a complex workflow combining multiple software parts, or just installed the latest version of the brand new software tools you're developing on Sherlock? And wondered...<p>Have you ever spent hours compiling and tuning software, put together a complex workflow combining multiple software parts, or just installed the latest version of the brand new software tools you're developing on Sherlock? And wondered how to share your results with the rest of the Sherlock community, so more people could benefit from your work?</p> <p>Sherlock now offers the possibility for labs to share their software installations and modules, and to make them available to each and every user on the cluster.</p> <p>A new <code>labs</code> section has been introduced in the <a href="https://www.sherlock.stanford.edu/docs/software/modules?utm_source=noticeable&amp;utm_campaign=sherlock.lab-contributed-software&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.gLZOzClZm0KYooxwj18F&amp;utm_medium=newspage" target="_blank" rel="noopener">software modules</a> categories (complete details are available in the <a href="https://www.sherlock.stanford.edu/docs/software/?utm_source=noticeable&amp;utm_campaign=sherlock.lab-contributed-software&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.gLZOzClZm0KYooxwj18F&amp;utm_medium=newspage#lab-provided-software" target="_blank" rel="noopener">documentation</a>).</p> <p>Kudos to the <a href="https://poldracklab.stanford.edu/?utm_source=noticeable&amp;utm_campaign=sherlock.lab-contributed-software&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.gLZOzClZm0KYooxwj18F&amp;utm_medium=newspage" target="_blank" rel="noopener">Poldrack Lab</a>, which has been pioneering this approach on Sherlock and offered to share their software modules with everyone.</p> <p>This is a great way to encourage sharing, spark innovation, and improve user experience on Sherlock. So if you're interested and would like to share your software installations too, please <a href="[email protected]" target="_blank" rel="noopener">let us know</a> and we'll be in touch!</p> Kilian Cavalotti[email protected]urn:noticeable:publications:2oqaPj4NkirTM8WDhdlu2018-07-20T21:36:00.001Z2018-09-09T20:46:50.725ZMySQL on SherlockHave you ever wondered how you could use a database server on Sherlock? Or wanted to run jobs that query data from a SQL database? Or even better, multiple jobs that would interact with the same database? Have you ever wanted to store...<p>Have you ever wondered how you could use a database server on Sherlock? Or wanted to run jobs that query data from a SQL database? Or even better, <em>multiple</em> jobs that would interact with the same database? Have you ever wanted to store datasets in a SQL format and be able to query them over long periods of time, from many different jobs?</p> <p>Well, now you can.</p> <p>Sherlock provides a installation of <a href="https://mariadb.com/?utm_source=noticeable&amp;utm_campaign=sherlock.my-sql-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.2oqaPj4NkirTM8WDhdlu&amp;utm_medium=newspage" target="_blank" rel="noopener">MariaDB</a>, a free <a href="https://mysql.com?utm_source=noticeable&amp;utm_campaign=sherlock.my-sql-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.2oqaPj4NkirTM8WDhdlu&amp;utm_medium=newspage" target="_blank" rel="noopener">MySQL</a> alternative, that you can run in the context of a job, and load with the following command:</p> <pre><code>$ ml<span class="hljs-built_in"> system </span>mariadb </code></pre> <p>You can submit a job that starts a MariaDB instance, and query it from within that job. You can also start a DB-server job, and then interact with it from other jobs, over the network.</p> <p>And if you store the database data on one of the shared, persistent <a href="https://www.sherlock.stanford.edu/docs/user-guide/storage?utm_source=noticeable&amp;utm_campaign=sherlock.my-sql-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.2oqaPj4NkirTM8WDhdlu&amp;utm_medium=newspage" target="_blank" rel="noopener">Sherlock filesystems</a>, you'll find your database data back the next time you submit a DB-server job and start a MariaDB instance, without having to re-import anything.</p> <p>For more information about Sherlock's self-service database-in-a-box option , see the documentation at:<br> <a href="https://www.sherlock.stanford.edu/docs/software/using/mariadb/?utm_source=noticeable&amp;utm_campaign=sherlock.my-sql-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.2oqaPj4NkirTM8WDhdlu&amp;utm_medium=newspage" target="_blank" rel="noopener">https://www.sherlock.stanford.edu/docs/software/using/mariadb/</a></p> Kilian Cavalotti[email protected]urn:noticeable:publications:yc4plScl58EzUUhXBb8P2018-05-16T20:43:00.001Z2018-09-09T20:46:50.942ZSpark on SherlockApache Spark is now available on Sherlock, via the spark module: $ ml spark We also added some new documentation and example job scripts, so if you ever needed to run Spark jobs on Sherlock, please take a look at those and let us know...<p><a href="http://spark.apache.org?utm_source=noticeable&amp;utm_campaign=sherlock.spark-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.yc4plScl58EzUUhXBb8P&amp;utm_medium=newspage" target="_blank" rel="noopener">Apache Spark </a> is now available on Sherlock, via the <code>spark</code> module:</p> <pre><code><span class="hljs-meta">$</span><span class="bash"> ml spark</span> </code></pre> <p>We also added some <a href="https://www.sherlock.stanford.edu/docs/software/using/spark/?utm_source=noticeable&amp;utm_campaign=sherlock.spark-on-sherlock&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.yc4plScl58EzUUhXBb8P&amp;utm_medium=newspage" target="_blank" rel="noopener">new documentation and example job scripts</a>, so if you ever needed to run Spark jobs on Sherlock, please take a look at those and <a href="[email protected]" target="_blank" rel="noopener">let us know</a> how it works for you.</p> Kilian Cavalotti[email protected]urn:noticeable:publications:ZCrwycWsE9ZP4EYKUyRP2018-03-30T18:15:00.001Z2018-09-09T20:46:50.802ZTensorflow 1.7.0 now availableTensorflow 1.7.0, which features TensorRT integration, is now available on Sherlock 2.0. You can load it on Sherlock with: $ ml py-tensorflow/1.7.0_py27 > NB: As with all the other Tensorflow modules on Sherlock, Tensorflow 1.7.0...<p>Tensorflow 1.7.0, which features <a href="https://devblogs.nvidia.com/tensorrt-integration-speeds-tensorflow-inference?utm_source=noticeable&amp;utm_campaign=sherlock.tensorflow-1-7-0-now-available&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.ZCrwycWsE9ZP4EYKUyRP&amp;utm_medium=newspage" target="_blank" rel="noopener">TensorRT integration</a>, is now available on Sherlock 2.0.</p> <p>You can load it on Sherlock with:</p> <pre><code>$ ml py-tensorflow/1.7.0_py27 </code></pre> <blockquote> <p><strong>NB</strong>: As with all the other Tensorflow modules on Sherlock, Tensorflow 1.7.0 requires a GPU to run and can only be used in <a href="https://www.sherlock.stanford.edu/docs/user-guide/gpu/?utm_source=noticeable&amp;utm_campaign=sherlock.tensorflow-1-7-0-now-available&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.ZCrwycWsE9ZP4EYKUyRP&amp;utm_medium=newspage" target="_blank" rel="noopener">jobs submitted to GPU nodes</a>.</p> </blockquote> <p>For a complete changelog, please see the <a href="https://github.com/tensorflow/tensorflow/releases/tag/v1.7.0?utm_source=noticeable&amp;utm_campaign=sherlock.tensorflow-1-7-0-now-available&amp;utm_content=publication+link&amp;utm_id=bYyIewUV308AvkMztxix.GtmOI32wuOUPBTrHaeki.ZCrwycWsE9ZP4EYKUyRP&amp;utm_medium=newspage" target="_blank" rel="noopener">TensorFlow release notes</a>.</p> Sherlock Team[email protected]