[wp-trac] [WordPress Trac] #37923: Introduce shared wp_blogmeta database table for multisite installation

[WordPress Trac]

#37923: Introduce shared wp_blogmeta database table for multisite installation
-------------------------------------------------+-------------------------
 Reporter:  johnjamesjacoby                      |       Owner:
     Type:  feature request                      |  spacedmonkey
 Priority:  normal                               |      Status:  assigned
Component:  Networks and Sites                   |   Milestone:  4.9
 Severity:  normal                               |     Version:
 Keywords:  has-patch has-unit-tests needs-      |  Resolution:
  testing ms-roadmap                             |     Focuses:  multisite
-------------------------------------------------+-------------------------

Comment (by spacedmonkey):

 As a talking point I create
 [https://core.trac.wordpress.org/attachment/ticket/37923/37923.eachnetwork.diff
 37923.eachnetwork.diff].

 How it works is the following. Core is updated. One of the networks runs
 the database upgrade, doesn't have to be main. This then installs the
 table. Now because the detect is lazy, the next time any of the site on a
 network tries and access site meta, the detect will be run locally and the
 setting set. This means, that if you have code running on all networks
 that touch site meta, the setting will spread to all networks quickly. If
 for some reason, there is a race condition and the setting is set to 0 on
 network then later the table is installed, all that means to be done is to
 run the upgrade on the network and the setting will be set correctly.

 Having a per network setting, it is gives each network that ability to
 disable blog meta on some or all networks, if required.

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