Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31542 Add multi-tenancy catalogs to MariaDB
  3. MDEV-31706

Add support for catalogs to Federatedx

Details

    Description

      The servers table table is already stored per catalog.

      • Test that "servers" table works per catalog.
      • Ensure that we create the 'servers' table in each catalog mysql's datadir.
      • Ensure one can connect to from a server compiled with and without catalogs:
        (Same requirement as with catalogs and the connect engine)
      • A table in another catalog.
      • A table in a non catalog server.
      • Add 'catalog' name to mysql.servers
      • Remember to fix this in mysql_fix_privileges

      Things to look at:
      sql_servers.cc
      bool servers_init(bool dont_read_servers_table)

      Attachments

        Issue Links

          relates to

          Technical task - A technical task. MDEV-31917 Add support for catalogs to connect engine

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33228 Fix Federated pre-upgrade for Catalogs

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            TheLinuxJedi Andrew Hutchings (Inactive) added a comment -

            Done:

            • Added test for cat.db connections cross-catalog in the same server (works)

            TODO:

            • Support for mysql.servers table per catalog - not working, everything seems to use def.
            • Connect test from non-catalogs server to catalogs server
            • Support catalogs keyword in `CREATE SERVER s FOREIGN DATA WRAPPER`
            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - Done: Added test for cat.db connections cross-catalog in the same server (works) TODO: Support for mysql.servers table per catalog - not working, everything seems to use def. Connect test from non-catalogs server to catalogs server Support catalogs keyword in `CREATE SERVER s FOREIGN DATA WRAPPER`
            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - - edited

            Done:

            • Add mysql.servers table per catalog
            • Fixed bugs blocking FedX to work in Catalogs

            TODO:

            • Test connect from non-catalogs to catalogs server
            • Add support for catalogs separate from db.catalog format (extra column needed?)
            • If we add extra column, the mysql_fix_privileges addition
            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - - edited Done: Add mysql.servers table per catalog Fixed bugs blocking FedX to work in Catalogs TODO: Test connect from non-catalogs to catalogs server Add support for catalogs separate from db.catalog format (extra column needed?) If we add extra column, the mysql_fix_privileges addition
            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - - edited

            Everything done apart from non-catalogs to catalogs server test. I can't see an obvious way of setting up a non-catalog and catalog server at the same time in mtr at the moment.

            All in linuxjedi-fedx branch on Hasky.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - - edited Everything done apart from non-catalogs to catalogs server test. I can't see an obvious way of setting up a non-catalog and catalog server at the same time in mtr at the moment. All in linuxjedi-fedx branch on Hasky.
            monty Michael Widenius added a comment -

            Reviewed and merged to catalog tree.

            monty Michael Widenius added a comment - Reviewed and merged to catalog tree.

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.