Скачать или смотреть MySQL as a Layered Service: How to use Proxy SQL to Control Traffic and Scale Out

René Cannaò, Founder at ProxySQL, delivers his keynote “MySQL as a Layered Service: How to use Proxy SQL to Control Traffic and Scale Out” on Day 1 of the Percona Live Open Source Database Conference Europe, September 26 2017 in Dublin, Ireland.

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.