ProxySQL : High Availability and High Performance Proxy for MySQL
ProxySQL is an open source proxy for MySQL able to provide HA and high performance with no changes in the application, using several built-in features and integration with clustering software. It is the only proxy for MySQL that scales to the point of supporting hundreds of thousands of concurrent clients and thousands of servers. Some of its features include: - on-the-fly rewrite of queries - caching reads outside the database server - load balancing, connection pooling and multiplexing - complex query routing and read/write split - real time statistics and monitoring - High Availability and Scalability - Seamless failover - Query throttling, timeout and firewall - integration with clustering solution like MHA for planned and/or automatic failover; - support for master-slave setups (MySQL replication) or multi-masters (NDB or Galera) .
MySQL SRE, Dropbox / ProxySQL
René has 10 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 4-5 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle and now as Senior Operational DBA at Blackbird, (formerly PalominoDB). In this period he build an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance.