SingleStore Managed Service

information_schema.MV_DISTRIBUTED_DATABASES_STATUS

This view contains information about the status of databases.

Column Name

Description

DATABASE_NAME

The name of a given related database.

NUM_PARTITIONS

The number of partitions in a given database.

SUMMARY

Exposes status of the database: healthy/degraded/offline.

ONLINE

Whether a given database is online.

REPLICATING

Whether a given database is replicating.

RECOVERING

Whether a given database is recovering.

PENDING

Whether a given database is pending.

TRANSITION

Whether a given database is in transition.

UNRECOVERABLE

Whether a given database is unrecoverable.

OFFLINE

Whether a given database is offline.

SYNC_MISMATCH

True if some partition instances are replicating in a mode different from the replication mode of the database.