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

show shards does not show all information expected

    XMLWordPrintable

Details

    Description

      show shards does NOT show all the databases nor the tables but only some:

      mariadb --user=app --password=secret --host=10.139.158.211 --port=3306 customer_0030 --execute='show shards' | grep customer_00.*1 | column -t
      customer_0010. shard1
      customer_0010.address shard1
      customer_0010.sales shard1
      customer_0021. shard2
      customer_0021.address shard2
      customer_0021.sales shard2
      customer_0011. shard1
      customer_0011.address shard1
      customer_0011.sales shard1

      This contradicts IMHO what is written in the docu:
      "The schemarouter will also intercept the SHOW DATABASES command and generate it based on its internal data. This means that newly created databases will not show up immediately and will only be visible when the cached data has been updated."
      https://mariadb.com/kb/en/mariadb-maxscale-2308-schemarouter/#custom-sql-commands

      The missing tables were created long before the MaxScale was restarted last time...

      Attachments

        Activity

          People

            markus makela markus makela
            oli Oli Sennhauser
            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.