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

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:
https://github.com/cloudfoundry/cf-mysql-release/blob/master/jobs/mysql/spec

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

--
Thank you,

James Bayer