[MDEV-4551] mysqldump --dump-slave fails with multi-source replication - Jira

mysqldump --dump-slave fails with multi-source replication because it tries to run stop/start slave statement.

[mysql@centos ~ ] $ mysqldump --dump-slave --all-databases > /dev/null

mysqldump: Couldn't execute 'START SLAVE': The server is not configured as slave; fix in config file or with CHANGE MASTER TO (1200)

[mysql@centos ~ ] $

I have replication setup from 4 masters but mysqldump thinks mysqld isn't a slave probably because SHOW SLAVE STATUS returns no row:

[mysql@centos ~ ] $ mysql -e 'show slave status' | wc -l

[mysql@centos ~ ] $ mysql -e 'show all slaves status' | wc -l

[mysql@centos ~ ] $

includes

MDEV-4827 [PATCH] mysqldump --dump-slave=2 --master-data=2 doesn't record both

Transition	Time In Source Status	Execution Times

Michael Widenius made transition - 2014-02-11 17:57

Open

In Progress

267d 7h 1m

Michael Widenius made transition - 2014-02-11 19:42

In Progress

Stalled

1h 45m

Sergei Golubchik made transition - 2014-03-07 15:49

Stalled

Closed

23d 20h 6m

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server