Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
Description
Hi,
I would like the "RESET MASTER" command to be extended to the following:
RESET MASTER [AT file_number]
where file_number would be the binary log index of the next binary log to create (instead of being <log_bin_basename>.000001, the next binary log file would be <log_bin_basename>.<file_number>).
This would allow to perform easy master promotion as discussed at slide # 31 of the below URL without "FLUSH BINARY LOGS" in a loop:
-http://www.slideshare.net/JeanFranoisGagn/binlog-servers-at-bookingcom
So if I have "log-bin = binlog" in my.cnf, a "RESET MASTER AT 1234" would generate "binlog.001234" as the next binary log file.
Many thanks,
JFG
Attachments
Issue Links
- relates to
-
MDEV-8469 Add RESET MASTER TO x to allow specification of binlog file nr
- Closed