Bug #101002 mysqlpump cannot be used to setup position-based replica
Submitted: 29 Sep 2020 20:33 Modified: 30 Sep 2020 6:32
Reporter: Sveta Smirnova (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqlpump Command-line Client Severity:S4 (Feature request)
Version:8.0.21 OS:Any
Assigned to: CPU Architecture:Any

[29 Sep 2020 20:33] Sveta Smirnova
mysqlpump does not have an option to record binary log coordinates. Therefore it cannot be used to create dumps, safe for setting up position-based replicas.

How to repeat:
Run mysqlpump, try to find current binary log file name and position

Suggested fix:
Add option, similar to --master-data for mysqldump
[30 Sep 2020 6:32] MySQL Verification Team
Hello Sveta,

Thank you for the reasonable feature request to support *Replication specific Options* in mysqlpump utility.

[17 Jan 10:30] Peter Duffy
Is there any progress on this? Not being able to use mysqlpump to create a dump suitable for setting up a replica is a real pain.