# Multiple Databases

**URL:** <https://discuss.aerospike.com/t/multiple-databases/4559>\
**Category:** General Discussion\
**Created:** [September 6, 2017, 4:45pm UTC](https://discuss.aerospike.com/t/multiple-databases/4559 "2017-09-06T16:45:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![karansoi](https://avatars.discourse-cdn.com/v4/letter/k/5e9695/32.png) [@karansoi](https://discuss.aerospike.com/u/karansoi)\
**Post date:** [September 6, 2017, 4:45pm UTC](https://discuss.aerospike.com/t/multiple-databases/4559/1 "2017-09-06T16:45:03Z")

</div>

We are building an Inventory management system and an invoicing system that should handle 100s to 1000s of sales per outlet over 10s to 100s of outlets per client. We are looking to handle many clients, small and big running within the same infrastructure, we are going with 1 database per client. We do require to run multiple databases / clients on each server and according to the load would be increasing servers. Because some clients can be doing just a few 100 invoices a year as well. So we do require to have many clients running on each server. How do I handle this because I found that Aerospike has a limit on the number of databases in each cluster. Please advise.

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [September 6, 2017, 11:27pm UTC](https://discuss.aerospike.com/t/multiple-databases/4559/2 "2017-09-06T23:27:03Z")

</div>

Just give them their own group of “sets”. Security/Privileges can be granted at set level.

---

<div class="post-metadata">

**Author:** ![karansoi](https://avatars.discourse-cdn.com/v4/letter/k/5e9695/32.png) [@karansoi](https://discuss.aerospike.com/u/karansoi)\
**Post date:** [September 7, 2017, 3:51am UTC](https://discuss.aerospike.com/t/multiple-databases/4559/3 "2017-09-07T03:51:25Z")

</div>

I also read that there is a limit on the number of sets in a namespace, is what I read right?

---

<div class="post-metadata">

**Author:** ![anushree](https://avatars.discourse-cdn.com/v4/letter/a/e0b2c6/32.png) [@anushree](https://discuss.aerospike.com/u/anushree)\
**Post date:** [September 7, 2017, 11:02pm UTC](https://discuss.aerospike.com/t/multiple-databases/4559/4 "2017-09-07T23:02:03Z")

</div>

Maximum number of namespaces = 32

Maximum number of sets per namespace = 1023

> **[Known Limitations | Aerospike Documentation](https://docs.aerospike.com/guide/limitations.html)**
>
> Known Limitations

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [September 7, 2017, 11:43pm UTC](https://discuss.aerospike.com/t/multiple-databases/4559/5 "2017-09-07T23:43:22Z")

</div>

I’d still come up with some kind of splitting… Small VM’s are relatively cheap.

---

<div class="post-metadata">

**Author:** ![mcoberly](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/mcoberly/32/637_2.png) [@mcoberly](https://discuss.aerospike.com/u/mcoberly)\
**Post date:** [March 14, 2018, 10:02pm UTC](https://discuss.aerospike.com/t/multiple-databases/4559/6 "2018-03-14T22:02:54Z")

</div>

As of Aerospike Server version 4.0:

The maximum number of namespaces in a cluster is 32 for Enterprise.

The maximum number of namespaces in a cluster is 2 for Community.

---

<div class="post-metadata">

**Author:** ![pgupta](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/pgupta/32/2351_2.png) [@pgupta](https://discuss.aerospike.com/u/pgupta)\
**Post date:** [March 16, 2018, 12:59am UTC](https://discuss.aerospike.com/t/multiple-databases/4559/7 "2018-03-16T00:59:31Z")

</div>

Security is Enterprise Edition only AFAIK. N/A in CE.