Gülçin Yıldırım Jelínek
Staff Database Engineer @Xata, Main Organizer @Prague PostgreSQL Meetup, MSc, Computer and Systems Engineering @ Tallinn University of Technology, BSc, Applied Mathematics @Yildiz Technical University
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?
- Set your database password first
- Choose the instance you want to connect
- Choose one of the provided connection string types
- 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.
