By sah209 on

Is anyone using PXC for backend database? If so, are you aware of or have you implemented any special DB configuration for use of Drupal 7.x with PXC? i.e. specific parameter/variable settings

We've had several instances of a deadlocking issues involving the drupal semaphore table.

I have seen some mentions of using MyISAM or other engine type for this table, but PXC relies on the use of InnoDB engine for tables for replication.

Any advise and/or insight would be much appreciated.

Regards,
Scott Haas

⋅ Categories: Drupal 7.x

Comments

arne_hortell’s picture

arne_hortell commented

hi

this might come too late for your problem but it might help someone.

problem occurrs probably because you

use write on all sql nodes. try either send writes to one node in cluster and reads to all, using some HA loadbalancer for the purpose or simply use the db setup in settings.php with write node as default master and rest of nodes as slaves.

Nothing is impossible, the impossible just takes a little more time