Multi-Tenant Architecture: Shared Schema vs Isolated Database, and When to Switch
The shared-schema-with-a-tenant-id approach that got you to your first hundred customers is not the same decision as your thousandth. Here is how we decide.
Usage-based pricing sells well on a pricing page. The metering, reconciliation and dispute-handling behind it is where most implementations quietly fail.
Usage-based pricing is easy to describe in a pitch deck and genuinely hard to implement correctly, because the hard part was never the pricing model — it was building a metering pipeline accurate enough that a customer never has a legitimate reason to dispute their invoice. Get that wrong once with a large account and you spend the next quarter rebuilding trust instead of shipping product.
Teams that skip the reconciliation job find out their metering has drifted only when a customer disputes a bill months later, at which point there is no way to prove which number was right. Build the audit trail before you need it, not after a dispute.
Pure usage-based pricing puts maximum pressure on metering accuracy, because every cent of revenue depends on it being right. A base platform fee plus usage-based overage — the model we recommend by default — gives you room for small metering discrepancies to net out without ever becoming a customer-facing dispute, while still capturing the upside of usage growth.
Billing systems get most of their design attention on the upgrade and new-signup path, and most of their support tickets on the downgrade, pause and cancellation path. Prorated refunds, mid-cycle plan changes and dunning for failed payments are unglamorous and exactly where customers form their lasting opinion of whether your billing can be trusted.
More from the same category.
The shared-schema-with-a-tenant-id approach that got you to your first hundred customers is not the same decision as your thousandth. Here is how we decide.
A hardcoded "admin" and "member" role gets you to your first enterprise deal. It does not survive contact with their security questionnaire.
"We will fix it later" is a real financial decision with a real interest rate. Here is how we actually quantify it for clients.
Thirty minutes with the people who would actually do the work — no discovery deck, no account manager.