Decided
We were not happy with the price/performance of Amazon RDS (Aurora) and wanted a high availability setup. In order to keep the price low and be compatible with the MySQL API, we decided to try Percona Xtra DB Cluster. Setup was rather complex but could be automated via Ansible. We now run multiple instances (with separate resource limits) on our servers. Since ProxySQL won't support the "LOAD DATA" statement, we used a HAProxy-HAProxy Setup in tcp-mode, which would also give us transparent SSL encryption without changes in the application. For health-check and monitoring we wrote a small express.js application that sends request to all instances and exports in the Prometheus format.
0 views0