title

text

Игорь Косенков
Игорь Косенков Postgres Professional
16:30 03 February
90 мин

Deploying a fault-tolerant PostgreSQL cluster on pacemaker

Corosync & pacemaker is a well known solution for creating fault-tolerant clusters. Such clusters can contain 3 working nodes or 2 working nodes and one voting-only node. The cluster can be deployed on physical or virtual servers.

This tutorial will demonstrate the process of installation and tuning of a PostgreSQL fault-tolerant cluster. You will learn that it is not so difficult as seems to be from the first glance.

Материалы к докладу

Слайды

Видео

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

  • Дмитрий Гребенщиков
    Дмитрий Гребенщиков ООО "Диасофт"
    22 мин

    Features of migration of engineering software from Oracle to PostgreSQL

    Migrating engineering software from Oracle to PostgreSQL
    Dmitry will talk about using an automated migrator developed by "Diasoft" company for migrating Russian systems to PostgreSQL.
    Taking the LOOTSMAN engineering software (developed by the ASKON company), we will speak about the key aspects of migration, review possible issues and ways to resolve them, as well as discuss performance optimization methods for migrated stored procedures.

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

    PostgreSQL configuration master class for 1C

    You will have a fascinating journey through PostgreSQL settings. We will talk about that with 1C not so or on the contrary so that under it it is necessary to adjust specially DBMS. We will discuss approaches to testing the speed of 1C. Consider the various options for backup schemes and fault tolerance. In the process, we will compare the speed of 1C on PostgreSQL configured by default with the speed of 1C configured for PostgreSQL. Also, we will create a replica of PostgreSQL, and switch to it the 1C Server "live", see what users will see 1C during this operation. And a separate block will be devoted to Postgres Pro Enterprise Edition, how the use of its advantages affects the speed of 1C.

  • Pavel Stehule
    Pavel Stehule freelancer
    45 мин

    The performance problems related migrations from PL/SQL to PL/pgSQL

    Porting applications from Oracle to Postgres is common work today. Unfortunately it is not without problems. In presentation I'll try to show the basic performance problems related to differences between Oracle and Postgres and PL/SQL and PL/pgSQL.

  • Игорь Косенков
    Игорь Косенков Postgres Professional
    90 мин

    Deploying a fault-tolerant PostgreSQL cluster on pacemaker

    Corosync & pacemaker is a well known solution for creating fault-tolerant clusters. Such clusters can contain 3 working nodes or 2 working nodes and one voting-only node. The cluster can be deployed on physical or virtual servers.

    This tutorial will demonstrate the process of installation and tuning of a PostgreSQL fault-tolerant cluster. You will learn that it is not so difficult as seems to be from the first glance.