Managed PostgreSQL instances - BETA

[baaastijn]

THIS ISSUE IS FOR THE BETA PHASE ONLY
For General Availability, please refer to : #124

User story

As a customer,

I want to test and deploy managed PostgreSQL instances in OVH Public Cloud easily
So that I'm sure this service will fit my needs, I will gain time, and focus on my own job.

Acceptance criterias :

I can launch new PostgreSQL instances via control panel / API
Basic management via control panel / API (manage users, manage databases, manage ACL)
Daily backups made by OVHcloud
Pay as you go
Private or Public network
High-Availability

BETA phase limitations

Free during the whole beta phase
Not ready for production.
No SLA will be provided
No official support from OVHcloud. Best effort via Discord Channel : https://discord.com/invite/PwPqWUpN8G

BETA vs GA features gap

Feature	BETA	GENERAL AVAILABILITY
PostgreSQL proposed versions	13	TBD
Basic features (user mgmt, backup, ...)	X
Mono-AZ high-availability	X
Service plan upgrade	X
PostgreSQL version upgrade	X
Database instance Fork	X
Public Network	X
Private Network (vRack)	X but during the beta, not at the beginning
Custom Connection limit	No, will be limited to 200	X
Read replicas		X
Multi-AZ deployments		X
Custom maintenance window		X
Ability to force updates manually		X
Advanced configuration parameters		X

[baaastijn]

Hello, Public Beta is now live in Public Cloud control panel !

feel free to share your feedback here or on https://discord.com/invite/PwPqWUpN8G

[matmicro]

Do you have an ETA for vRack availablility for the BETA ?

Will GRA location be available for BETA ?

Can you provide more details about what multiAZ means ?
Does it means we can have replica in another region ?
Does it means we can have High Availability on 2 datacenters (like Live in GRA and standby in RBX) ?

[baaastijn]

Do you have an ETA for vRack availablility for the BETA ?

Will GRA location be available for BETA ?

Can you provide more details about what multiAZ means ? Does it means we can have replica in another region ? Does it means we can have High Availability on 2 datacenters (like Live in GRA and standby in RBX) ?

ETA for vRAck : no ETA so far, but the beta should last 3 months. it will be during this lap of time.
GRA for BETA : yes, planned
Mono-AZ : all nodes are in the same physical availability zone
Multi-AZ : nodes are distributed at least in 2 availability zones. Yes in mean that you can have replicas in other regions.

an AZ is something autonomous from a network, electric and technical stack perspective.
Multi-AZ can be done when locations are closed enough to meet network requirement (low latency mainly).

In our case we target RBX/GRA but also FR/DE, FR/UK, DE/PL, etc.
but so far it's now planned.

[matmicro]

For the BETA it is mentionned limitation to 200 connections.
Is it 200 connecter per node ? Or for the whole cluster ?
What is the limitation for GA ?

On OVH website, it mentionned possibility to have up to 5000 connections with pooling.
Is that pooling included by default for all flavors ?
Is it for GA only or also testable from beta ?

[baaastijn]

Hello, It's 200 connections for 4GB ram , for the whole cluster. Max 1000. Same for GA. https://docs.ovh.com/gb/en/publiccloud/databases/postgresql/capabilities/#maximum-simultaneous-connections Connection pools will be included in the price and available very soon ! Le dim. 26 déc. 2021 à 14:03, Mat ***@***.***> a écrit :

…

For the BETA it is mentionned limitation to 200 connections. Is it 200 connecter per node ? Or for the whole cluster ? What is the limitation for GA ? On OVH website, it mentionned possibility to have up to 5000 connections with pooling. Is that pooling included by default for all flavors ? Is it for GA only or also testable from beta ? — Reply to this email directly, view it on GitHub <#120 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEBDMRX7K4HOHUJSN4APPKTUS4HBZANCNFSM5DJDUSRA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you modified the open/close state.Message ID: ***@***.***>

[matmicro]

Great, thanks for details about max number of connections.

Any news about vRack availability ? (it was mentionned to be available end of december)
Can you have more precise date when pooling available ?

Many thanks