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

support of prepared statement (stmt) for schemarouter

    XMLWordPrintable

Details

    • MXS-SPRINT-62

    Description

      here is a comment from Mr. Markus Mäkelä, Software Engineer , from MariaDB Corporation.

      https://groups.google.com/forum/#!topic/maxscale/4TxBg0ukA00

      issue :
      schemarouter doesn't support prepared statement (stmt) queries, it will route the query to all servers .

      maxscale execute every query on both servers (serv_A & serv_B) , it should redirect the query to one where selected database is .
      i use schemarouter, it should work as proxy (high availability) .
      i see this error only if i used $mysqli->prepare() . it work fine if when i use mysqli_query();
      this is what i see on every query (with $mysqli->prepare() ) :
      ---------------------
      2017-01-31 09:35:37 error : Failed to execute select listid,eml from max_test_A.table_1 where userid in serv_B:3306. 42S02 Table 'max_test_A.table_1' doesn't exist
      ---------------------------

      maxscale.cnf & script of stmt of test are in attachments .

      Attachments

        1. maxscale_test.php
          0.6 kB
          imad el kholti
        2. maxscale.cnf
          0.7 kB
          imad el kholti

        Activity

          People

            marko.rajala Marko Rajala (Inactive)
            imados imad el kholti
            Votes:
            2 Vote for this issue
            Watchers:
            3 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.