[cf-dev] Reg Mysql in pivotal cloud with plan 1GB with 400 connections

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[cf-dev] Reg Mysql in pivotal cloud with plan 1GB with 400 connections

Dew Agarwal
Hi Team,

I was looking into the performance of my application in cloud in multi-threaded environment.
Can I get any document on the behaviour of mysql in cloud in multi threaded environment.
Specially on number of connections(foreground/backgroud) per instance/ multiple instances using scaling feature etc.

Question: Suppose I have five databases used in my app, and am using 1GB with 400 connection plan of mysql, what should be my max connection pool size supported?

Thanks in advance.

Regards,
D Agarwal

_______________________________________________
cf-dev mailing list
[hidden email]
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev
Reply | Threaded
Open this post in threaded view
|

Re: [cf-dev] Reg Mysql in pivotal cloud with plan 1GB with 400 connections

James Bayer
this email list is about cloud foundry oss, not pivotal commercial software. you can always open a support case at pivotal.io/support for commercial product inquiries.

the pcf mysql product is based on the oss cf mysql [1]. for each bosh deployment of mysql you get a mysql compatible cluster. the cluster uses mariadb and galera for the database nodes. the default configurations for tunable parameters are listed in the spec file:

what those values should be for your deployment and application workloads are going to be highly dependent on what tradeoffs you want to make. the service plan you use should indicate the number of connections available with your plan, and how you configure max connections in your application typically depends on the database access framework you use.

[1] github.com/cloudfoundry/cf-mysql-release

On Tue, May 19, 2015 at 12:27 AM, Dew Agarwal <[hidden email]> wrote:
Hi Team,

I was looking into the performance of my application in cloud in multi-threaded environment.
Can I get any document on the behaviour of mysql in cloud in multi threaded environment.
Specially on number of connections(foreground/backgroud) per instance/ multiple instances using scaling feature etc.

Question: Suppose I have five databases used in my app, and am using 1GB with 400 connection plan of mysql, what should be my max connection pool size supported?

Thanks in advance.

Regards,
D Agarwal

_______________________________________________
cf-dev mailing list
[hidden email]
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev




--
Thank you,

James Bayer

_______________________________________________
cf-dev mailing list
[hidden email]
https://lists.cloudfoundry.org/mailman/listinfo/cf-dev