A study of database connection pool in microservice architecture
The growing number of the Internet presents a higher requirement for backend application systems to be designed to handle thousands of user traffic concurrently. Microservice architecture is also in a rising trend which allows each service to scale horizontally by its throughput, and load helps scal...
| Main Authors: | , , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Politeknik Negeri Padang
2022
|
| Subjects: | |
| Online Access: | https://umpir.ump.edu.my/id/eprint/45609/ http://dx.doi.org/10.30630/joiv.6.2-2.1094 |
| _version_ | 1848827464737882112 |
|---|---|
| author | Nur Ayuni, Nor Sobri Mohamad Aqib Haqmi, Abas Ihsan, Mohd Yassin Megat Syahirul Amin, Megat Ali Nooritawati, Md Tahir Azlee, Zabidi Zairi Ismael, Rizman |
| author_facet | Nur Ayuni, Nor Sobri Mohamad Aqib Haqmi, Abas Ihsan, Mohd Yassin Megat Syahirul Amin, Megat Ali Nooritawati, Md Tahir Azlee, Zabidi Zairi Ismael, Rizman |
| author_sort | Nur Ayuni, Nor Sobri |
| building | UMP Institutional Repository |
| collection | Online Access |
| description | The growing number of the Internet presents a higher requirement for backend application systems to be designed to handle thousands of user traffic concurrently. Microservice architecture is also in a rising trend which allows each service to scale horizontally by its throughput, and load helps scale the system efficiently without waste of resources like in the traditional monolithic application system. Among the many strategies to optimize delivery, the database connection pool helps backend systems to access databases efficiently by reusing database connections, thus eliminating the computationally expensive need to open and close connections with new requests. Additionally, database connection pools can help improve applications' connection reliability. This paper aims to determine the most suitable maximum amount of database connections in a microservice setting, where multiple instances of the service are used for scalability and high availability purposes of the system. To tackle the scalability issue and achieve the high availability of our services, we propose running multiple instances of each of our services in production, especially for services that we anticipate would be hit the most during runtime. This allows load balancing of request load between multiple instances and having backup instances to serve HTTP requests when one of the instances is down. The result obtained in this experiment shows that five database connections give the best result in microservice settings as described in our methodology. |
| first_indexed | 2025-11-15T04:01:08Z |
| format | Article |
| id | ump-45609 |
| institution | Universiti Malaysia Pahang |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T04:01:08Z |
| publishDate | 2022 |
| publisher | Politeknik Negeri Padang |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | ump-456092025-09-11T03:27:20Z https://umpir.ump.edu.my/id/eprint/45609/ A study of database connection pool in microservice architecture Nur Ayuni, Nor Sobri Mohamad Aqib Haqmi, Abas Ihsan, Mohd Yassin Megat Syahirul Amin, Megat Ali Nooritawati, Md Tahir Azlee, Zabidi Zairi Ismael, Rizman QA75 Electronic computers. Computer science QA76 Computer software The growing number of the Internet presents a higher requirement for backend application systems to be designed to handle thousands of user traffic concurrently. Microservice architecture is also in a rising trend which allows each service to scale horizontally by its throughput, and load helps scale the system efficiently without waste of resources like in the traditional monolithic application system. Among the many strategies to optimize delivery, the database connection pool helps backend systems to access databases efficiently by reusing database connections, thus eliminating the computationally expensive need to open and close connections with new requests. Additionally, database connection pools can help improve applications' connection reliability. This paper aims to determine the most suitable maximum amount of database connections in a microservice setting, where multiple instances of the service are used for scalability and high availability purposes of the system. To tackle the scalability issue and achieve the high availability of our services, we propose running multiple instances of each of our services in production, especially for services that we anticipate would be hit the most during runtime. This allows load balancing of request load between multiple instances and having backup instances to serve HTTP requests when one of the instances is down. The result obtained in this experiment shows that five database connections give the best result in microservice settings as described in our methodology. Politeknik Negeri Padang 2022 Article PeerReviewed pdf en cc_by_sa_4 https://umpir.ump.edu.my/id/eprint/45609/1/A%20study%20of%20database%20connection%20pool%20in%20microservice%20architecture.pdf Nur Ayuni, Nor Sobri and Mohamad Aqib Haqmi, Abas and Ihsan, Mohd Yassin and Megat Syahirul Amin, Megat Ali and Nooritawati, Md Tahir and Azlee, Zabidi and Zairi Ismael, Rizman (2022) A study of database connection pool in microservice architecture. International Journal on Informatics Visualization, 6 (2). pp. 566-571. ISSN 2549-9904. (Published) http://dx.doi.org/10.30630/joiv.6.2-2.1094 http://dx.doi.org/10.30630/joiv.6.2-2.1094 http://dx.doi.org/10.30630/joiv.6.2-2.1094 |
| spellingShingle | QA75 Electronic computers. Computer science QA76 Computer software Nur Ayuni, Nor Sobri Mohamad Aqib Haqmi, Abas Ihsan, Mohd Yassin Megat Syahirul Amin, Megat Ali Nooritawati, Md Tahir Azlee, Zabidi Zairi Ismael, Rizman A study of database connection pool in microservice architecture |
| title | A study of database connection pool in microservice architecture |
| title_full | A study of database connection pool in microservice architecture |
| title_fullStr | A study of database connection pool in microservice architecture |
| title_full_unstemmed | A study of database connection pool in microservice architecture |
| title_short | A study of database connection pool in microservice architecture |
| title_sort | study of database connection pool in microservice architecture |
| topic | QA75 Electronic computers. Computer science QA76 Computer software |
| url | https://umpir.ump.edu.my/id/eprint/45609/ https://umpir.ump.edu.my/id/eprint/45609/ https://umpir.ump.edu.my/id/eprint/45609/ http://dx.doi.org/10.30630/joiv.6.2-2.1094 |