AWS prescriptive-guidance documentation change
Summary
Restructured FAQ formatting with Q/A labels, updated introduction link, and minor wording refinements
Security assessment
Changes are purely structural/formatting (adding Q/A markdown tags, link updates). No new security content was added, and existing references to row-level security remain unchanged. No vulnerability fixes or security incident responses are evident.
Diff
diff --git a/prescriptive-guidance/latest/saas-multitenant-managed-postgresql/faq.md b/prescriptive-guidance/latest/saas-multitenant-managed-postgresql/faq.md index 6c64e6264..0adf55275 100644 --- a//prescriptive-guidance/latest/saas-multitenant-managed-postgresql/faq.md +++ b//prescriptive-guidance/latest/saas-multitenant-managed-postgresql/faq.md @@ -5,3 +5 @@ -[Documentation](/index.html)[AWS Prescriptive Guidance](https://aws.amazon.com/prescriptive-guidance/)[Implementing managed PostgreSQL for multi-tenant SaaS applications on AWS](welcome.html) - -Which managed PostgreSQL options does AWS offer?Which service is optimal for SaaS applications?Which unique requirements should I consider if I decide to use a PostgreSQL database with a multi-tenant SaaS application?Which models can I use to maintain tenant data isolation with PostgreSQL?How do I maintain tenant data isolation with a single PostgreSQL database that is shared across multiple tenants? +[Documentation](/index.html)[AWS Prescriptive Guidance](https://aws.amazon.com/prescriptive-guidance/)[Implementing managed PostgreSQL for multi-tenant SaaS applications on AWS](introduction.html) @@ -13 +11 @@ This section provides answers to commonly raised questions about implementing ma -## Which managed PostgreSQL options does AWS offer? +**Q.** Which managed PostgreSQL options does AWS offer?**** @@ -15 +13 @@ This section provides answers to commonly raised questions about implementing ma -AWS offers [Amazon Aurora PostgreSQL-Compatible](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.html) and [Amazon Relational Database Service (Amazon RDS) for PostgreSQL](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html). AWS also has a [broad catalog of managed database offerings](https://aws.amazon.com/products/databases/). +**A.** AWS offers [Amazon Aurora PostgreSQL](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraPostgreSQL.html) and [Amazon Relational Database Service (Amazon RDS) for PostgreSQL](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html). [AWS also has a broad catalog of managed database offerings](https://aws.amazon.com/products/databases/). @@ -17 +15 @@ AWS offers [Amazon Aurora PostgreSQL-Compatible](https://docs.aws.amazon.com/Ama -## Which service is optimal for SaaS applications? +**Q.** Which service is optimal for SaaS applications?**** @@ -19 +17 @@ AWS offers [Amazon Aurora PostgreSQL-Compatible](https://docs.aws.amazon.com/Ama -You can use both Aurora PostgreSQL-Compatible and Amazon RDS for PostgreSQL for SaaS applications and all the SaaS partitioning models discussed in this guide. These two services have differences in scalability, crash recovery, failover, storage options, high availability, disaster recovery, backup, and the instance classes available for each option. The optimal choice will depend on your specific use case. Use the [decision matrix](./matrix.html) in this guide to choose the best option for your use case. +**A.** You can use both Aurora PostgreSQL-Compatible and Amazon RDS for PostgreSQL for SaaS applications and all the SaaS partitioning models discussed in this guide. These two services**** have differences in scalability, crash recovery, failover, storage options, high availability, disaster recovery, backup, and the instance classes available for each option. The optimal choice will depend on your specific use case. Use the [decision matrix](./matrix.html) in this guide to choose the best option for your use case. **** @@ -21 +19 @@ You can use both Aurora PostgreSQL-Compatible and Amazon RDS for PostgreSQL for -## Which unique requirements should I consider if I decide to use a PostgreSQL database with a multi-tenant SaaS application? +**Q.** Which unique requirements should I consider if I decide to use a PostgreSQL database with a multi-tenant SaaS application?**** @@ -23 +21 @@ You can use both Aurora PostgreSQL-Compatible and Amazon RDS for PostgreSQL for -As with any data store used with a SaaS application, the most important consideration is the method for maintaining tenant data isolation. As discussed in this guide, there are multiple ways you can achieve tenant data isolation with AWS managed PostgreSQL offerings. Additionally, you should consider performance isolation on a per-tenant basis for any PostgreSQL implementations. +**A.** As with any data store used with a SaaS application, the most important consideration is the method for maintaining tenant data isolation. As discussed in this guide, there are multiple ways you can achieve tenant data isolation with AWS managed PostgreSQL**** offerings. Additionally, you should consider performance isolation on a per-tenant basis for any PostgreSQL implementations. @@ -25 +23 @@ As with any data store used with a SaaS application, the most important consider -## Which models can I use to maintain tenant data isolation with PostgreSQL? +**Q.** Which models can I use to maintain tenant data isolation with PostgreSQL? @@ -27 +25 @@ As with any data store used with a SaaS application, the most important consider -You can use the silo, bridge, and pool models as SaaS partitioning strategies to maintain tenant data isolation. For a discussion of these models and how they can be applied to PostgreSQL, see the section [Multi-tenant SaaS partitioning models for PostgreSQL](./partitioning-models.html) in this guide. +**A.** You can use the silo, bridge, and pool models as SaaS partitioning strategies to maintain tenant data isolation. For a discussion of these models and how they can be applied to PostgreSQL, see the section [Multi-tenant SaaS partitioning models for PostgreSQL](./partitioning-models.html) in this guide. @@ -29 +27 @@ You can use the silo, bridge, and pool models as SaaS partitioning strategies to -## How do I maintain tenant data isolation with a single PostgreSQL database that is shared across multiple tenants? +**Q.** How do I maintain tenant data isolation with a single PostgreSQL database that is shared across multiple tenants? @@ -31 +29 @@ You can use the silo, bridge, and pool models as SaaS partitioning strategies to -PostgreSQL supports a row-level security (RLS) feature that you can use to enforce tenant data isolation in a single PostgreSQL database or instance. Additionally, you can provision separate PostgreSQL databases per tenant in a single instance, or create schemas on a per-tenant basis to achieve this goal. For the advantages and disadvantages of these approaches, see the section [Row-level security recommendations](./rls.html) in this guide. +**A.** PostgreSQL supports a row-level security (RLS) feature that you can use to enforce tenant data isolation in a single PostgreSQL database or instance. Additionally, you can provision separate PostgreSQL databases per tenant in a single instance, or create schemas on a per-tenant basis to achieve this goal. For the advantages and disadvantages of these approaches, see the section [Row-level security recommendations](./rls.html) in this guide.