MySQL as a Layered Service: How to Use ProxySQL to Control Traffic and Scale Out

Rene Cannao, ProxySQL author and CEO, discussed usage of ProxySQL for traffic control and scaling out at Percona Live Dublin 2017 on September 26, 2017.

Talk abstract is as follows:

The inability to control the traffic sent to MySQL is one of the worse nightmares for a DBA. Scaling out and high availability are only buzz words if the application doesn't support such architectures. ProxySQL is able to create an abstraction layer between the application and the database: controlling traffic at this layer hides the complexity of the database infrastructure from the application, allowing both HA and scale out. The same layer is able to protect the database infrastructure from abusive traffic, acting as a firewall and cache, and rewriting queries.

Transcript

1. MySQL as a Layered Service: How to Use ProxySQL to Control Traffic and Scale Out René Cannaò 26th September 2017 - Dublin
2. 2 Why? • Performance • Efficiency • Manageability • Usability • Availability
3. 3 Why? Vendors create products more efficient and performing New vendors, new storage engines, new algorithms New features Improved or new HA solutions
4. 4 Something is missing APPLICATIONS DATABASES
5. Main motivations empower the DBAs Improves manageability understand and improve performance High performance and High Availability create a proxy layer to shield the database
6. ProxySQL Features (short list) High Availability and Scalability seamless failover firewall query throttling query timeout query mirroring runtime reconfiguration Scheduler Support for Galera/PXC and Group Replication on-the-fly rewrite of queries caching reads outside the database connection pooling and multiplexing complex query routing and r/w split load balancing real time statistics monitoring Data masking Multiple instances on same ports Native Clustering
7. 7 Database as a Service (layered) APPLICATIONS DATABASES + MANAGER(s) DAAS – REVERSE PROXY
8. What ProxySQL is not? It is not a replication manager
9. 9 Database as a Service: not only MySQL APPLICATIONS MySQL DAAS – REVERSE PROXY ClickHouse SQLite ?? ??
10. Try it! Source code on GitHub: https://github.com/sysown/proxysql/ Forum: https://groups.google.com/forum/#!forum/proxysql Tutorials on: http://www.proxysql.com
11. What is ProxySQL? The MySQL data stargate