Skip to content

Latest commit

 

History

History
33 lines (17 loc) · 3 KB

SingleStore.md

File metadata and controls

33 lines (17 loc) · 3 KB
Raw

SAS Viya Support for SingleStore

SAS Viya provides an optional integration with SingleStoreDB. SingleStoreDB is a cloud-native database that is designed for data-intensive applications. A distributed, relational SQL database management system that features ANSI SQL support, SingleStoreDB is known for speed in data ingest, transaction processing, and query processing.

Requirements for SAS Viya with SingleStore

If your SAS software order included SAS Viya with SingleStore, additional requirements apply to your deployment. The SAS Viya IT Operations Guide provides detailed information about requirements for a SingleStore-enabled deployment of SAS Viya. You can access the guide here.

Deploying SAS Viya with SingleStore Using SAS Viya 4 Deployment

You can deploy SAS Viya with SingleStore into a Kubernetes cluster that is running in Microsoft Azure. The SAS Viya 4 Infrastructure as Code (IaC) for Microsoft Azure GitHub project can automatically provision the required infrastructure components that support SAS Viya with SingleStore deployments.

Refer to the SingleStore sample input file for Terraform configuration values that create an Azure cluster suitable for deploying SAS Viya and SingleStore.

Customizing SingleStore Deployment Overlays

Refer to the viya4-deployment Getting Started and SAS Viya Customizations documentation if you need information about how to make changes to your deployment by adding custom overlays into subdirectories under the /site-config directory.

After running viya4-deployment with the setting DEPLOY=false in your ansible-vars.yaml file, locate the sas-bases/ directory, which is a peer to the site-config/ directory underneath your SAS deployment's <base_dir>.

Complete each step under the SingleStore Cluster Definition heading in the sas-bases/examples/sas-singlestore/README.md file in order to configure your SAS Viya with SingleStore deployment, noting the following exceptions:

  • Add a new Step 1a after Step 1:

1a. Copy $deploy/sas-bases/components/sas-singlestore into the $deploy/site-config/sas-singlestore/components directory.

  • Skip Step 3.
  • Complete the remaining steps from the README.md for SingleStore, and set DEPLOY=true in your ansible-vars.yaml file.

Then run viya4-deployment with the "viya, install" tags to deploy SAS Viya with SingleStore into your cluster.

The viya4-deployment playbook will automatically add the SingleStore component and the overlays to the base kustomization.yaml file that you have copied to the /site-config directory and edited as described in the README.md file.