LP #1243910: pt-heartbeat on PXC with same server-id

Description

**Reported in Launchpad by Mrten last update 30-10-2013 19:51:07

It has been recommended ( https://groups.google.com/forum/#!topic/codership-team/1fyLt83jmBc , other places ) that the server-id in a PXC cluster is the same for all members if the cluster is a replication master.

However, this means you cannot run pt-heartbeat on all members of the cluster (which would be nice for redundancy, ease of config and checking of replication lag). (I tried, and it creates transaction errors).

I noticed a 'server-id'-column in the heartbeat table, shouldn't there also be a kind of 'PXC-node-id' column? Perhaps the wsrep_node_name in there?

Environment

None

Smart Checklist

Activity

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 24, 2018 at 7:51 PM
Updated December 21, 2019 at 2:32 PM

Flag notifications