Scaling a million databases on 000webhost

D9958f8c7158fde442c374dab746facb?s=47 Balys
September 26, 2017

Scaling a million databases on 000webhost

000webhost handles millions of user queries on close to million unique databases. In this talk we will present the obstacles we encountered on such scale. We will show why we moved away from the traditional webserver->dbserver to a more dynamic architecture using HAProxy, ProxySQL and MariaDB in LXC containers. We will present our model, query routing logic and the outcome from the collaboration with ProxySQL developer Rene.



September 26, 2017