There are many features that are similar in MySQL and Drizzle. There are also many that are not.
I’ve previously discussed topics like Datatypes and tables, SQL_MODE and SHOW.
A key difference in Drizzle is the definition of utf8 as 4 bytes, not 3 bytes as in MySQL. This combined with no other character sets leads to an impact on the length in keys supported in Innodb.
During a recent test with a client, I was unable to successfully migrated the schema and provide the same schema due to unique indexes defined for utf8 VARHAR(255) fields.
Here is the problem. …
[Read more]