title: Moodle with Amazon Aurora: Index column size too large. The maximum column size is 767 bytes
body: <p>When performing the database creation, Aurora is throwing the following error to Moodle:</p>
  
  <pre><code>ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.
  </code></pre>
  
  <p>It happens on every table that has a <code>BIGINT(10) id</code> column, like <code>mdl_config</code> or <code>mdl_course</code>.</p>
  
  <p>It seems that it's something related to Barracuda format. The InnoDB file variables present in the database are:</p>
  
  <pre><code>innodb_file_format = Barracuda
  innodb_file_format_check = ON
  innodb_file_format_max = Antelope
  innodb_file_file_per_table = ON
  </code></pre>
  
  <p>I have to say that in the Aurora Parameter Groups there's no way to change the <code>innodb_file_format_max</code> configuration.</p>
  
  <p>The Moodle version I'm using is <code>3.1.6</code>.</p>