<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Paul<br>
I believe that this work from Crinkle is stopped now. Latest
comments in her patch:<br>
<br>
<table class="commentPanelHeader">
<tbody>
<tr>
<td>
<pre>
</pre>
</td>
<td title="Colleen Murphy <colleen@gazlene.net>"
class="commentPanelAuthorCell">
<pre>Colleen Murphy</pre>
</td>
<td class="commentPanelSummaryCell">
<pre>
</pre>
</td>
<td title="Oct 6, 2015 10:38 PM" class="commentPanelDateCell"
align="right">
<pre>Oct 6 10:38 PM</pre>
</td>
</tr>
</tbody>
</table>
<div aria-hidden="false" style="" class="commentPanelContent">
<div class="commentPanelMessage">
<pre>Patch Set 18: Workflow-1</pre>
<pre>Via
discussion with Clark we're going to try to resolve dependency
conflicts and merge this list with the existing modules.env, since using
the openstack_project::server class requires using a lot of Infra
modules anyway. This will simplify testing and allow us to continue
without having masterless puppet worked out yet.</pre>
<p>So I don't think we can use that as an alternative at the
moment. That leaves us with the puppet-apply refactor as the
way to do it.<br>
Spencer, what's the status of that and how can we help?<br>
</p>
<p>Best<br>
Yolanda<br>
</p>
</div>
</div>
<br>
<div class="moz-cite-prefix">El 02/11/15 a las 22:18, Paul Belanger
escribió:<br>
</div>
<blockquote cite="mid:20151102211832.GA5611@localhost.localdomain"
type="cite">
<pre wrap="">On Mon, Nov 02, 2015 at 11:05:04AM -0800, Spencer Krum wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I agree with the strategy put forward by Clark and Jeremy. As for the
dynamic control Paul is talking about creating, I think it does have
value, but we can get away with this upgrade without it. After we're on
puppet apply, building automation so that different nodes can use
different modules makes more sense.
</pre>
</blockquote>
<pre wrap="">I am not sure how we can pass the gate with out it. Once we bump puppet-mysql
to 3.6.1, everything will break. Depends-On won't help us, since we'll have a
bunch of circular dependencies.
</pre>
<blockquote type="cite">
<pre wrap="">It is my goal to work on puppet apply before the puppet-mysql upgrade.
We have elasticsearch and gerrit upgrades coming down the pipe as well.
So I'm not sure when we can do this work or who can do it.
</pre>
</blockquote>
<pre wrap="">Right, so waiting on puppet apply changes we are blocking the puppet-mysql
upgrade path. What do you think your timelines are for fully depolying puppet
apply into production?
I know crinkle had another patch up[1] that sandboxes infra-cloud modules into
a new directory, but not sure status of that. If infra-roots are fine with that,
that will at least allow infra-cloud to move forward with the newer version of
puppet-mysql. This method is the first step of the dynamic modulepath too.
[1] <a class="moz-txt-link-freetext" href="https://review.openstack.org/#/c/209617/">https://review.openstack.org/#/c/209617/</a>
</pre>
<blockquote type="cite">
<pre wrap="">--
Spencer Krum
<a class="moz-txt-link-abbreviated" href="mailto:nibz@spencerkrum.com">nibz@spencerkrum.com</a>
On Mon, Nov 2, 2015, at 10:49 AM, Paul Belanger wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Mon, Nov 02, 2015 at 10:27:26AM -0800, Clark Boylan wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Mon, Nov 2, 2015, at 07:58 AM, Paul Belanger wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Greetings,
I'd like to start a thread talking about the effort to upgrade our
version of
puppet-mysql to a newer / latest version. I know there has been some talk
on this already, would somebody mind adding some information?
I have heard 3 things:
1. Remove database support from current modules, and only use
sql_connection
strings.
2. Move everything to trove
3. Setup mysql cluster
</pre>
</blockquote>
<pre wrap="">I think this is mostly orthogonal to updating the puppet-mysql module
because 2 + 1ish (use sql_connection) is basically what we do everywhere
but Jenkins slave image builds, paste.openstack.org, and
wiki.openstack.org.
</pre>
<blockquote type="cite">
<pre wrap="">
Again, I don't know if there are true or not, just things I have seen
people
talk about.
The obviously part that is missing, is _how_ we are going to do the
upgrade. I
know some people (clarkb?) already have some ideas on that.
The reason for me asking, 2 weeks ago I offered to help the infra-cloud
move
forward and upgrading puppet-mysql was one of the items discussed. So,
here I
am, offering to do the grunt work, just need some understanding on what
people
want to do.
</pre>
</blockquote>
<pre wrap="">I was hoping that there was a forward and backward compatible
intermediate step we could make where old and new configs were supported
but I am told that isn't possible. As a result we will likely need to
update puppet-mysql, then all three of the above uses of puppet-mysql
semi atomically to keep everything working.
Testing that image builds work before the update is simple as we can
just run
openstack-infra/project-config/nodepool/scripts/prepare_node_bare.sh to
see if that works. Paste.o.o is simple and has gone from local Drizzle
to Trove to local MySQL without much fuss so I doubt it will have much
trouble but a test deployment is easy if we are worried.
The tricky one is going to be wiki.openstack.org and this is maybe where
the above list is relevant to the discussion. We could move it to an off
host database hosted by trove and not worry about updating puppet-mysql
in that module at all. Or we can test a deployment of wiki using the
newer mysql module before prod deployment. In either case we should
probably announce a wiki downtime prior to the upgrade, stop apache/php,
perform a database backup, switch to trove/run puppet with newer module,
restart apache/php.
</pre>
</blockquote>
<pre wrap="">So one of the big things I see, is once we bump puppet-mysql to the newer
/
latest version, all our current nodes will start consuming it (unless we
stop
puppet on each server).
One thought I had was some like this:
1. Create /opt/puppet/modules/old, install current puppet-mysql module
into
it.
2. Remove /etc/puppet/modules/mysql and append --modulepath to now
include
/opt/puppet/modules/old
3. Add dynamic logic to build modulepath for puppet-mysql based on flag
and
force all nodes to it.
4. install puppet-mysql latest into /etc/puppet/modules.
5. Start migration process, paste.o.o for example.
6. Work through all nodes.
7. Disable dynamic modulepath logic (can be used for other module
upgrades).
8. Delete /opt/puppet/modules/old/mysql
Something like this, would allow us to some how control which nodes start
consuming the newer version of puppet-mysql. Instead of a massive
cutover for
all our nodes.
</pre>
<blockquote type="cite">
<pre wrap="">Hope this helps,
Clark
_______________________________________________
OpenStack-Infra mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OpenStack-Infra@lists.openstack.org">OpenStack-Infra@lists.openstack.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
OpenStack-Infra mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OpenStack-Infra@lists.openstack.org">OpenStack-Infra@lists.openstack.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
OpenStack-Infra mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OpenStack-Infra@lists.openstack.org">OpenStack-Infra@lists.openstack.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
OpenStack-Infra mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OpenStack-Infra@lists.openstack.org">OpenStack-Infra@lists.openstack.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-infra</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Yolanda Robla Mota
Cloud Automation and Distribution Engineer
+34 605641639
<a class="moz-txt-link-abbreviated" href="mailto:yolanda.robla-mota@hpe.com">yolanda.robla-mota@hpe.com</a></pre>
</body>
</html>