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.
Description
Description
Details
Details
Customize query in gerrit
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| 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 |
Event Timeline
Comment Actions
Change 316558 had a related patch set uploaded (by Jcrespo):
New labs::db::proxy role to load balance and failover replicas
Comment Actions
Change 317140 had a related patch set uploaded (by Jcrespo):
proxysql: install mysql-client alongside the proxy for admin
Comment Actions
Change 317140 merged by Jcrespo:
proxysql: install mysql-client alongside the proxy for admin
Comment Actions
Change 316558 merged by Jcrespo:
Create labs::db::proxy role to load balance and failover replicas
Comment Actions
Change 317173 had a related patch set uploaded (by Jcrespo):
proxysql: Setup dbproxy1011 as a test host for labs::db::proxy
Comment Actions
Change 317173 merged by Jcrespo:
proxysql: Setup dbproxy1011 as a test host for labs::db::proxy
Comment Actions
Change 317517 had a related patch set uploaded (by Jcrespo):
proxysql: Fix typos on role
Comment Actions
Change 317542 had a related patch set uploaded (by Jcrespo):
proxysql: Fix process check and user permissions; Fix .my.cnf
Comment Actions
Change 317542 merged by Jcrespo:
proxysql: Fix process check and user permissions; Fix .my.cnf
Comment Actions
Change 317548 had a related patch set uploaded (by Jcrespo):
proxysql: Add firewall to labs role
Comment Actions
Script wmf_auto_reimage was launched by jynus on neodymium.eqiad.wmnet for hosts:
['dbproxy1011.eqiad.wmnet']
The log can be found in /var/log/wmf-auto-reimage/201610250740_jynus_5880.log.
Comment Actions
Change 317762 had a related patch set uploaded (by Jcrespo):
proxysql: Add notrack to firewall
Comment Actions
Completed auto-reimage of hosts:
['dbproxy1011.eqiad.wmnet']
and were ALL successful.
Comment Actions
Change 317764 had a related patch set uploaded (by Jcrespo):
proxysql: fix line separator
Comment Actions
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.