Lock issue when upgraded to MySQL 8 via Percona-XtraDB-Cluster

It looks like plugin does not work well with MySQL cluster now that strict mode is ENFORCING, single mysql should be fine, any suggestions or fixes for this, it’s showing in my debug log repeatedly.

[30-Oct-2025 23:00:55 UTC] WordPress database error Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING for query SELECT GET_LOCK(‘blc_lock’, 0) made by do_action(‘wp_ajax_blc_work’), WP_Hook->do_action, WP_Hook->apply_filters, wsBrokenLinkChecker->ajax_work, wsBrokenLinkChecker->work, wsBrokenLinkChecker->acquire_lock, WPMutex::acquire