In a Rails Migration, specifying a column as binary generates a blob column. Blob columns, unfortunately, are allocated differently than any other MySQL column type; specifically, they aren’t supported in memory engine-backed tables.
Varbinary columns, on the other hand, are supported. In order to provide varbinary columns in a Migration, I wrote up this [...]