> 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/ha-and-performance.md).

# HA & Performance

{% columns %}
{% column %}
{% content-ref url="/pages/nUy7JMZiFO3YRkkAurjd" %}
[Optimization and Tuning](/docs/server/ha-and-performance/optimization-and-tuning.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Optimize and tune MariaDB Server. This section covers buffers and caches, indexing, the query optimizer and hints, compression, and the system variables that control performance.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/w5g1cjSgKvkYOlIX0zC7" %}
[Replication](/docs/server/ha-and-performance/standard-replication.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Replicate data with MariaDB Server. This section covers primary and replica setup, binary log formats, global transaction IDs, and multi-source, parallel, and semisynchronous replication.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/r94nAVIdyR4HQ0I11Kh5" %}
[Benchmarking](/docs/server/ha-and-performance/benchmarking.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Benchmark MariaDB Server performance using published benchmark results and SystemTap scripts for measuring throughput and behavior under load.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/5LFxhICS2lTNtBY3wmoN" %}
[MariaDB Memory Allocation](/docs/server/ha-and-performance/mariadb-memory-allocation.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Plan MariaDB memory usage by sizing global caches, per-connection buffers, and engine-specific settings to avoid swapping and out-of-memory conditions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ToYFg7eOAwFvh1CBe02r" %}
[Hardware Optimization](/docs/server/ha-and-performance/hardware-optimization.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Optimize MariaDB Server performance through hardware. This section covers selecting appropriate CPU, memory, and storage configurations to maximize your database's speed and throughput.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/xfcfQaJerHUhse5qi7qD" %}
[Connection Redirection Mechanism in the MariaDB Client/Server Protocol](/docs/server/ha-and-performance/connection-redirection-mechanism-in-the-mariadb-clientserver-protocol.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore connection redirection. This section details how the client/server protocol handles redirection for high availability and load balancing, ensuring seamless database access and failover.
{% endcolumn %}
{% endcolumns %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://mariadb.com/docs/server/ha-and-performance.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.