# How to add Topology in PMM for MySQL servers

**URL:** <https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424>\
**Category:** MySQL & MariaDB\
**Tags:** community, pmm, mysql, new-release\
**Created:** [July 6, 2023, 5:50pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424 "2023-07-06T17:50:24Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [July 6, 2023, 5:50pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/1 "2023-07-06T17:50:24Z")

</div>

Hi All,

Do anyone know if we can add topology in PMM for MySQL/MariaDB servers, if so can you let me know how it can be done.

Example: If we have Primary-Secondary setup, then I need to see a Pictorial form which server is acting as Primary, which server is acting as Secondary, If Read\_Only is enabled or not etc. Somethign similar to what we see in MySQL Enterprise Monitor.

Thanks in Advance.

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [July 6, 2023, 7:03pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/2 "2023-07-06T19:03:40Z")

</div>

Hello, @tee952.  
Are you searching for an alternative to [Grafana](https://per.co.na/08gnWd) that focuses on replication rather than group replication?

We have a Replication dashboard available at [Grafana](https://per.co.na/iuO5qS), but it, unfortunately, doesn’t allow viewing of both Primary and Secondary at the same time. In my opinion, the design used in Group Replication is better in this regard.

To get PMM to understand your topology better - for now, you need to specify the `cluster` label when adding services:

```auto
pmm-admin add mysql ... --cluster=Cluster1 DB1

pmm-admin add mysql ... --cluster=Cluster1 DB2

```

(Doc: [pmm-admin - PMM Administration Tool - Percona Monitoring and Management](https://per.co.na/UhfZqQ))

PMM will recognize that DB1 and DB2 are part of the same cluster in this scenario.

---

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [July 6, 2023, 7:41pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/3 "2023-07-06T19:41:22Z")

</div>

Hello @Roma_Novikov

I am looking to add topology irrespective of what type of replication setup is done. This will give a high level glance to monitor multiple type of clusters.

When selected a specific cluster, I need to see something like below for that cluster.

credits: [https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-topology.html](https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-topology.html)  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/e/ecb48ff8ed14519b47f0f2947835b2f00b62e4f2.png)

---

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [July 6, 2023, 7:46pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/4 "2023-07-06T19:46:31Z")

</div>

credits: [https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication-overview-ui-ref.html](https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication-overview-ui-ref.html)

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/cb8ccfae4f26e285fabdedd3e1ecdd87da4438e1.png)

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 6, 2023, 8:17pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/5 "2023-07-06T20:17:03Z")

</div>

Hello @tee952,  
You want this: [GitHub - openark/orchestrator: MySQL replication topology management and HA](https://github.com/openark/orchestrator)  
Orchestrator is a GUI tool/visualizer for MySQL replication topology.

---

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [July 6, 2023, 8:20pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/6 "2023-07-06T20:20:40Z")

</div>

Hello @matthewb

I don’t want another tool/utility to manage the setup we already have in place, instead only monitor our servers/clusters from PMM.

Can you confirm if this can be done using the orchestrator mentioned above by incorporating within PMM.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 6, 2023, 8:29pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/7 "2023-07-06T20:29:21Z")

</div>

Orchestrator is separate software from PMM. Orchestrator is “read only” by default and will not take any actions unless configured to do so. If you only want a visualization tool of your topology, you can use Orc for this. You don’t have to use any of the management features. You can easily run Orc on the same server as your PMM server, on a different port.

---

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [July 6, 2023, 8:33pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/8 "2023-07-06T20:33:27Z")

</div>

Got it, can you share any steps or documentation related to this.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 6, 2023, 8:46pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/9 "2023-07-06T20:46:13Z")

</div>

You can check the Github link I shared. Orc’s documentation is pretty spot on for install/setup. Configure Orc’s web UI to be on some other port like 8181 and run it on same server as PMM. There might be a docker container for Orc already, you’d have to look.

---

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [August 17, 2023, 9:00pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/10 "2023-08-17T21:00:37Z")

</div>

Hi @matthewb

I keep running into below error on Orchestrator server while running discover command, can you let me know if there is something I am missing.

ERROR: this authentication plugin is not supported

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 17, 2023, 9:05pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/11 "2023-08-17T21:05:57Z")

</div>

I’m not sure where you are seeing that. That could be from MySQL in that you are trying to use the new MySQL 8 sha2 authentication and your server doesn’t support it yet. Do you have logs/screenshot?

---

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [August 17, 2023, 9:37pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/12 "2023-08-17T21:37:52Z")

</div>

I am using MariaDB 10.5.21 version

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 17, 2023, 9:51pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/13 "2023-08-17T21:51:36Z")

</div>

Even more so trying to use the wrong authentication plugin. That’s a pretty old version of MariaDB plus MariaDB doesn’t follow upstream MySQL.

---

<div class="post-metadata">

**Author:** ![tee952](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tee952/32/20226_2.png) [@tee952](https://forums.percona.com/u/tee952)\
**Post date:** [October 16, 2025, 3:44pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/14 "2025-10-16T15:44:49Z")

</div>

Hello Team,

Is there any plan to add above topology setup in the PMM anytime soon? If so can you let us the timeframe.

Thanks

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [October 16, 2025, 9:27pm UTC](https://forums.percona.com/t/how-to-add-topology-in-pmm-for-mysql-servers/23424/15 "2025-10-16T21:27:17Z")

</div>

Hello @tee952,  
There are no plans to add Orchestrator functionality to PMM. Orchestrator does a fantastic job of managing MySQL replication topology, from single S/R to many 100’s of S/R/R/R setups. It would be a big waste of our resources to duplicate that functionality within PMM.
