Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

Modernizing Your Existing Applications

Welcome to SingleStore Managed Service! We put together a guide to help you migrate your analytical application to SingleStore. Use this guide to follow a top-down approach to:

  • Extracting your data from your existing database
  • Interacting with SingleStore
  • Designing your SingleStore tables to be optimized for your applications
  • Importing data from your originating database
  • Optimizing your queries for your applications
  • Connecting your application to SingleStore

Tutorial Outline

This tutorial is divided into the following sections:

Getting Started

  • Benefits of leveraging S2MS for your application
  • What to consider when bringing your application data from:
    • MySQL, MariaDB, Postgres
    • AWS, GCP, Azure
  • What to consider when designing your database coming from:
    • MySQL, MariaDB, Postgres
    • AWS, GCP, Azure

Preparing Your Data for SingleStore

Database Administration

  • SingleStore Portal
  • Drivers
  • MySQL Workbench
  • MySQL Command Line

Designing Your Tables

  • Data types
  • Designing a schema for an application
    • Sharding for application workloads
    • Sort keys for application workloads
    • Reference Tables

Ingesting Data

  • Using SingleStore Pipelines
  • Using INSERT Statements

Testing Your Queries

  • Run queries
  • Visual Explain
  • Concurrency test your queries

Connecting to Your Application Development Tools

  • Code samples to connect to SingleStore