Skip to main content

SingleStoreDB v8.1

User and Cluster Administration

The topics in this section provide the following information:

  • How to set up SingleStore's native monitoring solution to maintain cluster health, connect Studio and external visualization tools to the cluster's monitoring data, and troubleshoot the monitoring setup.

  • The comprehensive metrics exposed by SingleStoreDB that help determine the cluster's health and performance, predict resource constraints, and diagnose issues.

  • Replication and Durability concepts, configuration, usage, and troubleshooting.

  • High Availability architecture, setup, management, and usage with examples. Database replay configuration using logs and snapshots.

  • Cluster administration tasks, such as setting redundancy levels, determining license capacity and usage, updating license, controlling memory usage, changing the host IP address in a cluster, taking leaves offline without cluster downtime, and more.

  • Cluster scaling, including cluster expansion and downsizing steps.

  • Online and offline upgrade of SingleStoreDB and uninstall processes.

  • Data migration from MySQL and application transition to SingleStoreDB.

  • Troubleshooting of system, node, and query performance issues.

  • Setup dedicated admin connections.

  • Effective workload management using built-in workload manager and by setting resource limits.

  • Overview of SingleStore Tools including Toolbox, Studio, and client. Tools installation processes and migration from MemSQL Ops to SingleStore Tools.

In this section: