I just finished reading a couple of interesting, and somewhat related, blog posts which I think are worth sharing (apologies to anyone who has already seen them). One is from Jelastic and the other is from Michal Hrušecký. I’ve written about MariaDB and the Jelastic cloud before (see MariaDB now available as a hosted database […]READ MORE
There's innodb_large_prefix as a possible workaround, which is default in 10.2 https://t.co/URwAEaZcN7
The reason is because MariaDB imposes a maximum of 767 bytes for indexes, and 767 / 4 = 191 (rounded down).
The danger of no Primary Key when replicating in RBR (partial protection with MariaDB 10.1) https://t.co/M6mABJdkmn by @jfg956