Use WP Blog meta for domain mapping

[spacedmonkey]

There is currently a core ticket to add a new table called wp_blogmeta. This would be a network level shared table for the wp_blogs table. It is currently in development, as a feature plugin here.

It would be great to use blogmeta in this drop-in once it is in core. It means that you would not have to create another table on installation. Also many of the core functions could be used in the CRUD process.

[roborourke]

Man this has long been needed! Thanks for heads up :)

[roborourke]

Only downside I see here is querying - currently with the custom table we have control over the indexes, blog meta would be fine for a relatively small number of sites but I'll approach with caution for now as I need to introduce benchmarks and tests first.

[spacedmonkey]

I have already had some thoughts about how we could in a way that we don't mess up the performance of not having indexes. If it gets into core, I was going to fork mercator to use blogmeta, as backwards compat might get a might interesting.

Blogmeta isn't a lock to go into core yet. @roborourke your support on the feature plugin is always welcome 👍

I also want to mention wp-site-aliases as it has some interesting ideas in it.

[spacedmonkey]

@roborourke Site meta will be in 5.1 💯
https://make.wordpress.org/core/2019/01/28/multisite-support-for-site-metadata-in-5-1/

[roborourke]

@rmccue so you're aware ^ Interested in your thoughts.

Main considerations are performance and the stage at which blogmeta functions become available during the bootstrapping as to whether this will work. Also migration & back compat need to be factored in.