Another topic at MW Summit was using sql_mode to avoid some of MySQL's odd legacy behaviour. They are:

https://mariadb.com/kb/en/mariadb/sql_mode/

You can set sql_mode per client connection on analytics-store without affecting anyone else or replication.