Reg Mysql in pivotal cloud with plan 1GB with 400 connections
Dew Agarwal <dew.agarwal@...>
I was looking into the performance of my application in cloud in
Can I get any document on the behaviour of mysql in cloud in multi threaded
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
Thanks in advance.
this email list is about cloud foundry oss, not pivotal commercialtoggle quoted messageShow quoted text
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 . 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.
On Tue, May 19, 2015 at 12:27 AM, Dew Agarwal <dew.agarwal(a)gmail.com> wrote: