title

text

Dmitry Cremer
Dmitry Cremer МИА "Россия Сегодня"
15:00 06 February
22 мин

Cases for monitoring & troubleshooting at highload PosgreSQL DB

A database is one of the key components in any information system, requiring the monitoring of multiple metrics. The talk highlights examples and approaches of monitoring and analysis of PostgreSQL performance that allow to minimize the load on the database server from the monitoring and data collection system for the subsequent analysis of problem situations.

  • Quantum effects or as an observer affect the observed system
  • Features of collecting metrics while monitoring the database with Zabbix
  • Data collection for analytics and visualization PostgreSQL queries with rsyslog + kafka + clickhouse + grafana
  • Operational Analysis Tools for DB loglile

Слайды

Видео

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

  • Maksim Sobolevsky
    Maksim Sobolevsky JetBrains
    45 мин

    DataGrip: PostgreSQL IDE from JetBrains

    For over 15 years JetBrains have strived to make effective developer tools. IntelliJ IDEA for java is the most popular of them. IntelliJ supports databases as well, and finally we in JetBrains decided to bring this functionality and our experience in programming languages to the world of SQL. That’s how DataGrip appeared. In my talk I will tell how DataGrip helps developers by automating routine checks and corrections and speeds up developer’s production. I will also show how to extend IDE’s functionality and try to understand which actual problems we can solve in future.

  • Дмитрий Шитов
    Дмитрий Шитов ООО "ЦТП"
    22 мин

    How I Met Your Linux

    What is a real cost of not paying for Windows for 1C-user? Is there life without COM? Addressing and other issues for the bunch of PostgreSQL. Scheduling disk resources. How to overcome OS CentOS crash.

  • N
    Nik Larin Microsoft
    45 мин

    Azure Database for PostgreSQL - Global scalable managed cloud service

    Azure Database for PostgreSQL is a managed database service built for developers using the community PostgreSQL database technology you love. Learn how you can leverage the managed service and the key capabilities that the service offers which enables you as a developer to focus on developing apps. Using customer stories and experiences including live demos, we will walk through best practices and demonstrate how this service integrates with the other Azure services.

  • Dmitriy Sarafannikov
    Dmitriy Sarafannikov Яндекс
    45 мин

    How to save statistics during major update, and what can be the consequences

    It's not a secret for anyone that statistics can not be transferred with a major upgrade. For small and not heavily loaded databases this is not a problem, you can quickly collect new statistics. But we have databases with a volume of about 5TB and a load of about 100k rps, for which it became a big problem: taking off without statistics, the replicas could not even replay WAL. In my report I'll tell you what tricks we went to upgrade these databases with requirements of 100% read only availability, about what mistakes were made, and about how these errors were painfully corrected. The result of these errors was the extension called "pg_dirty_hands", in which we will collect various hacks, which can be last resort to repair data corruption.