Found a library called mysql-queues; it is a wrapper for mysql-node with some support for transactions and multiple parallel insert queues; rollback and commit are key feature of this library which allow us to follow a unique design pattern for the sql adapter