Issue InnoDB tables in PSA database without primary key

[prprtl]

The Plesk database ("psa") has some InnoDB tables without primary key. This is bad for performance, and incompatible with multi-master replication. It needs fixing.

- psa.BackupsSettings
- psa.SBConfig
- psa.SchemaVersions
- psa.mass_mail_clients
- psa.mass_mail_domains
- psa.migration_version
- psa.secret_keys
- psa.smtp_poplocks
- psa.suspend_handler_history

Suggested solution:

- Fix your schema for new Plesk installations
- Create a migration script for existing Plesk installations to fix these tables using ALTER TABLE

 

[IgorG]

Please fill detailed report here Reports

 

[StéphanS]

Are you actually running Plesk in a multi-master replication setup?
If yes, which?

I am assuming Percona XtraDB Cluster 5.7?