SingleStore DB

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 SingleStore Studio and external visualization tools to the cluster's monitoring data, and troubleshoot the monitoring setup.

  • The comprehensive metrics exposed by SingleStore 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 SingleStore and uninstallation processes.

  • Data migration from MySQL and application transition to SingleStore.

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

  • 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.