<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html><head><meta http-equiv="Content-Type" content="text/html;charset=utf-8">
<style>BODY{font:10pt Tahoma,Verdana,sans-serif} .MsoNormal{line-height:120%;margin:0}</style></head><body>
Jay,<br><br>Thanks, Ill be looking forward to it.<br><br>Please let me point you to this article about why I would like to raise this question on whether it would be possible to make Nova more flexible on accepting multiple MySQL connection points. I mean, why would you add another layer of difficulty if it is not needed?<br><br>http://openlife.cc/blogs/2011/july/ultimate-mysql-high-availability-solution<br><br>Best regards,<br><br>Tristan van Bokkem<br>Datacenter Operations<br><br>Contact:<br>E-mail Personal: <a href="mailto:tristanvanbokkem@i3d.net">tristanvanbokkem@i3d.net</a><br>E-mail Support: <a href="mailto:info@i3d.net">info@i3d.net</a><br>E-mail NOC: <a href="mailto:noc@i3d.net">noc@i3d.net</a><br>Website: <a href="http://www.i3d.net" target="_blank">http://www.i3d.net</a> Office:<br>Interactive 3D B.V.<br>Meent 93b<br>3011 JG Rotterdam<br>The Netherlands<br><br>Visit www.smartdc.net – SmartDC is our in-house 36,000 sq. ft. datacenter in Rotterdam, The Netherlands. High density hosting – multiple fiber carriers in-house – Level3 PoP.<br><br>Interactive 3D (i3D.net) is a company registered in The Netherlands at Meent 93b, Rotterdam. Registration #: 14074337 - VAT # NL 8202.63.886.B01. Interactive 3D (i3D.net) is CDSA certified on content protection and security. We are ranked in the Deloitte Technology Fast 50 as one of the fastest growing technology companies.<br><blockquote style="padding-left: 5px; margin-left: 5px; border-left: #0000ff 2px solid; margin-right: 0px"><hr><b>From:</b> Jay Pipes [mailto:jaypipes@gmail.com]<br><b>To:</b> i3D.net - Tristan van Bokkem [mailto:tristanvanbokkem@i3d.nl]<br><b>Cc:</b> Alexis Richardson [mailto:alexis@rabbitmq.com], openstack@lists.launchpad.net<br><b>Sent:</b> Thu, 16 Feb 2012 13:46:31 +0100<br><b>Subject:</b> Re: [Openstack] Howto Nova setup with HA?<br><br>On 02/16/2012 07:32 AM, i3D.net - Tristan van Bokkem wrote:<br>
> Interesting. Could you point us to the github location?<br>
<br>
I will as soon as I verify with Nati that all the most-current code has <br>
been pushed there :) Expect an email later today.<br>
<br>
> Anyway, ive have done some further research myself and find this very<br>
> interesting mysql replication setup done by wsrep<br>
> (<a href="https://launchpad.net/wsrep" target="_blank">https://launchpad.net/wsrep</a>) and galeria<br>
> (<a href="https://launchpad.net/galera/" target="_blank">https://launchpad.net/galera/</a>) where mysql will run as a Synchronous<br>
> Multi-Master replication setup.<br>
><br>
> I have this running and works perfect but the problem now is. I need to<br>
> add some kind of loadbalancing setup as nova can only point to one mysql<br>
> location (i.e. --sql_connection=) So if I would point it to one of the<br>
> mysql nodes in the cluster and that one fails everything fails. Adding a<br>
> loadbalancer and point it to that will keep my mysql alive.<br>
<br>
Yep, this is a perfectly good solution for MySQL.<br>
<br>
> The main issue with this is, we are adding another point where we have<br>
> yet to configure and maintain several more nodes. I would like to raise<br>
> the question if it would be possible for nova to accept multiple mysql<br>
> connection points and therefor drop the need for extra loadbalancer<br>
> component and reducing complexity.<br>
<br>
I would strongly resist pressure to add complexity to the Nova (or other <br>
core projects) code base when an existing solution is available that is <br>
tailored to meet the need already (install a loadbalancer...)<br>
<br>
Cheers,<br>
-kjay<br>
<br>
> Best regards,<br>
><br>
> Tristan van Bokkem<br>
> Datacenter Operations<br>
><br>
> Contact:<br>
> E-mail Personal: <a href="mailto:tristanvanbokkem@i3d.net">tristanvanbokkem@i3d.net</a> <mailto:<a href="mailto:tristanvanbokkem@i3d.net">tristanvanbokkem@i3d.net</a>><br>
> E-mail Support: <a href="mailto:info@i3d.net">info@i3d.net</a> <mailto:<a href="mailto:info@i3d.net">info@i3d.net</a>><br>
> E-mail NOC: <a href="mailto:noc@i3d.net">noc@i3d.net</a> <mailto:<a href="mailto:noc@i3d.net">noc@i3d.net</a>><br>
> Website: <a href="http://www.i3d.net" target="_blank">http://www.i3d.net</a> Office:<br>
> Interactive 3D B.V.<br>
> Meent 93b<br>
> 3011 JG Rotterdam<br>
> The Netherlands<br>
><br>
> Visit www.smartdc.net – SmartDC is our in-house 36,000 sq. ft.<br>
> datacenter in Rotterdam, The Netherlands. High density hosting –<br>
> multiple fiber carriers in-house – Level3 PoP.<br>
><br>
> Interactive 3D (i3D.net) is a company registered in The Netherlands at<br>
> Meent 93b, Rotterdam. Registration #: 14074337 - VAT # NL<br>
> 8202.63.886.B01. Interactive 3D (i3D.net) is CDSA certified on content<br>
> protection and security. We are ranked in the Deloitte Technology Fast<br>
> 50 as one of the fastest growing technology companies.<br>
><br>
> ------------------------------------------------------------------------<br>
> *From:* Jay Pipes [mailto:<a href="mailto:jaypipes@gmail.com">jaypipes@gmail.com</a>]<br>
> *To:* Alexis Richardson [mailto:<a href="mailto:alexis@rabbitmq.com">alexis@rabbitmq.com</a>]<br>
> *Cc:* <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> *Sent:* Thu, 16 Feb 2012 13:11:36 +0100<br>
> *Subject:* Re: [Openstack] Howto Nova setup with HA?<br>
><br>
> Yup, absolutely... we've been a bit slammed working on getting the<br>
> project up and running, but everything is checked in to GitHub... just<br>
> needs a bit of clean up, that's all.<br>
><br>
> Best,<br>
> -jay<br>
><br>
> On 02/16/2012 07:10 AM, Alexis Richardson wrote:<br>
> > It would be great to see the cookbooks if they are available, since<br>
> > others doing that setups might want such a thing.<br>
> ><br>
> ><br>
> ><br>
> > On Thu, Feb 16, 2012 at 11:51 AM, Jay Pipes<<a href="mailto:jaypipes@gmail.com">jaypipes@gmail.com</a><br>
> <mailto:<a href="mailto:jaypipes@gmail.com">jaypipes@gmail.com</a>>> wrote:<br>
> >> FWIW, we're using DRBD + pacemaker in active/passive setups for<br>
> both the<br>
> >> MySQL and RabbitMQ setup in the trystack.org (the artist<br>
> formerly known as<br>
> >> FreeCloud) project, and it's working quite well and is pretty<br>
> simple to set<br>
> >> up. Nati Ueno could give some more details on the setup and the Chef<br>
> >> cookbooks used...<br>
> >><br>
> >> Best,<br>
> >> -jay<br>
> >><br>
> >> On 02/16/2012 03:46 AM, i3D.net - Tristan van Bokkem wrote:<br>
> >>><br>
> >>> Any more thoughts about this subject? Ask? Vish?<br>
> >>><br>
> >>> Best regards,<br>
> >>><br>
> >>> Tristan van Bokkem<br>
> >>> Datacenter Operations<br>
> >>><br>
> >>> Contact:<br>
> >>> E-mail Personal: <a href="mailto:tristanvanbokkem@i3d.net">tristanvanbokkem@i3d.net</a><br>
> <mailto:<a href="mailto:tristanvanbokkem@i3d.net">tristanvanbokkem@i3d.net</a>><br>
> >>> <mailto:<a href="mailto:tristanvanbokkem@i3d.net">tristanvanbokkem@i3d.net</a> <mailto:<a href="mailto:tristanvanbokkem@i3d.net">tristanvanbokkem@i3d.net</a>>><br>
> >>> E-mail Support: <a href="mailto:info@i3d.net">info@i3d.net</a><br>
> <mailto:<a href="mailto:info@i3d.net">info@i3d.net</a>><mailto:<a href="mailto:info@i3d.net">info@i3d.net</a> <mailto:<a href="mailto:info@i3d.net">info@i3d.net</a>>><br>
> >>> E-mail NOC: <a href="mailto:noc@i3d.net">noc@i3d.net</a> <mailto:<a href="mailto:noc@i3d.net">noc@i3d.net</a>><mailto:<a href="mailto:noc@i3d.net">noc@i3d.net</a><br>
> <mailto:<a href="mailto:noc@i3d.net">noc@i3d.net</a>>><br>
> >>> Website: <a href="http://www.i3d.net" target="_blank">http://www.i3d.net</a> Office:<br>
> >>> Interactive 3D B.V.<br>
> >>> Meent 93b<br>
> >>> 3011 JG Rotterdam<br>
> >>> The Netherlands<br>
> >>><br>
> >>> Visit www.smartdc.net – SmartDC is our in-house 36,000 sq. ft.<br>
> >>> datacenter in Rotterdam, The Netherlands. High density hosting –<br>
> >>> multiple fiber carriers in-house – Level3 PoP.<br>
> >>><br>
> >>> Interactive 3D (i3D.net) is a company registered in The<br>
> Netherlands at<br>
> >>> Meent 93b, Rotterdam. Registration #: 14074337 - VAT # NL<br>
> >>> 8202.63.886.B01. Interactive 3D (i3D.net) is CDSA certified on<br>
> content<br>
> >>> protection and security. We are ranked in the Deloitte<br>
> Technology Fast<br>
> >>> 50 as one of the fastest growing technology companies.<br>
> >>><br>
> >>><br>
> >>><br>
> ------------------------------------------------------------------------<br>
> >>> *From:* Alexis Richardson [mailto:<a href="mailto:alexis@rabbitmq.com">alexis@rabbitmq.com</a><br>
> <mailto:<a href="mailto:alexis@rabbitmq.com">alexis@rabbitmq.com</a>>]<br>
> >>> *To:* Major Hayden [mailto:<a href="mailto:major.hayden@rackspace.com">major.hayden@rackspace.com</a><br>
> <mailto:<a href="mailto:major.hayden@rackspace.com">major.hayden@rackspace.com</a>>]<br>
> >>> *Cc:* i3D.net - Tristan van Bokkem<br>
> [mailto:<a href="mailto:tristanvanbokkem@i3d.nl">tristanvanbokkem@i3d.nl</a> <mailto:<a href="mailto:tristanvanbokkem@i3d.nl">tristanvanbokkem@i3d.nl</a>>],<br>
> >>> <<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a>>><br>
> >>> [mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a>>], Ask Solem<br>
> >>> [mailto:<a href="mailto:ask@rabbitmq.com">ask@rabbitmq.com</a> <mailto:<a href="mailto:ask@rabbitmq.com">ask@rabbitmq.com</a>>]<br>
> >>> *Sent:* Tue, 14 Feb 2012 14:47:13 +0100<br>
> >>> *Subject:* Re: [Openstack] Howto Nova setup with HA?<br>
> >>><br>
> >>><br>
> >>> Major,<br>
> >>><br>
> >>> The current set-up of HA in Openstack is borked in several ways.<br>
> >>><br>
> >>> Ask Solem, cc'd, is going to write up a note helping people to<br>
> do it<br>
> >>> properly.<br>
> >>><br>
> >>> alexis<br>
> >>><br>
> >>><br>
> >>> On Tue, Feb 14, 2012 at 1:34 PM, Major Hayden<br>
> >>> <<a href="mailto:major.hayden@rackspace.com">major.hayden@rackspace.com</a><br>
> <mailto:<a href="mailto:major.hayden@rackspace.com">major.hayden@rackspace.com</a>><mailto:<a href="mailto:major.hayden@rackspace.com">major.hayden@rackspace.com</a> <mailto:<a href="mailto:major.hayden@rackspace.com">major.hayden@rackspace.com</a>>>><br>
> wrote:<br>
> >>> > On Feb 14, 2012, at 2:07 AM, i3D.net - Tristan van Bokkem wrote:<br>
> >>> ><br>
> >>> >> So, we can run MySQL in master-master mode on multiple hosts, we<br>
> >>> can run nova-api on serveral hosts and load balance those and<br>
> >>> RabbitMQ has a cluster ha setup as well but is this the way to<br>
> go? I<br>
> >>> can't find a clear answer to this. I am hoping one can shine some<br>
> >>> light on this!<br>
> >>> ><br>
> >>> > If you want to make things a little simpler, an active/passive<br>
> >>> MySQL setup with pacemaker, corosync, and DRBD will work quite<br>
> well.<br>
> >>> ClusterLabs has a pretty decent howto on their site:<br>
> >>> ><br>
> >>> > <a href="http://www.clusterlabs.org/wiki/DRBD_MySQL_HowTo" target="_blank">http://www.clusterlabs.org/wiki/DRBD_MySQL_HowTo</a><br>
> >>> ><br>
> >>> > As for RabbitMQ clustering, I worked with it for several days and<br>
> >>> had quite a few problems with data consistency and availability. We<br>
> >>> eventually settled on the "legacy" H/A method for RabbitMQ using<br>
> >>> pacemaker and DRBD. There's a pretty good walkthrough on RabbitMQ's<br>
> >>> site:<br>
> >>> ><br>
> >>> > <a href="http://www.rabbitmq.com/pacemaker.html" target="_blank">http://www.rabbitmq.com/pacemaker.html</a><br>
> >>> ><br>
> >>> > --<br>
> >>> > Major Hayden<br>
> >>> > _______________________________________________<br>
> >>> > Mailing list: <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >>> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >>> > Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a>><br>
> >>> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a>>><br>
> >>> > Unsubscribe : <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >>> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >>> > More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
> >>><br>
> >>><br>
> >>><br>
> >>><br>
> >>> _______________________________________________<br>
> >>> Mailing list: <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >>> Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a>><br>
> >>> Unsubscribe : <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >>> More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
> >><br>
> >><br>
> >> _______________________________________________<br>
> >> Mailing list: <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >> Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a>><br>
> >> Unsubscribe : <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> >> More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
><br>
> _______________________________________________<br>
> Mailing list: <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> <mailto:<a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a>><br>
> Unsubscribe : <a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/~openstack</a><br>
> <<a href="https://launchpad.net/%7Eopenstack" target="_blank">https://launchpad.net/%7Eopenstack</a>><br>
> More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
><br>
</blockquote><style>
</style>
</body></html>