Error on Percona multi DB server setup

  • Resolved Patrick Steil

    (@patrickchurchbuzzorg)


    8 years ago

    We are testing out using a Kubernetes setup on Google Cloud using Percona Xtra DB for running WordPress, most functions working great, but when we try your free plugin and go to Save a keyword, we get this error from Percona:

    Keyword could not be added to the database. DB said: Percona-XtraDB-Cluster prohibits use of DML command on a table (wordpress.wp_page_generator_keywords) that resides in non-transactional storage engine with pxc_strict_mode = ENFORCING or MASTER

    Are you using some DML commands to insert the records? Any way around this?

    thanks,
    Patrick
    https://www.infranet.com

Viewing 1 replies (of 1 total)
  • Plugin Author wpzinc

    (@wpzinc)

    INSERT, UPDATE and DELETE SQL commands are executed when adding, updating and deleting keywords.

    These are performed via $wpdb, in a standard manner.

    You are welcome to adjust your database settings to allow the above DML commands to be performed; note that these commands would be performed by WordPress for a lot of standard functionality, such as adding / editing / deleting Posts.

Viewing 1 replies (of 1 total)
  • The topic ‘Error on Percona multi DB server setup’ is closed to new replies.