[openstack-dev] [Fuel][MySQL][Galera] Improvements for the DB configuration

Bogdan Dobrelya bdobrelia at mirantis.com
Mon Mar 30 12:56:54 UTC 2015

There are several bugs and patches on review related to the MySQL with
Galera and HAproxy cluster-check script configuration. Please don't
hesitate to discuss them in this mail thread and in the review.

* MySQL O_DIRECT mode [0] - merged. Do we need some additional
performance test cases for this change? This is also about to
improve the memory allocation for the host OS as O_DIRECT eliminates
double buffering.

* Galera clustercheck script should use available_when_donor=1 [1].
This one should improve the UX for the case when all galera nodes went
down and cluster is being reassembled completely.

* Mysql deadlock duiring deployment [2]. While the fix for the
puppet-mysql provider issue [3] could be also nice to have, the related
fix is to increase wsrep_retry_autocommit to make deadlocks be tolerated
in a slightly better way from the server side as well.

* READ-COMMITED transactions isolation for MySQL [4]. There is an
original mail thread [5] explaining the related Oslo.db issue with
transactions semantics for different types of DB backend.

[0] https://bugs.launchpad.net/fuel/+bug/1378063
[1] https://bugs.launchpad.net/fuel/+bug/1437816
[2] https://bugs.launchpad.net/fuel/+bug/1431702
[3] https://tickets.puppetlabs.com/browse/MODULES-1852
[4] https://bugs.launchpad.net/fuel/+bug/1438107

Best regards,
Bogdan Dobrelya,
Skype #bogdando_at_yahoo.com
Irc #bogdando

More information about the OpenStack-dev mailing list