Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-713

Grant information is not described adequately for binlog router

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.4.3
    • 1.4.3
    • binlogrouter
    • None
    • 2017-29, 2017-30, 2017-31, 2017-32

    Description

      The information about grants is not as clear as it could be here: https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/setting-up-maxscale/

      If the binlog router is being used then it's likely that the binlog router is on a different server to the backend "master". It's also possible that you have a cluster of binlog routers to provide HA functionality so there won't be a single server. It may be worth mentioning this and how this setup might work.

      Also show "just the grants" as it's easier to read then each statement, so something like:

      – Grants for auth user (to get grants)
      CREATE USER 'auth_user'@'somewhere' IDENTIFIED BY 'xxxxxx';
      GRANT SHOW DATABASES ON . TO 'auth_user'@'somewhere';
      GRANT SELECT ON `mysql`.`db` TO 'auth_user'@'somewhere';
      GRANT SELECT ON `mysql`.`tables_priv` TO 'auth_user'@'somewhere';
      GRANT SELECT ON `mysql`.`user` TO 'auth_user'@'somewhere';

      – Replication slave access (for maxscale to download binlogs)
      CREATE USER 'slave_user'@'somewhere' IDENTIFIED BY 'xxxxx';
      GRANT REPLICATION SLAVE ON . TO 'slave_user'@'somewhere';

      This format is easier to put into a template for generating automatically.

      Note: 'somewhere' is unlikely to be a single hostname or ip address but maybe using a wild-card entry like '192.168.5.%' as if you use specific hostnames/ips you'll need to add an entry for each host and that may be cumbersome.

      Attachments

        Activity

          People

            Massimiliano Pinto Massimiliano Pinto (Inactive)
            sjmudd Simon Mudd
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.