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
- 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