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
Board of Directors @ PostgreSQL Europe
Cloud Services Manager @ 2ndQuadrant
Main Organizer @ Prague PostgreSQL Meetup
Member @ Postgres Women
MSc, Computer & Systems Eng. @ TalTech
BSc, Applied Mathematics @ Yildiz Technical University
Writes on 2ndQuadrant blog
From Turkey
Lives in Prague
Github: gulcin
Application
Connection Router
Postgres-BDR
M-Lead
M-Shadow
Bundled up best PostgreSQL practices into our cloud service, with high-availability, and 24x7 support by the best PostgreSQL engineers!
physical rep.
bi-directional replication
subcluster a
subcluster b
geo cluster
physical rep.
M-Lead
M-Shadow
bi-directional replication
physical rep.
Search parameter name
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
Action log of all clusters
Filter by cluster name
TPS
Latency
SSL connections only
Encrypted Data at Rest
No SUPERUSER
VPC Peering
IP Whitelisting
Authenticate with 2ndQuadrant SSO
Filter backups by status
and subcluster
Backup retention
Backup schedule
Pick a restore point
HTML docs
Interactive API docs
By Gülçin Yıldırım Jelínek
This presentation is prepared for PGDay Istanbul 2018.
Staff Database Engineer @Xata, Main Organizer @Prague PostgreSQL Meetup, MSc, Computer and Systems Engineering @ Tallinn University of Technology, BSc, Applied Mathematics @Yildiz Technical University