HA for databases includes three main things, such as replication, failover and load balancing. The multi-master replication scheme is considered. The object-relational database management system (ORDBMS) PostgreSQL is being used as example. Pacemaker is used to provide failover and load-balancing.
Самохин Н.Ю., Булыкина А.Б., Ахмедзянова Р.Р. (науч. рук. Веприцкая В.М.) Providing high-availability for object-relational databases in distributed data centres // Сборник тезисов докладов конгресса молодых ученых. Электронное издание. – СПб: Университет ИТМО, [2019]. URL: https://kmu.itmo.ru/digests/article/223