There has been a problem with
emojis and I think the problem is related to collation. Possibly other
issues could arise in the future or be connected to this? I am now looking for
alternatives on how to best correct this. I want everything to be utf8mb4_unicode_ci as I understand to be default since many years.
We have a fairly large moodle enviorment with a database ~100GB on moodle 3.6.6
"php <path_to_moodledir>/admin/cli/mysql_collation.php -l" gives me...
As this is
$CFG->dboptions = array (
'dbpersist' => 0,
'dbsocket' => '',
// This I want to add as in config-dist.php: 'dbcollation' => 'utf8mb4_general_ci'
//$CFG->debugdisplay = 1; // NOT FOR PRODUCTION SERVERS!
=== My concern.
My concern for this is when we're running the script on our test enviroment it is slow.. Really slow. Granted this is a weaker machine than our DB cluster but still it will have alot to do and I think at the very least 12h but I wouldn't be suprised if it goes past 24h to do this. So if our porcelain breaks it wont be funny...
I worry it will be hard when we get to some of the bigger once...
But I also find it unacceptable to just 'let it be' the problem is the database doesn't shrink and the problem will only grow bigger for 'the next guy'
=== My questions.
- Does anyone have any experience with something like this, fixing the collation on such a big site?
- Does anyone see any more red flags or am I overparanoid? (I really don't know what could go wrong, I just assume it could- I worry problems might surface up days or even weeks after this and there will be no 'way back')
=== The options I see?
- I run the mysql_collation.php with a nohup after a nightly backup - It will probably just work with some bumbs on large tables.
- Start modifying the mysql_collation.php to just work on one table at a time and beg and scratch for some scheduled downtime to take the 'really big ones'
- Head in the sand "It is just emojis and you will likely never need to worry about it in the future"