2 years later ...
OK this sounds like the best approach as it lets you scale things out as
you grow and actually need more servers (then you just have to manage which
database to switch too).
The cons of this approach is that most ORM's don't support this.
On Fri, Jun 1, 2012 at 2:37 PM, Christ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed,
On 5/31/12 9:33 AM, S Ahmed wrote:
>> 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 po
>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 maintai
On 31 May 2012, at 00:49, Christopher Schultz
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 (1 * 4 connections) = 4
>> connections.
On 30 May 2012, at 23:19, "André Warnier" wrote:
>> On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz <
>> ch...@christopherschultz.net> wrote:
> ..
>>>
>>> If my environment and requirements match yours, you'd need 1 *
>>> max_pool_size * 66KiB at peak usage. That's about 640MiB for each
-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 (1 * 4 connections) = 4
> connections. Assuming that it takes 10ms to set up one such
> connection, and
On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz <
ch...@christopherschultz.net> wrote:
..
If my environment and requirements match yours, you'd need 1 *
max_pool_size * 66KiB at peak usage. That's about 640MiB for each
connection you want in 10k pools. For a (uniform) max pool size o
Chris,
Great thanks that is exactly what I was looking for, just to get an idea at
this point.
And yes it was for mysql.
I was thinking one could create a smarter pool, one that created more
connections for sites used more often, and less for others.
Much appreciated.
On Wed, May 30, 2012 at 1
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed,
On 5/29/12 9:29 AM, S Ahmed wrote:
> If my requirement for a hosted application is to give each
> customer a separate instance of mysql, I am curious how feasible
> that would be.
You can certainly do this.
> What is the memory footprint for
