Wikimedia Developer Support

Database structure change for use in MySql Cluster


I’m using Wiki 1.31 with Percona XtraDB Cluster (master x master, version 5.7) with 3 nodes. Second the developer: “Percona XtraDB Cluster cannot properly propagate certain write operations to tables that do not have primary keys defined”.

I have checked and some tables does not have primary keys:

Too, the table mw_searchindex still using the engine MyIsam (all other tables are InnoDB);

I think clustering will be increasingly used… and this changes will continue to be compatible with local DB use.

Do this changes on tables structures maybe considered an enhancement for a future release ?

Best regards.

This is a known issue and you can see more information at - Some of them might not have a PK, but they do have (at least) UNIQUE indexes.

It would look like a couple of those tables need tasks filing for them though. I’ll get those done filed for the remaining 4 tables that didn’t have a task already for InnoDB in search_index

About the search_index, if you want to use cluster, I’d suggest you to use Extension:CirrusSearch with ElasticSearch, which has better performance and supports cluster natively. With that extension, the search_index table is no longer used.