# Maintaining Connection State on Replica Servers with MaxScale's Read/Write Split Router

The [Read/Write Split Router (readwritesplit)](/docs/maxscale/reference/maxscale-routers/maxscale-readwritesplit.md) load balances read-only queries between one or more replica servers. If a replica server fails, then the router may need to create new connections to a different replica server for any existing client connections. The router takes certain steps to ensure that those new replica server connections have the same state as the old replica server connections.

## Session Command History

The [Read/Write Split Router (readwritesplit)](/docs/maxscale/reference/maxscale-routers/maxscale-readwritesplit.md) maintains connection state on replica servers by keeping a session command history. If the router has to create a new connection, then it replays these session commands from the previous connection on the new connection.

## Minimizing Memory Usage of Session Command History

The session command history can require a lot of memory if connections are long-lived. In these cases, there are two options to limit memory usage:

* Configure a maximum size for the session command history
* Disable the session command history. This option is not recommended, because you would lose out on the benefits of the session command history.

### Configuring a Maximum Size of the Session Command History

1. Set the maximum size of the session command history by configuring some parameters for the Read/Write Split Router in `maxscale.cnf`.

| Parameter              | Description                                                                                                                                                                                                                                                                                                                                                                         |
| ---------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| max\_sescmd\_history   | • The maximum number of distinct session commands that will be stored for each connection. • The default value is 50.                                                                                                                                                                                                                                                               |
| prune\_sescmd\_history | • When this parameter is enabled, the session command history for a connection is pruned when the number of distinct session commands reaches max\_sescmd\_history. • When this parameter is disabled, the session command history for a connection is disabled when the number of distinct session commands reaches max\_sescmd\_history. • This parameter is disabled by default. |

For example:

```
[split-router]
type                     = service
router                   = readwritesplit
...
max_sescmd_history       = 1500
prune_sescmd_history     = true
```

2. Restart the MaxScale instance.

```
$ sudo systemctl restart maxscale
```

## Disabling the Session Command History

1. Disable the session command history by configuring the `disable_sescmd_history` parameter for the Read/Write Split Router in `maxscale.cnf`.

For example:

```
[split-router]
type                     = service
router                   = readwritesplit
...
disable_sescmd_history   = true
```

2. Restart the MaxScale instance.

```
$ sudo systemctl restart maxscale
```

<sub>*This page is: Copyright © 2025 MariaDB. All rights reserved.*</sub>

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/maxscale/maxscale-use-cases/readwrite-split-router-usage/maintaining-connection-state-on-replica-servers-with-maxscales-readwrite-sp.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.