[Opendnssec-user] upgrade debian Jessie to Stretch: database trouble
C.Gielen at uvt.nl
Thu Nov 2 16:21:27 UTC 2017
Op 02-11-17 om 16:57 schreef Dennis Baaten:
> Yes same here. Tried this already.
> In /etc/mysql/mariadb.conf.d/50-server.cnf:
> innodb_file_format = Barracuda
> innodb_large_prefix = on
> Check variables with phpMyAdmin, and they are set correctly.
I just realized that my documentation is not complete, thanks for
pointing that out before it my production environment :)
I changed schema.mysql, patch attached.
The trick is appending "ROW_FORMAT=DYNAMIC" to the table definitions.
In hindsight I think the first lines of this patch, (SET GLOBAL...)
are redundant with the configuration above, but I'm not sure.
Casper Gielen <cgielen at uvt.nl> | LIS UNIX
PGP fingerprint = 16BD 2C9F 8156 C242 F981 63B8 2214 083C F80E 4AF7
Universiteit van Tilburg | Postbus 90153, 5000 LE
Warandelaan 2 | Telefoon 013 466 4100 | G 236 | http://www.uvt.nl
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 1272 bytes
Desc: not available
More information about the Opendnssec-user