Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21967

Bind REPLICATION {MASTER|SLAVE} ADMIN to rpl_semi_sync_* variables

Details

    Description

      SET for the following semisyncrhonous replication related system GLOBAL-only variables:

      • rpl_semi_sync_master_enabled
      • rpl_semi_sync_master_timeout
      • rpl_semi_sync_master_wait_no_slave
      • rpl_semi_sync_master_trace_level
      • rpl_semi_sync_master_wait_point
      • rpl_semi_sync_slave_enabled
      • rpl_semi_sync_slave_trace_level
      • rpl_semi_sync_slave_delay_master
      • rpl_semi_sync_slave_kill_conn_timeout

      is allowed only for users with the SUPER privilege as of 10.5.1.

      Let's allow SET for the rpl_semi_sync_master_* global variables also for users with the REPLICATION MASTER ADMIN privilege.
      Let's allow SET for the rpl_semi_sync_slave_* global variables also for users with the REPLICATION SLAVE ADMIN privilege.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-21743 Split up SUPER privilege to smaller privileges

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-22026 Document 10.5 privilege changes

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            Description SET for the following semisyncrhonous replication related system GLOBAL-only variables:

            - rpl_semi_sync_master_enabled
            - rpl_semi_sync_master_timeout
            - rpl_semi_sync_master_wait_no_slave
            - rpl_semi_sync_master_trace_level
            - rpl_semi_sync_master_wait_point
            - rpl_semi_sync_slave_enabled
            - rpl_semi_sync_slave_trace_level
            - rpl_semi_sync_slave_delay_master
            - rpl_semi_sync_slave_kill_conn_timeout

            is allowed only for users with the SUPER privilege as of 10.5.1.

            Let's allow SET for the rpl_semi_sunc_master_* global variables also for users with the {{REPLICATION MASTER ADMIN}} privilege.
            Let's allow SET for the rpl_semi_sunc_master_* global variables also for users with the {{REPLICATION SLAVE ADMIN}} privilege.
            		SET for the following semisyncrhonous replication related system GLOBAL-only variables:

            - rpl_semi_sync_master_enabled
            - rpl_semi_sync_master_timeout
            - rpl_semi_sync_master_wait_no_slave
            - rpl_semi_sync_master_trace_level
            - rpl_semi_sync_master_wait_point
            - rpl_semi_sync_slave_enabled
            - rpl_semi_sync_slave_trace_level
            - rpl_semi_sync_slave_delay_master
            - rpl_semi_sync_slave_kill_conn_timeout

            is allowed only for users with the SUPER privilege as of 10.5.1.

            Let's allow SET for the rpl_semi_sync_master_* global variables also for users with the {{REPLICATION MASTER ADMIN}} privilege.
            Let's allow SET for the rpl_semi_sync_slave_* global variables also for users with the {{REPLICATION SLAVE ADMIN}} privilege.
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2020-03-18 06:41:18.0 2020-03-18 06:41:18.295
            bar Alexander Barkov made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 104983 ] MariaDB v4 [ 134212 ]

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.