MySQL Bugs: #99988: Turn mysql-bin.index file into a InnoDB table

Bug #99988	Turn mysql-bin.index file into a InnoDB table
Submitted:	25 Jun 2020 19:18	Modified:	10 Jul 2020 12:16
Reporter:	Vinicius Malvestio Grippa	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Logging	Severity:	S4 (Feature request)
Version:	Any	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Nowadays, MySQL server stores the binary logs in the file mysql-bin.index:

$ cat master/data/mysql-bin.index
./mysql-bin.000001
./mysql-bin.000002
./mysql-bin.000003
./mysql-bin.000004
./mysql-bin.000005

In a crash situation, it may lead to an inconsistent state since this is not encapsulated in a transaction.

How to repeat:
The current situation is only on a file:

$ cat master/data/mysql-bin.index
./mysql-bin.000001
./mysql-bin.000002
./mysql-bin.000003
./mysql-bin.000004
./mysql-bin.000005

Suggested fix:
Create a parameter similar to:

master-info-repository=table
relay-log-info-repository=table

So it would be a proposed parameter like:

mysql-bin-repository = FILE/TABLE

Hi Mr. Grippa,

Thank you for your feature request.

I think that this is a reasonable feature request. Some changes to it are, very necessary. First of all, it should be done in some of the new versions and it should be option-less, otherwise it would be a mess.

Verified as a feature request.