Bro, what should be the pool.max value for a project where 15,000 people log in and spend 20 minutes every day for the SQL connection pool? If pool.max is high but there is not that much usage, could it cause terrible things for the server?
let me ask let say we have 4 nodes and each node has limit connection about 100 concurrent connection then we pool connection to node 1 and exceed per node limits the question is does if node 1 exceeds limit connection then it will distribute/balancing that connection to available node?
Great explanation, thank you
Thanks for watching Giorgos!
Awesome explanation, thank you!
You're very welcome!
Bro, what should be the pool.max value for a project where 15,000 people log in and spend 20 minutes every day for the SQL connection pool? If pool.max is high but there is not that much usage, could it cause terrible things for the server?
let me ask
let say we have 4 nodes and each node has limit connection about 100 concurrent connection
then we pool connection to node 1 and exceed per node limits
the question is does if node 1 exceeds limit connection then it will distribute/balancing that connection to available node?