Revert "Revert "Support nested transactions with MYSQL.""

This reverts commit 11f67cca60c03221829ddf83240e67d515feced9.