Global

Database

as a Service

Gülçin Yıldırım Jelínek 

Cloud Services Manager

2ndQuadrant Confidential

What is GDS?

Bundled up best PostgreSQL practices into our cloud service, with high-availability, and 24x7 support by the best PostgreSQL engineers!

 

  • We develop
  • We host
  • We manage
  • We support
  • YOU USE!

2ndQuadrant Confidential

Cloud Providers

  • Single Master
    • Development
    • Test
    • Production
  • Multi Master 
  • AlwaysOn
  • Single Master
    • Development
    • Test
    • Production

2ndQuadrant Confidential

GDS Flavours

2ndQuadrant Confidential

Single Master

  • Development
    • 1 primary database
    • No support
  • Test
    • 1 primary database
    • 1 replica database
    • Gold Support
  • Production
    • 1 primary database
    • 2 replica databases
    • Backups
    • Platinum Support

2ndQuadrant Confidential

Multi Master

  • Bi-Directional Replication with Postgres-BDR 3.0
  • High availability
  • Geographically distributed cluster
  • Zero Downtime Upgrades
    • Different Postgres versions
  • Flexibility
    • Different configuration
    • Different instance sizes (CPU, disk, memory etc)

2ndQuadrant Confidential

physical rep.

bi-directional replication

subcluster a

subcluster b

geo cluster

Multi Master Architecture

physical rep.

2ndQuadrant Confidential

AlwaysOn

  • Provides at least 4 Nines (99.99%) availability
  • Deployed in single region with two different availability zones:
    • 2 BDR primary
    • 2 physical replica
    • Backup
  • “Very High Availability” described in the BDR whitepaper.

2ndQuadrant Confidential

AlwaysOn Architecture

M-Lead

M-Shadow

bi-directional replication

physical rep.

2ndQuadrant Confidential

How to Connect to your DB?

  1. Set your database password first
  2. Choose the instance you want to connect
  3. Choose one of the provided connection string types
  4. Connect with your db client

2ndQuadrant Confidential

Database Configuration

Search parameter name

2ndQuadrant Confidential

BDR Configuration

2ndQuadrant Confidential

Monitoring Metrics

  • General overview: active connections, deadlocks, disk usage
  • System metrics: memory usage, CPU usage
  • Database metrics: commits/rollbacks, sessions, cache hit ratio, table size
  • Query metrics: long-running transactions
    • Order by total time, calls, CPU usage
    • Display the individual query
  • Replication metrics:
    • Replication state (i.e streaming)
    • Synchronization state (i.e async)
    • Replication slot type (i.e physical, logical)
    • Replication lag in milliseconds and bytes
  • ​Backup metrics

2ndQuadrant Confidential

Monitoring Dashboard

Database metrics: DB size, table sizes, cache/hit ratio, db sessions 

Query metrics: Long running queries, most common queries

Replication metrics: Replication status, slot type, replication lag

System metrics: Disk, memory, CPU

2ndQuadrant Confidential

Dynamic Scaling

2ndQuadrant Confidential

Logging

Action log of all clusters

Filter by cluster name

2ndQuadrant Confidential

Benchmarks

TPS

Latency

2ndQuadrant Confidential

Security

SSL connections only

Encrypted Data at Rest

No SUPERUSER 

VPC Peering

IP Whitelisting

Authenticate with 2ndQuadrant SSO

2ndQuadrant Confidential

GDS API

Let's try it!

2ndQuadrant Confidential

Automated Backups

Filter backups by status
and subcluster

2ndQuadrant Confidential

Scheduled Backups

Backup retention

Backup schedule

2ndQuadrant Confidential

Point-in-Time Recovery

Pick a restore point

2ndQuadrant Confidential

Switchover

2ndQuadrant Confidential

Documentation

HTML docs

Interactive API docs

2ndQuadrant Confidential

Feedback

Give Feedback

Attach screenshot

2ndQuadrant Confidential

Admin Panel

2ndQuadrant Confidential

Customized Demo Trial

No fee for the trial period

Preferred Cloud provider

Preferred GDS flavour

Preferred region: US, EU etc

2ndQuadrant Confidential

Pricing

  • Postgres Version: PG 10 and 10+ 
  • Cloud Provider: i.e AWS, UKCloud 
  • Flavour: i.e Single Master, Multi Master
  • Type: i.e Dev, Test, Prod
  • Regions: i.e us-east-1, eu-west-1
  • Cluster information per region

Cluster architecture details

Instance configuration details: i.e CPU, disk, memory 

Estimated cost per month (support costs included!)

2ndQuadrant Confidential

Billing

2ndQuadrant Confidential

Postgres Cloud Manager

2ndQuadrant Confidential

2ndQuadrant Global Database as a Service

By Gülçin Yıldırım Jelínek

2ndQuadrant Global Database as a Service

This talk is prepared for demonstrating the features of 2ndQuadrant's Database as a Service product: GDS.

  • 249