RTT, RTO, RPO and synchronous replication
How does network latency affect performance when using synchronous replication? If a primary node fails, how long will our cluster not be reachable? How much data can be lost? Will there be any anomalies when reading from standby? We are designing our network architecture, give us a minimum RTT value for cluster solution! Many DBAs have to face these issues when designing and implementing cluster solutions. In this short talk we will tell how to quickly estimate RTT, RTO, RPO values, with the help of which Open Source tools one can test cluster solution and experimentally verify the design parameters, which metrics values can be used as a guide in design.
Слайды
Видео
Видео доступно участникам мероприятия, выполнившим вход в личный кабинет
Другие доклады
-
45 мин
Василий Тимощенко ПКТБ-ЦЦТ ОАОExperience of migration a highly loaded system from DB2 for z/OS to PostgresPro in multimaster configuration
The developer shares his experience of migration a highly loaded system in the field of railway transport from IBM DB2 for z/OS to PostgresPro in a multimaster configuration. The main focus is on the nuances of working with a cluster operating in multimaster mode, what problems had to be faced and how to solve them.
-
22 мин
Elena Skvortsova ИТ-ЭкспертизаMigration of high-loaded 1C solutions to Linux/Postgres infrastructure
How to migrate a high-loaded information system based on 1С:Enterprise from MS Windows/MS SQL Server to Linux/PostgreSQL and don't face considerable pains?
We'll share our migration strategies and what was key to its success. We'll talk about projects involving migrations and pay attention to some nuances.
-
22 минMMikhail Maslov Банк ВТБ (ПАО)
Multi-transactions and possible issues with them
In this presentation, we cover multi-transactions, explain when they appear and how they can be monitored and checked. We also tackle the possible issue with multi-transaction ID wraparound and the problem of file absence in pg_multixact/offsets when restoring from a backup.
-
45 мин
Andrey Zubkov Postgres ProfessionalThe new sights of observability in Postgres and PostgresPro databases
In this talk I’ll show some new abilities in postgres observability. There will be Graphana visualization of pg_profile/pgpro_pwr data, manual highlighting of interesting objects in pg_profile/pgpro_pwr reports, further development of extended vacuum statistics in PostgresPro releases and a new session and query tracing technique in pgpro_stats extension