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.