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.
Balys is Head of Engineering at Hostinger, the company behind the project 000webhost. Before joining Hostinger, he has been working as a Data Engineer in Rackspace. Balys enjoys learning new things, and holds a degree in Applied Mathematics.