I’ve continued building on my MariaDB GIS and node.js example application that I wrote about two weeks back, https://blog.mariadb.org/node-js-mariadb-and-gis/. The application shows how to load GPX information into MariaDB, using some MariaDB GIS functionality, and making use of the node.js platform together with MariaDB’s non-blocking client. With the GPX data converted into GIS points in […]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