<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
Awsome news. Should there be a tag added for gallera multimaster safe to let us ops know about these things?<br>
<br>
Thanks,<br>
Kevin <strong>
<div><font face="Tahoma" color="#000000" size="2"> </font></div>
</strong>
<hr tabindex="-1">
<font face="Tahoma" size="2"><b>From:</b> Kevin Benton<br>
<b>Sent:</b> Monday, December 07, 2015 6:08:12 PM<br>
<b>To:</b> Matteo Panella<br>
<b>Cc:</b> OpenStack Operators<br>
<b>Subject:</b> Re: [Openstack-operators] Galera setup testing<br>
</font><br>
<div></div>
<div>
<p dir="ltr">Neutron has protection against these now as of liberty with API level retry operations so this shouldn't be a problem for neutron any more.
</p>
<div class="gmail_quote">On Dec 7, 2015 4:06 PM, "Matteo Panella" <<a href="mailto:matteo.panella@cnaf.infn.it">matteo.panella@cnaf.infn.it</a>> wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
On 2015-12-07 22:45, James Dempsey wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
+1 for designating one node as primary. This helped us reduce some<br>
deadlocks that we were seeing when balancing sessions between DB hosts.<br>
</blockquote>
<br>
Keystone most likely won't be affected by writeset certification failures,<br>
but other services (especially Neutron) are going to be hit by one sooner<br>
or later.<br>
<br>
Unfortunately, Galera doesn't take very kindly "SELECT ... FOR UPDATE", so<br>
you can't really do proper load balancing (aside from designating a different node<br>
as master in multiple listen stanzas, each one for a different set of services).<br>
<br>
Regards,<br>
-- <br>
Matteo Panella<br>
INFN CNAF<br>
Via Ranzani 13/2 c - 40127 Bologna, Italy<br>
Phone: <a href="tel:%2B39%20051%20609%202903" value="+390516092903" target="_blank">
+39 051 609 2903</a><br>
<br>
_______________________________________________<br>
OpenStack-operators mailing list<br>
<a href="mailto:OpenStack-operators@lists.openstack.org" target="_blank">OpenStack-operators@lists.openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a><br>
</blockquote>
</div>
</div>
</body>
</html>