> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-wsrep_status.md).

# SHOW WSREP\_STATUS

`SHOW WSREP_STATUS` is part of the [WSREP\_INFO](/docs/server/reference/plugins/mariadb-replication-cluster-plugins/wsrep_info-plugin.md) plugin.

## Syntax

```bnf
SHOW WSREP_STATUS
```

## Description

The `SHOW WSREP_STATUS` statement returns [Galera](https://mariadb.com/docs/galera-cluster/) node and cluster status information. It returns the same information as found in the [information\_schema.WSREP\_STATUS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-wsrep_status-table.md) table. Only users with the [SUPER](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#super) privilege can access this information.

## Examples

```sql
SHOW WSREP_STATUS;
+------------+-------------+----------------+--------------+
| Node_Index | Node_Status | Cluster_Status | Cluster_Size |
+------------+-------------+----------------+--------------+
|          0 | Synced      | Primary        |            3 |
+------------+-------------+----------------+--------------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}