WIP: Providers refactoring

WIP WIP WIP DON'T MERGE:

This PR refactors the providers to rename them from database_X to mysql_X and attempts to bring in several improvements, from better instances to prefetch support.