So I recently had a TBs database that that I had to upgrade from
MySQL 5.0 to MySQL 5.5.
This blog post will touch on the following:
- sql_mode
- innodb_strict_mode
- SLAVE IO_THREAD
During the mysql_upgrade process (which does a mysqlcheck) I
quickly noticed the following error:
ERROR 1118 (42000) at line 23: Row size too large (>
8126). Changing some columns to TEXT or BLOB or using
ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current
row format, BLOB prefix of 768 bytes is stored
inline.
So I started I had to check a few things first.
# The master DB was > select
@@sql_mode;
+------------+
| @@sql_mode |
+------------+
| |
+------------+ New DB was
…