Hello,
We also have some clients who are using MariaDB (Galera) cluster or single servers using InnoDB with the innodb_force_primary_key=1 variable.
In Galera cluster, the primary key is a requirement for the tables to replicate reliably and InnoDB with that setting won’t create the tables at all.
Adding a primary or unique key to both tables (aws_index & aws_cache) would make our sysadmins life easier and improve performance on larger sites.
Regards,
Joonas