Puppet users - Mar 2011 - wordpress.com and puppet, would they use it to update mysql db schema's also?

Say for example wordpress.com uses puppet to rollout the wordpress software
for its customers.

During updates to the software, say there are mysql schema updates.

i.e. say they have 100K mysql databases, 1 for each blog.
And the database for each blog as to be updated to version x which adds a
few tables, columns to tables etc.

If they have 100K wordpress installations spanning hundreds of servers,
would Puppet be a good choice for updating/migrating the mysql db''s for
all
the installs?

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

On 29 March 2011 15:36, S Ahmed <sahmed1020@gmail.com> wrote:
> Say for example wordpress.com uses puppet to rollout the wordpress
> software for its customers.
>
> During updates to the software, say there are mysql schema updates.
>
> i.e. say they have 100K mysql databases, 1 for each blog.
> And the database for each blog as to be updated to version x which adds a
> few tables, columns to tables etc.
>
> If they have 100K wordpress installations spanning hundreds of servers,
> would Puppet be a good choice for updating/migrating the mysql
db''s for all
> the installs?
>
>
> Personally I''d go with capistrano or something along those lines
for a
once-off job like that.

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

On 03/29/2011 06:52 PM, Richard Clark wrote:
> On 29 March 2011 15:36, S Ahmed <sahmed1020@gmail.com
> <mailto:sahmed1020@gmail.com>> wrote:
> 
>     Say for example wordpress.com <http://wordpress.com> uses puppet
to
>     rollout the wordpress software for its customers.
> 
>     During updates to the software, say there are mysql schema updates.
> 
>     i.e. say they have 100K mysql databases, 1 for each blog.
>     And the database for each blog as to be updated to version x which
>     adds a few tables, columns to tables etc.
> 
>     If they have 100K wordpress installations spanning hundreds of
>     servers, would Puppet be a good choice for updating/migrating the
>     mysql db''s for all the installs?
> 
> 
> Personally I''d go with capistrano or something along those lines
for a
> once-off job like that. 
Speaking of Capistrano, you may want to look at mCollective *hint, hint* ;-)

Cheers,
Felix

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

What''s the hint hint for, sorry I don''t get it :)

On Wed, Mar 30, 2011 at 11:26 AM, Felix Frank <
felix.frank@alumni.tu-berlin.de> wrote:
> On 03/29/2011 06:52 PM, Richard Clark wrote:
> > On 29 March 2011 15:36, S Ahmed <sahmed1020@gmail.com
> > <mailto:sahmed1020@gmail.com>> wrote:
> >
> >     Say for example wordpress.com <http://wordpress.com> uses
puppet to
> >     rollout the wordpress software for its customers.
> >
> >     During updates to the software, say there are mysql schema
updates.
> >
> >     i.e. say they have 100K mysql databases, 1 for each blog.
> >     And the database for each blog as to be updated to version x which
> >     adds a few tables, columns to tables etc.
> >
> >     If they have 100K wordpress installations spanning hundreds of
> >     servers, would Puppet be a good choice for updating/migrating the
> >     mysql db''s for all the installs?
> >
> >
> > Personally I''d go with capistrano or something along those
lines for a
> > once-off job like that.
>
> Speaking of Capistrano, you may want to look at mCollective *hint, hint*
> ;-)
>
> Cheers,
> Felix
>
> --
> You received this message because you are subscribed to the Google Groups
> "Puppet Users" group.
> To post to this group, send email to puppet-users@googlegroups.com.
> To unsubscribe from this group, send email to
> puppet-users+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/puppet-users?hl=en.
>
>
-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

On 1 Apr 2011, at 13:01, S Ahmed <sahmed1020@gmail.com> wrote:
> What''s the hint hint for, sorry I don''t get it :)
mCollective was acquired by puppet labs recently. haven''t used it yet
myself but it does look promising.


--
Richard Clark
richard@fohnet.co.uk

-- 
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.