PostgreSQL High Availability cluster for Enterprise | Vadim Yatsenko, Sergei Kim
Event: PGConf.Russia 2018 - February, 5-7, Moscow, MSU
Talk: PostgreSQL High Availability cluster for Enterprise
Speakers: Vadim Yatsenko, Sergei Kim
Language: English
Details: https://pgconf.ru/en/2018/108507
Site: https://pgconf.ru
Lately, the PostgreSQL is more widely being used for Enterprise. Our company, Ingram Micro Cloud, is one of the first companies that did it. We have been using PostgreSQL for many years as the main DBMS for our products. In our report, we want to tell about the evolution of our High Availability (HA) PostgreSQL cluster. We will tell about how quickly we implemented the solution using pgpool-II, wrote failover scripts, tested Postgres-XL, and came up with unusual configurations of Stolon. We will also cover the problems of load balancing, pooling connections, and backups.