[GitHub] [druid] AngryUbuntuNerd commented on issue #7663: druid 0.14.1-incubating create table failed when starting the Coordinator

[GitBox <gi...@apache.org>]

AngryUbuntuNerd commented on issue #7663:
URL: https://github.com/apache/druid/issues/7663#issuecomment-621233337


   This solution doesnt work anymore since 0.17 as Druid tries to create tables with `utf8mb4` even if `utf8_general_ci` is set as default on the database.
   
   That breaks it for MySQL 5.6 or lower. Higher versions of MySQL are not affected I believe as the default key size is bigger.
   
   A fix for 5.6 could be to use `innodb_large_prefix` but this requires Druid to create tables with a different InnoDB row format (`COMPACT` is default). See https://dev.mysql.com/doc/refman/5.6/en/innodb-limits.html


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org