Logical replication internals
The following topics will be covered as part of the presentation:
- Architecture of logical replication
- Publisher introduction
- Subscriber introduction
- Data syncronization introduction
- Logical decoding
- Replication slot
- output plugin
Слайды
PostgreSQL_Internals_of_logical_replication_2023_PGCONF_Russia.pptxВидео
Видео доступно участникам мероприятия, выполнившим вход в личный кабинет
Другие доклады
-
45 мин
Maksim Emelin Postgres ProfessionalUsing Debezium as a tool for delta migration
Delta migration case using Debezium is considered in details as well as the process of change data capture, sinking, applying configurations and load testing.
-
45 мин
Andrey Zubkov Postgres ProfessionalWorkload monitoring extensions pg_profile/ pgpro_pwr. Architecture, setup, features and use cases
The major task of workload monitoring tools is to provide measurable statistics about most resource intensive activities in the DBMS. They can't solve any issues but the points for concentrating optimization efforts can be highlighted. We’ll talk about the extensions pg_profile and pgpro_pwr, their architecture, features and use cases.
-
22 мин
Leonid Churikov СёрчИнформBuilding the protection system based on Postgres DBMS
Why would you need the domestic DBMS? 1. Because of law requirements: only domestic DBMSes are appropriate for data protection. 2. In terms of formalization: currently, it is impossible to purchase MS in Russia legally. 3. In terms of pricing: the licensing mechanism of foreign DBMS systems significantly increases the expenditures on protection. 4. In terms of performance: it depends on the optimization of information protection tools, which are currently developed for domestic DBMS systems (in order to reveal why you may refer to the first paragraph). 5. In terms of practice: by the end of last year we’ve finished transition to the domestic databases and everything works smoothly. What else does an information security officer need?
-
45 мин
Michael Shurutov СтандартПроектA set of Ansible roles for PostgreSQL
There is set of Ansible roles for any Postgres configuration: a standalone instance; a streaming replica; patroni+etcd; stolon+etcd; patroni+consul; stolon+consul. In this talk, we will discuss why using this set of Ansible roles is better than other solutions.