title: Migrating Spring Batch MyISAM Sequence Tables to InnoDB
body: <p>Spring batch uses a few sequence tables, which in the case of MySQL use the MyISAM storage engine. The issue I'm facing is that I'm using an Amazon Web Services RDS database, and their "Point in Time" database restore feature does not play nicely with databases containing MyISAM tables.</p>
  
  <p>I'm looking for a solution that will let me switch out these Spring Batch MyISAM sequence tables and replacing them with InnoDB tables instead, with the goal of enabling the AWS RDS "Point in Time" database restoration feature.</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>Per @Michael's response, here's a comment from the Java class <code>MySQLMaxValueIncrementer</code>that reads the sequence:</p>
  
  <pre><code>The sequence is kept in a table; there should be one sequence table per
  table that needs an auto-generated key. The table type of the sequence table
  should be MyISAM so the sequences are allocated without regard to any
  transactions that might be in progress.
  </code></pre>
  
  <p>So my specific question is "what is the simplest possible way to remove the MyISAM sequence table" and keep Spring Batch humming along?</p>