Evaluation of PostgreSQL replication and load balancing implementations
Partio, Mikko (2007-03-22)
Partio, Mikko
Helsingin ammattikorkeakoulu Stadia Helsinki Polytechnic Stadia
22.03.2007
Julkaisu on tekijänoikeussäännösten alainen. Teosta voi lukea ja tulostaa
henkilökohtaista käyttöä varten. Käyttö kaupallisiin tarkoituksiin on kielletty.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:stadia-1177045591-7
https://urn.fi/URN:NBN:fi:stadia-1177045591-7
Tiivistelmä
In this final project the high availability options for PostgreSQL database management system were explored and evaluated. The primary objective of the project was to find a reliable replication system and implement it to a production environment. The secondary objective was to explore different load balancing methods and compare their performance. The potential replication methods were thoroughly examined, and the most promising was implemented to a database system gathering weather information in Lithuania. The different load balancing methods were tested performance wise with different load scenarios and the results were analysed. As a result for this project a functioning PostgreSQL database replication system was built to the Lithuanian Hydrometeorological Service's headquarters, and definite guidelines for future load balancing needs were produced. This study includes the actual implementation of a replication system to a demanding production environment, but only guidelines for building a load balancing system to the same production environment.
Kokoelmat
- Tietotekniikka [51]