We are migrating JIRA and Confluence to GCP. Both JIRA and Confluence applications will be running on separate Google cloud compute engine VM instances.
Also, we are planning to use Cloud SQL managed instance for MySQL with HA
Question:
Is it recommended to setup only one HA cluster in cloud SQL and use it for both JIRA and Confluence DB?
i.e. A Cloud SQL cluster running MySQL (Containing two 2 VM instances in cluster)
Two Database schemas:
JIRA Database
Confluence Database
Thanks.
Hi Javish,
Either option is acceptable. Best practices indicate that separate database servers are better because there is far less chance that one compromised app/database will affect the other app/database, but some organizations are willing to accept that risk in lieu of less administrative overhead. A single DB server could also cause problems in the future when an app upgrade requires a database upgrade, but the app that is not being upgraded does not support the new DB version required by the first application. Cheers!
Thanks Joshua! I agree with your reasoning and risk involved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.