Vasiliy Puchkov
Vasiliy Puchkov ООО
12:10 26 October
45 мин

PostgreSQL cluster for 1C on Astra Linux

Narrow way to four nines. Postgresql clusterin in virtual environment - why's and how's. Why Corosync/Pacemaker? What about backups? Difficulties, problems and how to avoid them.


Пучков Василий - Кластер PostgreSQL на Astra Linux для баз 1С -final.pptx


Видео доступно участникам мероприятия, выполнившим вход в личный кабинет

Другие доклады

  • Mikhail Tsvetkov
    Mikhail Tsvetkov Intel
    45 мин

    PostgreSQL on new Xeon CPUs and Optane Persistent Memory

    Intel® Xeon® Scalable Gen 3 - new commands have been added to speed up the database: vector bit manipulation instructions to enable data compression without losses, vector instructions to make TLS protocols faster and SGX enclaves for secure code execution. We will also discuss the new generation of persistent memory Intel® Optane™ PMem 200 series. We will explain what these new technologies including oneAPI tools can give to the PostgreSQL project community

  • Anton Doroshkevich
    Anton Doroshkevich ИнфоСофт
    45 мин

    Unequal battle with "bloating" in the realities of 1C databases

    Data is getting bigger, disks are getting faster, the DBMS optimizer is getting smarter, but the problem of " bloating " remains extremely relevant. I want to share my experience and approach to dealing with this effect on a large number of tables and data in them.

  • Nikita Levchenko
    Nikita Levchenko ПАО «Ростелеком»
    Yuriy Plotnikov
    Yuriy Plotnikov ООО «РТК ИТ»
    45 мин

    From Oracle to Postgres using Russian rails. Non-obvious nuances

    We'll discuss our approaches to picking technical solutions for the systems we design. We'll consider their advantages and limitations. We'll share the facts about the changes in our engineering culture when import substitution requirements came into effect. We migrated the system with a classical three-tier architecture from Oracle to Postgres Pro DBMS. In my presentation I'll pay attention to data migration tools and peculiarities of development Java/Kotlin apps and SQL interoperability between two DBMSs.

  • Igor Kosenkov
    Igor Kosenkov Postgres Professional
    45 мин

    Building a GEO-Cluster

    Everyone knows very well what a failover cluster PostgreSQL is and how such a cluster protects against failures within the same data center. However, recently, more and more enterprises have placed increased demands on their services, these requirements include disaster tolerance. We call such clusters a GEO-Cluster (KUK). In the report, I will talk about the varieties, principles and approaches to building GEO-Clusters PostgreSQL based on the Corosync/Pacemaker cluster software.