multi-master postgresql architectures in...
TRANSCRIPT
![Page 1: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/1.jpg)
Multi-MasterMulti-MasterPostgreSQLPostgreSQLArchitecturesArchitecturesin Cloudin CloudGülçin Yıldırım JelínekGülçin Yıldırım Jelínek 1
![Page 2: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/2.jpg)
select * from me;select * from me;Board of Directors @ Cloud Services Manager @ Main Organizer @ Member @ MSc, Computer & Systems Eng. @ BSc, Applied Mathematics @ Writes on 2ndQuadrant From TurkeyLives in Prague
PostgreSQL Europe2ndQuadrant
Prague PostgreSQL MeetupPostgres Women
TalTechYildiz Technical University
blog
Github: @apatheticmagpie
gulcin 2
![Page 3: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/3.jpg)
AgendaAgendaWhat is Multi-Master?What is Multi-Master?Physical vs Logical ReplicationPhysical vs Logical ReplicationPostgres-BDR Postgres-BDR Multi-Master ArchitecturesMulti-Master ArchitecturesMulti-Master Postgres in Cloud (GDS)Multi-Master Postgres in Cloud (GDS)Our Experience with Cloud PostgresOur Experience with Cloud PostgresConclusionConclusionQuestionsQuestions
3
![Page 4: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/4.jpg)
What is Multi-Master?What is Multi-Master?
Replicate writes between multiple mastersReplicate writes between multiple mastersAsynchronous with conflictsAsynchronous with conflictsConflict-free (consensus)Conflict-free (consensus)
4
![Page 5: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/5.jpg)
Physical vs Logical ReplicationPhysical vs Logical Replication
Replay WALWAL cannot be changed
Bit copy of upstreamAll or nothingSame major version
Can't write to downstream
Logical decoding Extension APIRow changesCommitted changes
Selective replicationCross-versionCan write to all nodes
5
![Page 6: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/6.jpg)
Physical vs Logical ReplicationPhysical vs Logical Replication
6
![Page 7: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/7.jpg)
Postgres-BDRPostgres-BDR
Multi-masterMulti-masterAsynchronousAsynchronousEventually consistentEventually consistent
Does not prevent concurrent writesDoes not prevent concurrent writesOptimistic conflict detection (after commit)Optimistic conflict detection (after commit)Automatic conflict resolutionAutomatic conflict resolution
Used for Logical Replication development in PGUsed for Logical Replication development in PG
7
![Page 8: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/8.jpg)
Multi-Master Architectures - IMulti-Master Architectures - I
Geographically distributed clusterGeographically distributed cluster8
![Page 9: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/9.jpg)
AlwaysOn ArchitectureAlwaysOn Architecture
Multi-Master Architectures - IIMulti-Master Architectures - II
9
![Page 10: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/10.jpg)
AlwaysOn ArchitectureAlwaysOn Architecture
Application
ConnectionRouter
M-Lead
Multi-Master Architectures - IIMulti-Master Architectures - II
9
![Page 11: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/11.jpg)
AlwaysOn ArchitectureAlwaysOn Architecture
Application
ConnectionRouter
Postgres-BDR
M-Lead M-Shadow
Multi-Master Architectures - IIMulti-Master Architectures - II
9
![Page 12: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/12.jpg)
Global Database as a ServiceGlobal Database as a Service
Bundled up best PostgreSQLpractices into our cloudservice, with high-availability,and 24x7 support by the bestPostgreSQL engineers!
We developWe hostWe manageWe supportYOU USE!
10
![Page 13: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/13.jpg)
GDS FlavoursGDS Flavours
11
![Page 14: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/14.jpg)
Single MasterSingle Master
Development1 primary databaseNo support
Test1 primary database1 replica databaseGold Support
Production1 primary database2 replica databasesBackupsPlatinum Support
12
![Page 15: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/15.jpg)
Multi MasterMulti Master
Bi-Directional Replication withPostgres-BDR 3.0High availabilityGeographically distributed clusterZero Downtime Upgrades
Different Postgres versionsFlexibility
Different configurationDifferent instance sizes (CPU,disk, memory etc)
13
![Page 16: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/16.jpg)
physical rep.
bi-directional replication
subcluster a subcluster b
geo cluster
Multi Master ArchitectureMulti Master Architecture
physical rep.
14
![Page 17: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/17.jpg)
AlwaysOnAlwaysOnProvides at least 4 Nines (99.99%)availabilityDeployed in single region with twodifferent availability zones:
2 BDR primary2 physical replicaBackup
“Very High Availability” described inthe BDR whitepaper.
15
![Page 18: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/18.jpg)
AlwaysOn ArchitectureAlwaysOn Architecture
M-Lead M-Shadow
bi-directional replication
physical rep.
16
![Page 19: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/19.jpg)
How to Connect to your DB?How to Connect to your DB?
17
![Page 20: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/20.jpg)
How to Connect to your DB?How to Connect to your DB?
1. Set your database password first2. Choose the instance you want to connect3. Choose one of the provided connection string types4. Connect with your db client
17
![Page 21: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/21.jpg)
How to Connect to your DB?How to Connect to your DB?
1. Set your database password first2. Choose the instance you want to connect3. Choose one of the provided connection string types4. Connect with your db client
17
![Page 22: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/22.jpg)
How to Connect to your DB?How to Connect to your DB?
1. Set your database password first2. Choose the instance you want to connect3. Choose one of the provided connection string types4. Connect with your db client
17
![Page 23: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/23.jpg)
How to Connect to your DB?How to Connect to your DB?
1. Set your database password first2. Choose the instance you want to connect3. Choose one of the provided connection string types4. Connect with your db client
17
![Page 24: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/24.jpg)
How to Connect to your DB?How to Connect to your DB?
1. Set your database password first2. Choose the instance you want to connect3. Choose one of the provided connection string types4. Connect with your db client
17
![Page 25: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/25.jpg)
How to Connect to your DB?How to Connect to your DB?
1. Set your database password first2. Choose the instance you want to connect3. Choose one of the provided connection string types4. Connect with your db client
17
![Page 26: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/26.jpg)
Database ConfigurationDatabase Configuration
18
![Page 27: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/27.jpg)
Database ConfigurationDatabase Configuration
18
![Page 28: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/28.jpg)
Database ConfigurationDatabase Configuration
Search parameter name
18
![Page 29: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/29.jpg)
Monitoring DashboardMonitoring Dashboard
19
![Page 30: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/30.jpg)
Dynamic ScalingDynamic Scaling
20
![Page 31: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/31.jpg)
Dynamic ScalingDynamic Scaling
20
![Page 32: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/32.jpg)
Dynamic ScalingDynamic Scaling
20
![Page 33: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/33.jpg)
Dynamic ScalingDynamic Scaling
20
![Page 34: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/34.jpg)
LoggingLogging
21
![Page 35: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/35.jpg)
LoggingLogging
21
![Page 36: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/36.jpg)
LoggingLogging
Action log of all clusters
21
![Page 37: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/37.jpg)
LoggingLogging
Action log of all clusters
21
![Page 38: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/38.jpg)
LoggingLogging
Action log of all clusters
Filter by cluster name
21
![Page 39: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/39.jpg)
BenchmarksBenchmarks
22
![Page 40: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/40.jpg)
BenchmarksBenchmarks
22
![Page 41: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/41.jpg)
BenchmarksBenchmarks
22
![Page 42: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/42.jpg)
BenchmarksBenchmarks
TPS
22
![Page 43: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/43.jpg)
BenchmarksBenchmarks
TPS
Latency
22
![Page 44: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/44.jpg)
SecuritySecurity
SSL connections only
Encrypted Data at Rest
No SUPERUSER
VPC Peering
IP Whitelisting
Authenticate with 2ndQuadrant SSO
23
![Page 45: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/45.jpg)
Automated BackupsAutomated Backups
24
![Page 46: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/46.jpg)
Automated BackupsAutomated Backups
24
![Page 47: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/47.jpg)
Automated BackupsAutomated Backups
24
![Page 48: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/48.jpg)
Automated BackupsAutomated Backups
24
![Page 49: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/49.jpg)
Automated BackupsAutomated Backups
24
![Page 50: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/50.jpg)
Automated BackupsAutomated Backups
Filter backups by status and cluster 24
![Page 51: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/51.jpg)
Scheduled BackupsScheduled Backups
25
![Page 52: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/52.jpg)
Scheduled BackupsScheduled Backups
25
![Page 53: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/53.jpg)
Scheduled BackupsScheduled Backups
Backup schedule
25
![Page 54: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/54.jpg)
Scheduled BackupsScheduled Backups
Backup schedule
25
![Page 55: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/55.jpg)
Scheduled BackupsScheduled Backups
Backup retentionBackup schedule
25
![Page 56: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/56.jpg)
Point-in-Time RecoveryPoint-in-Time Recovery
26
![Page 57: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/57.jpg)
Point-in-Time RecoveryPoint-in-Time Recovery
26
![Page 58: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/58.jpg)
Point-in-Time RecoveryPoint-in-Time Recovery
Pick time26
![Page 59: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/59.jpg)
DocumentationDocumentation
27
![Page 60: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/60.jpg)
DocumentationDocumentation
27
![Page 61: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/61.jpg)
DocumentationDocumentation
Docs (WiP)
27
![Page 62: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/62.jpg)
DocumentationDocumentation
Docs (WiP)
27
![Page 63: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/63.jpg)
DocumentationDocumentation
Docs (WiP)
Interactive API docs
27
![Page 64: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/64.jpg)
Postgres Cloud ManagerPostgres Cloud Manager
28
![Page 65: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/65.jpg)
ConclusionConclusionPostgres in Cloud is a go!Postgres in Cloud is a go!Multi-Master addsMulti-Master adds new possibilitiesnew possibilitiesIt's possible to createIt's possible to create your own cloudyour own cloudindependent ofindependent of the platformthe platformAutomation enablesAutomation enables easy managementeasy managementPostgres SupportPostgres Support applies to Cloud!applies to Cloud!
29
![Page 66: Multi-Master PostgreSQL Architectures in Clouddialoglar.com/assets/presentations/gulcin_yildirim_jelinek_bdr.pdf · Postgres-BDR 3.0 High availability Geographically distributed cluster](https://reader034.vdocuments.us/reader034/viewer/2022042622/5f86f641ce48e0489e7ac3b3/html5/thumbnails/66.jpg)
Questions?Questions?
Tešekkürler!Tešekkürler!
30