Bug #89692 --master-data needs an option for a channel name
Submitted: 16 Feb 2018 9:59 Modified: 13 Oct 2020 20:11
Reporter: Timo Maier Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:5.7. OS:Any
Assigned to: CPU Architecture:Any

[16 Feb 2018 9:59] Timo Maier 
Description:
With multi master replication, one slave manages multiple masters. To start or to fix a broken replication, I use mysqldump with --master-data to include MASTER_LOG_FILE and MASTER_LOG_POS in the dump, so it can be easily applied to the slave.

Since I switch all mysql servers to 5.7, I also use multi master replication, but now I need to specifiy the channel name for the CHANGE MASTER TO statemant which is generated by mysqldump --master-data 

How to repeat:
mysqldump --routines --triggers --master-data --single-transaction --add-drop-database --databases mydb > mydb.dump

Suggested fix:
Add a parameter for the channel name
[6 Oct 2020 12:58] MySQL Verification Team 
Hi Mr. Maier,

Thank you for your feature request.

However, if you inspect our latest 5.7 and 8.0 releases, you will find out that this is already implemented.

Not a bug.
[13 Oct 2020 20:11] Timo Maier 
Hi,

sorry, how? I can't find it.