Provision an Azure managed PostgreSQL DB to demo access from AAW for netezza replacement

[ca-scribner]

In a meeting with RSID/CPD they were open to replacing their Netezza DB with an Azure managed SQL database to reduce cost and maintenance efforts. Let's provision a demo database to:

• show them we can access the data from AAW
• demonstrate how well query performance scales to the TBs of data they use.

Managed PostgreSQL are already approved by security etc, used internally, and just require a few extra lines to an existing Terraform (already checked with Will).

If put into sprint scope, implementation plan is:

• Andrew flesh out details (size, etc)
• Cloud support to implement (~1-2hr)
• Andrew (or other DAaaS member) build a demo workflow using the DB (occasional cloud support probably needed)

[sylus]

I just recommend if you want any sort of decent IOPS for managed db should select at minimum 256GB storage size.

[sylus]

Here is the P.R. for @brendangadd to review:

https://github.com/StatCan/terraform-kubernetes-aks-platform-daaas-private/pull/157

[ca-scribner]

If Brendan gives ok can we do 500GB or 1TB? I think they’ll ask how it does with 1TB or data

On Mon, Jan 4, 2021 at 17:18 William H notifications@github.com wrote:

Here is the P.R. for @brendangadd https://github.com/brendangadd to review:

StatCan/terraform-kubernetes-aks-platform-daaas-private#157 https://github.com/StatCan/terraform-kubernetes-aks-platform-daaas-private/pull/157

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/StatCan/daaas/issues/334#issuecomment-754257072, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALPFPI5EML3INVFDFHOO6VLSYI5DRANCNFSM4VTPNITQ .

[sylus]

@ca-scribner can we launch this? Increase the disk size?

[ca-scribner]

It's all on @brendangadd

I'll be stuck doing something else for next week so can't use till after but I think having a DB up would be great

[sylus]

https://github.com/StatCan/terraform-managed-databases-daaas/pull/2

[sylus]

We launched geomatics but still need permission to launch the RSID one.

[sylus]

@ca-scribner maybe ask Brendan today for this? Want to know status :D P.R. is ready.

[ca-scribner]

Can do. I think the way that netezza effort is going it is less rushed now though. I don’t expect someone is ready to use the DB if we make it in the short term :(

On Thu, Jan 21, 2021 at 12:10 William H notifications@github.com wrote:

@ca-scribner https://github.com/ca-scribner maybe ask Brendan today for this? Want to know status :D P.R. is ready.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/StatCan/daaas/issues/334#issuecomment-764800267, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALPFPI5BB3QB4Z7AKCY727DS3BNZ7ANCNFSM4VTPNITQ .

[brendangadd]

Closing as stale.