General questions for multitenant SaaS
Hi,
I have multiple questions:
1. What is structure of Xata - workspace -> clusters -> databases?
2. How many databases can be in one workspace/cluster?
3. How many concurent conn can handle one workspace/cluster? Depend on resources - is there estimation table or its auto scaled?
4. Can be database easily moved between clusters from admin panel or by api?
5. On pricing page i see dedicated clusters are in beta, in docs i see its deprecated, in confused
6. What is recommended approach in Xata for multi db tenant SaaS? One or few (per tier) workspace/s per SaaS and db per each tenant?
Thank you!
3 Replies
A1: A workspace in Xata is your account. It can have multiple databases. By default, each database is hosted on a shared cluster within the chosen region.
A2: On the free tier you are limited by the number of branches (each of which is, effectively, its own database). The limit on the free tier is 10 total branches. Every database has at least one branch. As an example, you could have 3 databases in your workspace. Let's say one database has 2 branches. That means you've used 4/10 branches on the free tier. If you make a new database, you'll have used 5/10. If you make a new branch in one of your databases, you'll have used 6/10, etc.
A3: See https://xata.io/docs/rest-api/limits#rate-limits . On the free tier, this is 15 (6 parallel connections to the primary, 9 read-only to the replicas). This doesn't autoscale.
A4: You can move specific branches from shared clusters to dedicated clusters via the UI. You cannot choose which shared cluster hosts your data in a region.
A5: Dedicated clusters are deprecated. While they can be used at the moment, we do not recommend using them for new applications.
A6: We do not recommend using Xata for a multi-db tenant SaaS.
I hope that answers your questions. Please let me know if there's anything else I can help you with.
help
Can't reach database server at
us-east-1.sql.xata.sh:5432
Please make sure your database server is running at us-east-1.sql.xata.sh:5432.Hi Daniel, can you please provide a bit more detail on how you are connecting to the database? Are you using psql? Please share any connection string you are using with any sensitive information redacted.
You may also find our docs at https://lite.xata.io/docs/postgres#connection-string helpful
Connect to Postgres
Learn how to connect to Postgres directly via the wire protocol