← Back to team overview

openstack team mailing list archive

Re: Nova DB Connection Pooling

 

We really need to hear from Sandy Walsh on this thread so he can elaborate on how the distributed scheduling works (with multiple mysql databases).

Devin


On Sep 26, 2011, at 6:41 AM, Soren Hansen wrote:

> 2011/9/26 Pitucha, Stanislaw Izaak <stanislaw.pitucha@xxxxxx>:
>> The pain starts when your max memory usage crosses what you have available.
>> Check http://dev.mysql.com/doc/refman/5.1/en/memory-use.html - especially comments which calculate the needed memory for N connections for both innodb and isam. (mysqltuner.pl will also calculate that for you)
>> 
>> Hundreds of connections should be ok. Thousands... you should rethink it ;)
> 
> Hm.. It doesn't take many racks full of blade servers to get into 4
> digit numbers of compute nodes. Certainly fewer than I was expecting
> to see in a garden variety Nova zone.
> 
> -- 
> Soren Hansen        | http://linux2go.dk/
> Ubuntu Developer    | http://www.ubuntu.com/
> OpenStack Developer | http://www.openstack.org/
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp



Follow ups

References