<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><title>Re: [Openstack] Database replacement?</title><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Actually I see people have done django and Cassandra already so it might be doable without a huge churn<o:p></o:p></span></p><p class=MsoNormal><a href="http://stackoverflow.com/questions/2369793/how-to-use-cassandra-in-django-framework">http://stackoverflow.com/questions/2369793/how-to-use-cassandra-in-django-framework</a><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>debo<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Joshua Harlow [mailto:harlowja@yahoo-inc.com] <br><b>Sent:</b> Friday, September 23, 2011 3:32 PM<br><b>To:</b> Debo Dutta (dedutta); openstack<br><b>Subject:</b> Re: [Openstack] Database replacement?<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Ya, that would be the ideal, make it more modular so that nosql engines could be hooked in (if applicable).<br><br>It might also provide someone an opportunity to re-factor <a href="https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py">https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py</a> which seems hairy (4000 lines??)<br><br>On 9/23/11 3:10 PM, "Debo Dutta (dedutta)" <<a href="dedutta@cisco.com">dedutta@cisco.com</a>> wrote:</span><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>This is a good idea. Actually it might be a very good idea to think of scalable/distributed nosql engines to interface with nova and other Openstack projects. <br> <br>Regards<br>debo<br> <br><br></span><b><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'> <a href="openstack-bounces+dedutta=cisco.com@lists.launchpad.net">openstack-bounces+dedutta=cisco.com@lists.launchpad.net</a> [<a href="mailto:openstack-bounces+dedutta=cisco.com@lists.launchpad.net">mailto:openstack-bounces+dedutta=cisco.com@lists.launchpad.net</a>] <b>On Behalf Of </b>Joshua Harlow<br><b>Sent:</b> Friday, September 23, 2011 2:40 PM<br><b>To:</b> openstack<br><b>Subject:</b> [Openstack] Database replacement?<br></span><br><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Howdy all, congrats on the diablo release!<br><br>Has there been any thought on having a nova-db service that responds to requests for information from the db (or something like a db).<br><br>This could be useful for companies that don’t necessarily want to have a limiting factor being a database. Since when u scale past a certain number of compute nodes the database connections themselves may become a bottleneck (especially the heartbeat mechanism which updates a table every X seconds). It would be interesting if these types of request could go to the message queue instead and then the db backing could be swapped out with something more scalable (or still use mysql/sqlite...).<br><br>Any thoughts?<br><br>-Josh</span> <o:p></o:p></p></div></body></html>