SYSTEM DESIGN OF MULTITHREADED WEB SERVER WITH BACKEND DATABASE CONNECTIONS
Lee Kin Seng · 2021
Web server application creates multiple duplicated subprocesses. Each subprocess software threads listen to a dedicated web socket. Server portal subprocess uses shared list to inform clients which web socket to establish connection with. Moreover, it uses shared queue to aggregate the clients’ database queries. When queue has DB queries, multiple DB connection threads will be invoked to read or write data concurrently to the database. When shared queue is empty, shared queue will put the DB connections threads into wait state to idle instead of disconnecting the connections.