WIP: Dropping subgroup support on mysql

Closed Mike Bartlett requested to merge dropping-subgroups-for-mysql into master

This blog post outlines the reasons why we are dropping subgroup support on MySQL. Please feel free to add any details on why we are dropping support and more information on the migration path.