ProxySQL is a high-performance MySQL proxy with a GPL license. http://www.proxysql.com/ It would be nice to use it for labsdb load balancing/failover, and later maybe for misc or some of the other production services. Implement the essentials to give support to that.
|Resolved||jcrespo||T140788 Labs databases rearchitecture (tracking)|
|Resolved||jcrespo||T141097 Implement a frontend failover solution for labsdb replicas|
|Resolved||jcrespo||T148500 Implement proxysql both for labs and for later production usage|
Script wmf_auto_reimage was launched by jynus on neodymium.eqiad.wmnet for hosts:
The log can be found in /var/log/wmf-auto-reimage/201610250740_jynus_5880.log.
This technically works, the only things missing is having multiple proxysql instances per server and proxy resiliency, but that will be done only when it is needed; resolving this for now.