ProxySQL, a performance companion for MySQL databases, joined The IT Press Tour this week in Valletta, Malta. It was a good time to learn more about the solution that accelerates SQL queries and speak with Jesmar Cannao, the COO and co-founder of the company.
Historically the project started in 2013 and the company in 2014 to support developers and users adoption. The company employs around 10 people. The idea came in the mind of Rene Cannao, CEO and co-founder, a well recognized DBA and MySQL expert in the ecosystem. He thought about improving performance with an element positioned in the network between clients and MySQL server operating like a centralized query traffic manager. The slide below illustrates the key MySQL challenges addressed by ProxySQL.
Of course the solution is open source like the DB it works with and supports various topology such as replication, Aurora or Galera.
The network instance supports up to 1 million concurrent client connections with the capability to consolidate these connections into optimized backend queries. It is not limited to local instance but multi-region and multi-cloud architectures with potentially thousands of backend servers. If the database is sharded, ProxySQL routes requests to the right portion, shard or replica. It also is designed to provide some security, failover detection and routes requests accordingly, integration with various clustering flavors and caching for similar queries. In addition to MySQL, ProxySQL is well integrated with MariaDB, Percona Server among others.
So far 40 clients adopted ProxySQL, some of them are pretty famous names in finance and e-commerce, and of course local Malta companies in the gaming/betting industry. The team sells via key partners but also in direct mode and of course leverages the open source community. Key partners means hyperscalers but also MySQL integrators or monitoring or tools like Grafana, Prometheus... Oem is also an investigated path.
Essentially 2 flavors exist with the open source model and an enterprise licensing with premium features, updates and priority support - 24x7 - enabled by a subscription-based pricing. Beyond that, training and support are of course available. On average the 40 clients spend $45k per year.
Choosing ProxySQL appears to be cost effective reducing the need to extend a MySQL instance by growing the server or cluster the instance.
Based on the success of ProxySQL and its good reputation, the team has started to deliver similar model for PostgreSQL. But we'll see where it will go... but for sure they need to be more visible.
0 commentaires:
Post a Comment