Db pool and max_connections for clustered instance

cancel
Showing results for 
Search instead for 
Did you mean: 
VS
Active Member II

Db pool and max_connections for clustered instance

We are using enterprise 7.1 version of ACS with mysql DB. We have 6 nodes in cluster and 3 non-clustered nodes for bulk uploading data. So total 9 nodes working under single DB. Each node has 300 DB pool and 150 max threads at tomcat level. What should be max_connection number on the DB side? Should it be over 300 X 9 i.e. 2700+ ? Also will it help to increase tomcat threads on each instance for faster connections and bulk uploads?