[wp-hackers] multiple databases vs different database prefixes

[Cornelius, Gregory]

This is not for the feint of heart, especially if the environments are hooked up to different databases and the global tables (wp_blogs, wp_site, etc...) are not synchronized.  

I have been working with a group of developers on a large MPMU installation for a couple years, and we still don't have an ideal setup for prod, staging, test, devel, and development branches.  We are getting closer, but there have been lots of hiccups along the way.      

Two improvements that I would like to see happen are: an API for fetching/modifying blog settings (including widgets/sidebars) across a number of blogs in one fell swoop and a fully supported method for bootstrapping WordPress in a PHP script from the CLI .

On Aug 23, 2010, at 10:57 AM, Jeremy Clarke wrote:

> On Fri, Aug 20, 2010 at 3:38 PM, ken zarque <kenzaraque at gmail.com> wrote:
> 
>> 
>> After installing WP with MS turned on, we ran into this question "How do we
>> deploy single sites in an MS environment from one environment to another".
>> This is because we have a dev, staging and production environment.
>> 
>> Note: Should I be asking this on a separate thread?
>> 
>> 
> Yes. It is a different (though related) can of worms. I am very interested
> in the answers people give you though, as you're asking about the most
> obnoxious part of MS deployment.
> 
> -- 
> Jeremy Clarke | http://jeremyclarke.org
> Organizer | http://wordcampmontreal.org
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers