Re:One million queries per second with MySQL
by tiffanyh on Thursday September 01, 2022 @04:57PM
(#32683089)
Sure, but what you are describing is no longer a multi-tenant application/database. It's essentially a single-tenant deployment of your tech stack per customer. Which is not very cost effective.
Re:One million queries per second with MySQL
by sroussey on Thursday September 01, 2022 @05:56PM
(#32683851)
It’s multi tenant —- you have 10,000,000 customers with 1,000,000 each on 10 servers, for example.
Or I don’t understand what you mean…
Re:One million queries per second with MySQL
by staticassertion on Thursday September 01, 2022 @05:34PM
(#32683585)
I would still consider it a multi-tenant system. It's a single database to manage, which distributes your customers using their identity as a partitioning key.
Cross-customer queries will be somewhat slower.