MySQL add transaction nodes

[FelixL]

Right now, each MySQL node opens a separate connection to the database, because of that normal transactions also do not work with the MySQL Execute node, as normal transactions only have an effect on the connection they are executed in.

As a workaround, you can use XA transactions: https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
But I have not tried that yet.

To use normal transactions and/or build dedicated transaction nodes, you probably need to implement the following feature request.

Reuse database connections

I like this idea and it could apply to more than just the database nodes it would also be useful for the FTP node. The way I have seen it implemeted before is you can output a “session id” and if you are using that the connection will be kept open for the life of the workflow and you can then pass that id instead of using credentials. In theory we could automatically handle that but I suspect it wouldn’t be an easy or quick feature to add.