During the migration we realized that the API…

During the migration we realized that the APIAPI An API or Application Programming Interface is a software intermediary that allows programs to interact with each other and share data in limited, clearly defined ways. relies heavily on Sphinx…if it is not up and running we fallback to MySQLMySQL MySQL is a relational database management system. A database is a structured collection of data where content, configuration and other options are stored. https://www.mysql.com/. FULLTEXT queries which don’t scale and the API stops working. Previously, Sphinx was running on a single, super old server. Since it is apparently somewhat important to the functionality of the API, we how have HA Sphinx, running on 2, newer servers. Failover should happen automagically.

#ha, #sphinx