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)
• Status: Verified
• Category: MySQL Server: mysqlpump Command-line Client
• Severity: S4 (Feature request)
• Version: 8.0.21
• OS: Any
• CPU Architecture: Any

[29 Sep 2020 20:33] Sveta Smirnova

Description:
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.

regards,
Umesh

[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.