Поиск и устранение проблем при эксплуатации потоковой репликации
Streaming replication has been introduced in 2010 and quickly became one of the most popular features of PostgreSQL. Today, it is hard to imagine PostgreSQL installation without streaming replication. With its stability, high efficiency and ease of configuration one would have thought it is an optimal feature. However, while using it you might sometimes enter murky waters. This often can be resolved by using a combination of built-in and third party troubleshooting tools. In my talk I will provide an overview of these tools and explain how with their help one can diagnose, understand and eliminate problems related to streaming replication. I will also go through the most frequent issues occurring when streaming replication is used and will propose possible solutions. This talk is primarily aimed at DBAs and system administrators who use PostgreSQL in their day-to-day.
VIDEO
Слайды
Другие доклады
-
22 мин
Dmitry Vagin AvitoМониторинг PostgreSQL в Авито, с примерами
A short talk about collecting data and monitoring database workload in Avito. Exporting metrics from stored procedures to Graphite. Collecting and visualizing pg_stat* metrics in Grafana. Case studies.
VIDEO
-
45 мин
Ivan Frolkov Postgres ProfessionalОтчуждаемые таблицы в PostgresPro
With big data threads, even the upload of data to a database can often be problematic – apart from the data upload itself, you need to create indexes, perform VACUUM after the upload for correct Index-only scans, etc. From this talk, you will learn how to avoid most of such problems (if not all of them).
VIDEO
-
45 мин
Jasonysli TencentКак Tenсent использует Postgres XC в платежной системе WeChat
Tencent, based in China, is one of the world's largest companies in the social networking space. This talk discusses how Tencent modified the code of Postgres-XC to meet their internal payment system requirements
-
90 мин
Dmitry Vasilyev Postgres ProfessionalMamonsu - швейцарский нож для управления и мониторинга PostgreSQL
This tutorial shows how to properly monitor PostgreSQL. We will discuss the mamonsu utility, see how to configure it, examine its hidden features and learn how to extend them.