Use MySqlConnector for async I/O

[bgrainger]

The AbstractQueryExecutor code uses ExecuteReaderAsync. It's a long-standing bug in MySql.Data (bug 70111) that the async I/O methods are not implemented; thus all these methods will fall back to running synchronously. (See also here and here on Stack Overflow.)

To fix this, you could switch to https://github.com/mysql-net/MySqlConnector, an OSS replacement for MySql.Data that supports true asynchronous I/O.

If you're interested in this, I'd be happy to open a PR.

[marcosArruda]

+1

[bgrainger]

Another reason to switch (which https://aaronstannard.com/opentelemetry-dotnet6/ just reminded me of) would be tracing: MySqlConnector implements ActivitySource (mysql-net/MySqlConnector#1036) and could be more easily integrated with other OTel tracing provided by Akka.

[Arkatufus]

Issue resolved in MySql.Data version 8.0.33
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-33.html