[wp-trac] [WordPress Trac] #45697: Database: Upgrading field collations

[WordPress Trac]

#45697: Database: Upgrading field collations
-------------------------+-----------------------------
 Reporter:  pento        |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Future Release
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+-----------------------------

Comment (by pento):

 There are a few options that come to mind for this:

 - Check during the upgrade routine, and upgrade the collations then, if
 needed. While this makes the upgrade predictable, it means there's a
 period of time where the collations might be out of sync.
 - Schedule background upgrades when the MySQL change is detected. This
 avoids problems with collations being out of sync, but could generate long
 running queries that lock the tables. This may be less of an issue with
 newer versions of MySQL that support online DDL changes.
 - Add this to Health Check, and require it to be triggered manually.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/45697#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform