News for hackers. Stuff that matters.

A comment on One million queries per second with MySQL. Parent comment

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.
[ Parent | on HN ]
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…

[ Parent | on HN ]
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.
[ Parent | on HN ]
Re:One million queries per second with MySQL by ithrow on Thursday September 01, 2022 @09:41PM (#32685641)
No, a single database manages multiple customers but the customers are distributed among multiple databases.
[ Parent | on HN ]