<div dir="ltr">Hello,<div><br></div><div>Do you have HAProxy configured to round-robin the MySQL traffic? If so, change the balance config to something where the source connection will always hit the same mysql node.</div><div><br></div><div>Or just make one of the mysql nodes a designated "write" node by setting the opposite node as "backup". This will then send all traffic to the writing node and resolve any deadlock errors that you might encounter:</div><div><br></div><div><a href="https://www.percona.com/blog/2014/09/11/openstack-users-shed-light-on-percona-xtradb-cluster-deadlock-issues/">https://www.percona.com/blog/2014/09/11/openstack-users-shed-light-on-percona-xtradb-cluster-deadlock-issues/</a><br></div><div><a href="http://www.joinfu.com/2015/01/understanding-reservations-concurrency-locking-in-nova/">http://www.joinfu.com/2015/01/understanding-reservations-concurrency-locking-in-nova/</a></div><div><br></div><div>So you'll end up killing two birds with one stone.</div><div><br></div><div>Hope that helps,</div><div>Joe</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 7, 2015 at 6:55 AM, Janki Chhatbar <span dir="ltr"><<a href="mailto:jankihchhatbar@gmail.com" target="_blank">jankihchhatbar@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div><div>Hi<br><br></div>I have 2 nodes with HAProxy, MySQL-Galera and keystone each.<br><br></div>node1: IP1 = HAproxy, Galera and keystone<br>node2: IP2 = HAproxy, Galera and keystone<br></div>1 VIP<br><br></div>I have created keystone users, endpoints, tenants. These are updated in keystone DB as well. Galera cluster is also working fine. <br><br></div>Keystone user-list <br></div>gives error. The error is at <a href="http://paste.openstack.org/show/216095/" target="_blank">http://paste.openstack.org/show/216095/</a><br><br></div>Mysql users:<br clear="all"><div><pre><code><span>mysql</span><span>></span><span> </span><span>select</span><span> user</span><span>,</span><span>host </span><span>from</span><span> mysql</span><span>.</span><span>user</span><span>;</span><span>
</span><span>+------------------+--------------+</span><span>
</span><span>|</span><span> user </span><span>|</span><span> host </span><span>|</span><span>
</span><span>+------------------+--------------+</span><span>
</span><span>|</span><span> keystone </span><span>|</span><span> </span><span>%</span><span> </span><span>|</span><span>
</span><span>|</span><span> root </span><span>|</span><span> </span><span>%</span><span> </span><span>|</span><span>
</span><span>|</span><span> keystone </span><span>|</span><span> IP1 </span><span>|</span><span>
</span><span>|</span><span> keystone </span><span>|</span><span> IP2 </span><span>|</span><span>
</span><span>|</span><span> keystone </span><span>|</span><span> VIP </span><span>|</span><span>
</span><span>|</span><span> root </span><span>|</span><span> </span><span>127.0</span><span>.</span><span>0.1</span><span> </span><span>|</span><span>
</span><span>|</span><span> root </span><span>|</span><span> </span><span>::</span><span>1</span><span> </span><span>|</span><span>
</span><span>|</span><span> debian</span><span>-</span><span>sys</span><span>-</span><span>maint </span><span>|</span><span> localhost </span><span>|</span><span>
</span><span>|</span><span> keystone </span><span>|</span><span> localhost </span><span>|</span><span>
</span><span>|</span><span> root </span><span>|</span><span> localhost </span><span>|</span><span>
</span><span>+------------------+--------------+</span><span>
</span><span>10</span><span> rows </span><span>in</span><span> </span><span>set</span><span> </span><span>(</span><span>0.00</span><span> sec</span><span>)<br><br></span></code></pre><pre><code><span>Telnet to MYSQL:<br><br></span></code><code><span>root@server2</span><span>:</span><span>/var/</span><span>log</span><span>/</span><span>keystone</span><span># telnet VIP 3308 </span><span>
</span><span>Trying</span><span> </span><span>10.107</span><span>.</span><span>0.180</span><span>...</span><span>
</span><span>Connected</span><span> to </span><span>10.107</span><span>.</span><span>0.180</span><span>.</span><span>
</span><span>Escape</span><span> character </span><span>is</span><span> </span><span>'^]'</span><span>.</span><span>
R
</span><span>5.6</span><span>.</span><span>23</span><span>-</span><span>1trustyZ</span><span>#v'[wcjl# �#tMb%/\c^,^vYmysql_native_passwordConnection closed by foreign host.</span></code><br></pre><div><div><div><div><div><div><div><div><div><div><div><div><div dir="ltr"><div><div><div><br><p>I have installed mysql-galera wsrep-5.6 from its official site. After
installing MySQL didnot start. I had to manually start with command</p> <pre><code><span>mysqld </span><span>--</span><span>console</span></code></pre><font face="courier new,monospace">What could be the possible error and its solution? I have tried reinstalled and yet I get the same error.<span class="HOEnZb"><font color="#888888"><br></font></span></font></div><span class="HOEnZb"><font color="#888888"><div><font face="courier new,monospace"><br>Janki Chhatbar<br></font></div><font face="courier new,monospace">M.Tech (Embedded Systems)<br></font></font></span></div><span class="HOEnZb"><font color="#888888"><font face="courier new,monospace">Nirma University<br></font></font></span></div><span class="HOEnZb"><font color="#888888"><font face="courier new,monospace"><a href="tel:%28%2B91%29%209409239106" value="+919409239106" target="_blank">(+91) 9409239106</a><br></font></font></span></div></div></div>
</div></div></div></div></div></div></div></div></div></div></div></div>
<br>_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br></blockquote></div><br></div>