Bug #116136 Feature request for adding log when read_only has been changed

• Submitted: 18 Sep 2024 4:20
• Modified: 18 Sep 2024 4:29
• Reporter: Tsubasa Tanaka (OCA)
• Status: Verified
• Category: MySQL Server: Logging
• Severity: S4 (Feature request)
• Version: 8.4.2, 9.0.1
• OS: Any
• CPU Architecture: Any

[18 Sep 2024 4:20] Tsubasa Tanaka

Description:
This is feature request.

Adding information message into error-log when read_only and super_read_only has been changed.

This feature makes easier to custom own Failover script.

How to repeat:
This is feature request.

Suggested fix:
Add "LogErr(INFORMATION_LEVEL, ..)" into fix_read_only function.

https://github.com/mysql/mysql-server/blob/mysql-8.4.2/sql/sys_vars.cc#L3523-L3612

[18 Sep 2024 4:29] MySQL Verification Team

Hello tanaka-San,

Thank you for the feature request!

regards,
Umesh