Bug 1040599

Summary:	[RFE][nova]: Send as much DB traffic as possible from periodic tasks to DB slaves
Product:	Red Hat OpenStack	Reporter:	RHOS Integration <rhos-integ>
Component:	openstack-nova	Assignee:	Nikola Dipanov <ndipanov>
Status:	CLOSED ERRATA	QA Contact:	Ami Jeain <ajeain>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	unspecified	CC:	eglynn, markmc, ndipanov, sgordon, slong, vpopovic, yeylon
Target Milestone:	Upstream M3	Keywords:	FutureFeature, Triaged
Target Release:	5.0 (RHEL 7)
Hardware:	Unspecified
OS:	Unspecified
URL:	https://blueprints.launchpad.net/nova/+spec/periodic-tasks-to-db-slave
Whiteboard:	upstream_milestone_icehouse-3 upstream_status_implemented upstream_definition_approved
Fixed In Version:	openstack-nova-2014.1-3.el7ost	Doc Type:	Enhancement
Doc Text:	With this update, a Compute deployment which has a configured database slave (slave_connection) can send reads from periodic tasks to this slave. Periodic tasks typically result in consistently high loads to deployments. To improve performance, these tasks can now be offloaded to database slaves.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-07-08 15:26:42 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description RHOS Integration 2013-12-11 16:53:07 UTC

Cloned from launchpad blueprint https://blueprints.launchpad.net/nova/+spec/periodic-tasks-to-db-slave.

Description:

Periodic tasks are some of the most consistent load that any deployment will experience. As such, and because of the nature of most periodic tasks, their reads are prime targets for DB slaves. 

Specification URL (additional information):

None

Comment 1 David Ripton 2014-02-26 21:28:41 UTC

Still targeted at icehouse upstream, but not a release blocker.  Looks like there's a good chance it'll make icehouse, but it might miss and go in juno instead.

There are 7 merged patches, 1 still under review, all by Michael H. Wilson.

Comment 3 Ami Jeain 2014-06-10 14:14:14 UTC

verified through nova regression:
#  rpm -qa |grep openstack-nova
openstack-nova-console-2014.1-3.el7ost.noarch
openstack-nova-novncproxy-2014.1-3.el7ost.noarch
openstack-nova-api-2014.1-3.el7ost.noarch
openstack-nova-common-2014.1-3.el7ost.noarch
openstack-nova-conductor-2014.1-3.el7ost.noarch
openstack-nova-cert-2014.1-3.el7ost.noarch
openstack-nova-scheduler-2014.1-3.el7ost.noarch

and

# rpm -qa |grep openstack-nova
openstack-nova-compute-2014.1-3.el7ost.noarch
openstack-nova-common-2014.1-3.el7ost.noarch

Comment 6 errata-xmlrpc 2014-07-08 15:26:42 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHEA-2014-0853.html