[MDEV-8355] Extend RESET MASTER to allow specifying next binary log. Created: 2015-06-22  Updated: 2015-07-17  Resolved: 2015-07-17

Status: Closed
Project: MariaDB Server
Component/s: Replication
Fix Version/s: 10.1.6

Type: Task Priority: Major
Reporter: Jean-François Gagné Assignee: Unassigned
Resolution: Duplicate Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-8469 Add RESET MASTER TO x to allow specif... Closed

 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



 Comments   
Comment by Sergei Golubchik [ 2015-07-17 ]

Apparently, it was just implemented as MDEV-8469

Generated at Thu Feb 08 07:26:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.