Monday, February 25, 2019

[google-cloud-sql-discuss] Instance per DB or single instance for all DBs?

Hi there,

Can anyone help me figure out what would be better: 
1. Multiple instances, one per DB
or
2. Single large instance which will hold multiple DBs inside

My scenario is similar to Jira Cloud where each customer has his own Jira Cloud server, with its own DB. 
Our product is similar in that way, where each of our customers has their own instance with its own DB. 
Now the question is, will it be better to manage all of the users' DBs in 1 large instance, or to have a DB instance for each customer? 
What would be the cons and pros for the chosen alternative? 
The first thing that came to or minds is backup management - Will we be able to recover a specific customer DB if it resides on the same large instance as all other DBs? We couldn't quite figure that out.

Thanks for helping out,
Yair

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/a62f0ad3-c1b3-46ee-be15-2cb67da0cf79%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment