Switch MySQL live tests to use IAsyncLifetime

[adrianhall]

All the tests that are "live" use .ToList() (and other sync-over-async methods).

Swap out the sync methods to use async.

This will require implementing IAsyncLifetime in the same way that the Cosmos live tests do.