Hello, 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.
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: https://www.percona.com/blog/2014/09/11/openstack-users-shed-light-on-percona-xtradb-cluster-deadlock-issues/ http://www.joinfu.com/2015/01/understanding-reservations-concurrency-locking-in-nova/ So you'll end up killing two birds with one stone. Hope that helps, Joe On Thu, May 7, 2015 at 6:55 AM, Janki Chhatbar <[email protected]> wrote: > Hi > > I have 2 nodes with HAProxy, MySQL-Galera and keystone each. > > node1: IP1 = HAproxy, Galera and keystone > node2: IP2 = HAproxy, Galera and keystone > 1 VIP > > I have created keystone users, endpoints, tenants. These are updated in > keystone DB as well. Galera cluster is also working fine. > > Keystone user-list > gives error. The error is at http://paste.openstack.org/show/216095/ > > Mysql users: > > mysql> select user,host from mysql.user; +------------------+--------------+ > | user | host | +------------------+--------------+ | > keystone | % | | root | % | | > keystone | IP1 | | keystone | IP2 | | keystone | VIP > | | root | 127.0.0.1 | | root | ::1 | | > debian-sys-maint | localhost | | keystone | localhost | | root > | localhost | +------------------+--------------+ 10 rows in > set (0.00 sec) > > Telnet to MYSQL: > > root@server2:/var/log/keystone# telnet VIP 3308 Trying 10.107.0.180... > Connected to 10.107.0.180. Escape character is '^]'. > R 5.6.23-1trustyZ#v'[wcjl# �#tMb%/\c^,^vYmysql_native_passwordConnection > closed by foreign host. > > > I have installed mysql-galera wsrep-5.6 from its official site. After > installing MySQL didnot start. I had to manually start with command > > mysqld --console > > What could be the possible error and its solution? I have tried > reinstalled and yet I get the same error. > > Janki Chhatbar > M.Tech (Embedded Systems) > Nirma University > (+91) 9409239106 > > _______________________________________________ > Mailing list: > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > Post to : [email protected] > Unsubscribe : > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > >
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
