0

This is for SaaS app (currently in MySQL-InnoDB). Each app contains about 150 tables. The database size is not big, but the number is high.

For each database, InnoDB create directory in /var/lib/mysql. Because too many database, I choose to have individual database per app to prevent file system bottleneck (Performance degrading badly if too many files/directories exist under a directory).

I will upgrade once it reach 5000 databases.

I need to know if MariaDB cluster or MySQL cluster able to deal with 10 millions database or more, or is there any other solution?

asked Aug 24, 2017 at 16:37

2 Answers 2

0

10 million databases is too many to have in one cluster and will likely hit a bunch of internal limits and be unable to balance workloads. You should look into containerizing the databases so you have one small DB associated with each client.

answered Aug 24, 2017 at 16:45
0

150*5000 is a lot of tables.

table_open_cache may be too low. And there may be other issues. If you would like further analysis, follow the instructions here.

10M databases is implemented as 10M subdirectories in a single parent directory. The OS, not MySQL, will probably croak.

answered Aug 25, 2017 at 5:57

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.