Is it possible to share a single wordpress database between all sites on a multisite?
We are building a music site that has both a national and a local focus. The national site will be the root domain and the local sites will be in subdirectories. We want to use subdirectories and not subdomains in order to keep the focus on the root domain name. Each site will have its own front page.
I'll use the domain music.com as an example, although this is not the actual domain name...
music.com [national content and best of local content]
music.com/newyork [local content and selected national content]
music.com/boston [local content and selected national content]
It seems like it would be easiest to accomplish this by having all of the sites share a single database and then use tags to control which posts appear on which site. For example, posts tagged "Boston only" would only appear in music.com/boston.
My understanding of multisites, however, is that each site must have its own separate database, which would prevent sharing between sites. Is that correct? Is there any way around that?
If not, is there a way to install multiple wordpress installations in subdirectories off of a root domain? At least with GoDaddy it seems that you can only install WordPress for domains and subdomains, not subdirectories. Is that a GoDaddy limitation or WordPress limitation?
Any advice is greatly appreciated. Hopefully I explained our needs clearly enough.