Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
Description
In MDEV-6039, serg says that super read-only looks fb specific. It isn't.
Feature does: Super read-only works when regular read-only itself is not enough, so this feature prevents writes by SUPER users too.
It is implemented in Percona Server 5.6 (https://www.percona.com/doc/percona-server/5.6/management/super_read_only.html) and also in MySQL 5.7 (https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html). Documented: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_super_read_only and WL#6799 - https://dev.mysql.com/worklog/task/?id=6799
Mailing list post about it where serg talks about this: https://lists.launchpad.net/maria-developers/msg08911.html
Attachments
Issue Links
- relates to
-
MDEV-36425 Extend read_only to also block share locks and super users
-
- In Testing
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
In Feature does: Super read-only works when regular read-only itself is not enough, so this feature prevents writes by SUPER users too. It is implemented in Percona Server 5.6 (https://www.percona.com/doc/percona-server/5.6/management/super_read_only.html) and also in MySQL 5.7 (https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html). Documented: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_super_read_only and WL#6799 - https://dev.mysql.com/worklog/task/?id=6799 |
In Feature does: Super read-only works when regular read-only itself is not enough, so this feature prevents writes by SUPER users too. It is implemented in Percona Server 5.6 (https://www.percona.com/doc/percona-server/5.6/management/super_read_only.html) and also in MySQL 5.7 (https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html). Documented: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_super_read_only and WL#6799 - https://dev.mysql.com/worklog/task/?id=6799 Mailing list post about it where serg talks about this: https://lists.launchpad.net/maria-developers/msg08911.html |
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
| Assignee | Vicentiu Ciorbaru [ cvicentiu ] |
| Support case ID | 27193 |
| Link | This issue relates to RP-12 [ RP-12 ] |
| Workflow | MariaDB v3 [ 73738 ] | MariaDB v4 [ 130429 ] |
| Link | This issue relates to RP-12 [ RP-12 ] |
| Description |
In Feature does: Super read-only works when regular read-only itself is not enough, so this feature prevents writes by SUPER users too. It is implemented in Percona Server 5.6 (https://www.percona.com/doc/percona-server/5.6/management/super_read_only.html) and also in MySQL 5.7 (https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html). Documented: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_super_read_only and WL#6799 - https://dev.mysql.com/worklog/task/?id=6799 Mailing list post about it where serg talks about this: https://lists.launchpad.net/maria-developers/msg08911.html |
In Feature does: Super read-only works when regular read-only itself is not enough, so this feature prevents writes by SUPER users too. It is implemented in Percona Server 5.6 (https://www.percona.com/doc/percona-server/5.6/management/super_read_only.html) and also in MySQL 5.7 (https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-8.html). Documented: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_super_read\_only and WL#6799 \- https://dev.mysql.com/worklog/task/?id=6799 Mailing list post about it where serg talks about this: https://lists.launchpad.net/maria\-developers/msg08911.html |
| Assignee | Vicențiu Ciorbaru [ cvicentiu ] | Michael Widenius [ monty ] |
| Link |
This issue relates to |
| Status | Open [ 1 ] | Needs Feedback [ 10501 ] |
| Status | Needs Feedback [ 10501 ] | Open [ 1 ] |
| Component/s | Server [ 13907 ] | |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Won't Fix [ 2 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Zendesk Related Tickets | 136500 184720 164632 148264 |
| Link | This issue relates to MDEV-36425 [ MDEV-36425 ] |