Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1985

LP #1694095: [PXC Strict Mode] The example on setting pxc_strict_mode as session variable doesn't work

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:

      Description

      **Reported in Launchpad by Jaime Sicam last update 26-07-2017 15:37:24

      [In:/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html]

      "Note

      It is better to start the server with the necessary mode (the default ENFORCING is highly recommended). However, you can dynamically change it during runtime. For example, to set PXC Strict Mode to PERMISSIVE, run the following command:

      mysql> SET pxc_strict_mode=PERMISSIVE;"

      But if you run this on Percona XtraDB Cluster 5.7.17-13-57-log, you get this error:
      mysql> set pxc_strict_mode=permissive;
      ERROR 1229 (HY000): Variable 'pxc_strict_mode' is a GLOBAL variable and should be set with SET GLOBAL

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                borys.belinsky Borys Belinsky
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: