Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1177035: pt-slave-find doesn't indicate master-master

Description

**Reported in Launchpad by Jay Janssen last update 02-08-2013 18:16:05

For example:

  1. pt-slave-find localhost
    localhost
    Version 5.5.30-30.2-log
    Server ID 1242
    Uptime 9+18:46:30 (started 2013-04-27T02:36:24)
    Replication Is a slave, has 7 slaves connected, is not read_only
    Filters replicate_ignore_table=shbdn.sessions; replicate_ignore_db=pma
    Binary logging MIXED
    Slave status 0 seconds behind, running, no errors
    Slave mode STRICT
    Auto-increment increment 2, offset 2
    InnoDB version 5.5.30-rel30.2
    ....
    +- 192.168.1.75
    Version 5.5.30-30.2-log
    Server ID 175
    Uptime 9+18:46:35 (started 2013-04-27T02:36:19)
    Replication Is a slave, has 1 slaves connected, is read_only
    Filters replicate_ignore_table=shbdn.sessions; replicate_ignore_db=pma
    Binary logging MIXED
    Slave status 0 seconds behind, running, no errors
    Slave mode STRICT
    Auto-increment increment 2, offset 1
    InnoDB version 5.5.30-rel30.2

.75 is actually a dual-master of localhost, but nothing shows that.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 7:30 PM

**Comment from Launchpad by: Jay Janssen on: 20-06-2013 17:00:21

On Jun 20, 2013, at 12:45 PM, Daniel Nichter <daniel@percona.com> wrote:

> What do you mean by "dual master"? .75 has 2 slaves but neither are
> shown?

dual master = two masters in circular replication.

I truncated the output, but it would be nice if it was clear that .75 was also a master to localhost.

Jay Janssen, MySQL Consulting Lead, Percona
http://about.me/jay.janssen

lpjirasync January 24, 2018 at 7:30 PM

**Comment from Launchpad by: Daniel Nichter on: 20-06-2013 16:45:54

What do you mean by "dual master"? .75 has 2 slaves but neither are shown?

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

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