>It would be easier if all databases were hosted by a single instance >of MySQL -- then you could use Tomcat-pool's feature of being able to >provide credentials when obtaining connections from the pool -- and >get the right database. That way, a much smaller number of connections >could be maintained with roughly the same semantics. Can you expand on how I could do this?
Thanks for the insights. I think in reality there would be multiple databases per server. For example, when I purchase shared hosting, you can query for all the databases and you can see there are hundreds of db's for each customer. If a customer's traffic is high enough, I could move them to another server. Also, seeing as 2GB would be required, and the file handler issue, I was thinking one could segment sites into clusters, so each cluster would be responsible for n number of websites (thus reducing the # of pools required per application server). On Thu, May 31, 2012 at 2:56 AM, Pid * <p...@pidster.com> wrote: > On 31 May 2012, at 00:49, Christopher Schultz > <ch...@christopherschultz.net> wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > André, > > > > On 5/30/12 6:18 PM, André Warnier wrote: > >> Taking the same hypothetical case and figures : > >> > >> Assuming that you need a total of (10000 * 4 connections) = 40000 > >> connections. Assuming that it takes 10ms to set up one such > >> connection, and that once it is there, you don't do anything with > >> it and just let it be for now. Assuming we ignore such things like > >> bandwidth, other things happening on that host etc.. It then takes > >> a total of (10 ms * 40000) = 400000 ms = 400s = ~ 6.5 minutes just > >> to set up these connections. > >> > >> Is that acceptable ? > >> > >> What I mean is that once you start playing with such numbers, you > >> may want to look at other aspects than just required memory.. > > > > There's also the issue of open filehandles, etc. My development > > environment is limited to 10240 filehandles per process (though of > > course that can be changed). Opening 10,000 connections would use most > > of those, leaving very few left to accept incoming requests from > > clients, etc. > > Ah, beat me to it. > > > p > > > It would be easier if all databases were hosted by a single instance > > of MySQL -- then you could use Tomcat-pool's feature of being able to > > provide credentials when obtaining connections from the pool -- and > > get the right database. That way, a much smaller number of connections > > could be maintained with roughly the same semantics. > > > > - -chris > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG/MacGPG2 v2.0.17 (Darwin) > > Comment: GPGTools - http://gpgtools.org > > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > > > iEYEARECAAYFAk/GsecACgkQ9CaO5/Lv0PC7HACeNXMp5KZpAHGfhK73/MPFcGOn > > eIwAoJ7g4P/Nz2DBgNHBhwkq0jO3HMCu > > �CE > > -----END PGP SIGNATURE----- > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > > For additional commands, e-mail: users-h...@tomcat.apache.org > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >