# How to acheive Shared Connection Pool with Multitenant Schema based approach

**URL:** <https://forum.flowable.org/t/how-to-acheive-shared-connection-pool-with-multitenant-schema-based-approach/4924>\
**Category:** Flowable Engine\
**Created:** [November 23, 2019, 5:23am UTC](https://forum.flowable.org/t/how-to-acheive-shared-connection-pool-with-multitenant-schema-based-approach/4924 "2019-11-23T05:23:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kcraghu](https://avatars.discourse-cdn.com/v4/letter/k/da6949/32.png) [@kcraghu](https://forum.flowable.org/u/kcraghu)\
**Post date:** [November 23, 2019, 5:23am UTC](https://forum.flowable.org/t/how-to-acheive-shared-connection-pool-with-multitenant-schema-based-approach/4924/1 "2019-11-23T05:23:15Z")

</div>

Hi,

When ever we register tenant for schema ( using Mysql ), 10 new connection is created. How can I achieve shared connection pool for all the schema together. Please provide with sample.

I want to use 1000 of schema, If it grows exponentially by 10 per schema, it will be pain point for us.

Please assist on this.

Regards,  
Raja

---

<div class="post-metadata">

**Author:** ![joram](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/joram/32/26_2.png) [@joram](https://forum.flowable.org/u/joram)\
**Post date:** [December 4, 2019, 5:26pm UTC](https://forum.flowable.org/t/how-to-acheive-shared-connection-pool-with-multitenant-schema-based-approach/4924/2 "2019-12-04T17:26:21Z")

</div>

That’s currently not possible out of the box. However, you could wrap your own DataSource implementation and change the way connections get handled (but this is a low level kind of thing). We’ve done experimentations in the past here, but nothing yet on master for this.