ClearPools.cs

policies.Execute(() =>
{
    using (var conn = new MySqlConnection(ConnectionString))
    {
        try
        {
            conn.Open();
            conn.Insert(new Record { Id = i + 1, Name = $"Aman {i + 1}" });
            Log.Logger.Information(
                "Inserted row with id {id} successfully!",
                i + 1);
        }
        catch (MySqlException mysqlEx)
        {
            if (mysqlEx.IsFailoverException())
            {
                Log.Logger.Warning(
                    "Clearing current connection pool because an exception {@exception} occurred",
                    new
                    {
                        Msg = mysqlEx.Message,
                        Number = mysqlEx.Number,
                        HR = mysqlEx.HResult
                    });

                // for this call to do anything, the idle pool should have non-zero connections
                // which it will after the connection is disposed. This increases the likelihood
                // of retries succeeding.
                MySqlConnection.ClearPool(conn);
            }

            throw mysqlEx;
        }
    }
});