DIRAC icon indicating copy to clipboard operation
DIRAC copied to clipboard
verified publisher icon DIRACGrid

[9.0] move default MySQL charset to utf8mb4

Open fstagni opened this issue 2 years ago • 2 comments

  • [ ] add to Wiki (first prepare the "plan")
  • [ ] verify for collation
  • [ ] check https://indico.cern.ch/event/1264910/contributions/5339400/attachments/2621342/4532678/IT%20ASDF%20DBOD%202023%20News%20slides.pdf

BEGINRELEASENOTES

*Core CHANGE: move default MySQL charset to utf8mb4

ENDRELEASENOTES

fstagni avatar Mar 29 '23 13:03 fstagni

Can you remind me why we did not do it for the LHCb DB ?

chaen avatar Mar 29 '23 16:03 chaen

Because it first needed to be tested (some details in https://cern.service-now.com/service-portal?id=ticket&n=RQF2129972). It's very unlikely that we'll catch much with the current integration tests (and indeed, no errors here) but it is anyway a necessary step.

fstagni avatar Mar 29 '23 20:03 fstagni

The slides say

latin1 can still be used provided limitations vs utf8mb4 are not an issue

andresailer avatar Mar 05 '25 13:03 andresailer

The slides say

latin1 can still be used provided limitations vs utf8mb4 are not an issue

Those slides are old by now, I will replace them with a up-to-date link.

It will still be possible to use latin1 even with MySQL 8.4, and even utfmb3 (which is "deprecated") but MySQL recommends utfmb4, which is also apparently faster.

fstagni avatar Mar 05 '25 13:03 fstagni

Merging, as this is only impacting newly created DBs (new installations, and integration tests)

fstagni avatar Mar 06 '25 10:03 fstagni