I need to execute some raw SQL in my Rails app. The query will do cause an implicit commit if it is performed within a transaction. We are using MySQL with InnoDB and the query will include e.g. create table.
Executing the query with ActiveRecord::Base.connection.execute triggers the implict commit which is a problem.
It feels like I just need a separate connection for performing my queries. Can ActiveRecord provide this? I've seen discussions of connecting to multiple databases but not multiple connections to the same database.
A solution doesn't have to involve ActiveRecord if there's a better way.
Our Rails and ActiveRecord version is 3.2.3.