Since quite some years now I have a nextcloud instyance helping me getting away from the GAFAMs. This means that my database was also setup quite some years ago.
Now, I would like to enable mysql 4-byte support on my database.
the nextcloud version is 15 and mysql 5.5.62 on a debian 8.
If I follow the docs I should perform these steps:
SET GLOBAL innodb_file_format=Barracuda;
Then change my mysql conf to
[mysqld] innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=1
Restart the mysql server
Update my nextcloud database
ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
And finish with these:
sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value="true" sudo -u www-data php occ maintenance:repair
After these steps, and some magics and the mysql side, everything should have been converted without problems ???
I am only wondering if changing the innodb settings is safe on a server that also has other batabases in it ?
I am not a MySQL expert at all but changing the innodb settings that easily looks like magics to me so that’s why I am wondering!
Any help/thoughts are welcome!