Does my Appian primary datasource need to have a different pool or the same pool as secondary datasources?

Question

By default, the configure script will add a datasource to "appian-mysql-ds.xml" for Appian's primary database. The pool name is set to "MySqlDS" by default. 
 However, according to https://docs.appian.com/suite/help/17.1/Configuring_Relational_Databases.html I should add my business datasource(s) to the same XML file as the one for Appian's primary database. So should these business datasources also have pool name "MySqlDS" or should I have a separate pool for those? And if I'm reusing the "MySqlDS" pool, do I need to keep the "min-pool-size" and "max-pool-size" elements within my business datasource definition, as these would already have been defined by the Appian primary one?

Shyam Bommakanti · Accepted Answer

Use different pool names. Pool name is used by the AS. Not entirely sure if different names is required but I recommend different names. 
 
Also, Business data sources can be configured via admin console. docs.appian.com/.../Appian_Administration_Console.html

Shyam Bommakanti · Answer

JNDI and appian_schema in URL are different. They don't have to be match or unique. JNDI is used by the application server to load the resource and they have to start with jndi/. In custom.properties you have to mention the name you used in the app server so that Appian knows which JDNI to use as it's data source. If you have multiple JNDI they all have to be unique. Application server cannot load 2 JNDI with same name. The appian_schema is the DB name you want to use as your Appian data source. Shoaib said: what should be the name? here ( e.g conf.data.APPIAN_DATA_SOURCE=jndi/AppianDS Shoaib said: custom.properties.dev file, should the data source look like this? conf.data.datasources=appian_schema Do not use conf.data.datasources, that is to add business data sources the old way. The data source defined in tomcat.resource.xml is only for Appian as a platform to use. Use a separate schema for business and add it via admin console: https://docs.appian.com/suite/help/19.2/Appian_Administration_Console.html#data-sources