We are looking for a shared host that supports some SQL settings. I know the best approach would be to get a managed VPS that would allow us to ensure that our website has the right settings – but that's not an option for us ATMs.
You are looking for a server with the following SQL parameters for our CRM.
innodb_large_prefix = true innodb_file_format = barracuda innodb_file_per_table = true
Note: These are the same settings for Drupal 7 – UTF8MB4 support. so they are not rare.