We just move to Amazon RDS. Now all the CREATE, UPDATE, and INSERT commands are reverting in the next session. All the tables are InnoDB and query caching is on. What could be the problem?
autocommit setting. It's possible that it's disabled (set to
off) on your RDS instance and now all your uncommitted queries are getting rolled back because you're not explicitly committing.