MariaDB Connectors: Fast and Smart with the new protocol optimizations
You optimize your database and queries, but the application is still slow. Have you ever been in this situation? We have seen the cases when the client-server protocol itself becomes the bottleneck, forcing your application and the database to exchange useless bits of service information instead of sending your valuable data as fast as it could. As if you were buying bread — one slice at a time, and bringing every slice home, before going for the next one. We have worked to remove this bottleneck in MariaDB. Protocol enhancements in the new MariaDB Server releases provide new optimization opportunities for the client, and new MariaDB Connectors use them to optimize your communication with the server and drastically reduce the number of round-trips. On this talk you will learn about client-server protocol enhancements in the latest MariaDB Server releases and the corresponding optimizations in MariaDB Connectors. Some of them work automatically, others need to be enabled or used explicitly via a dedicated API. This talk will show you how to do it.
Board Member, MariaDB Foundation
Sergei was a MySQL developer since 1998. From 1999 to 2009 in MySQL AB, Sun, then in Monty Program AB and SkySQL/MariaDB Corporation on MariaDB. During these years he has touched almost every part of the server. To list a few projects – fulltext search, XA, HANDLER, precision math library, parallel repair and bulk inserts in MyISAM, indexes in MERGE, pluggable authentication, password validation, encryption. Sergei is a primary architect of the plugin API and an author of the “MySQL 5.1 Plugin Development” book. Sergei was the MySQL Security Coordinator during all his time in MySQL AB and Sun Microsystems, and now is doing the same in MariaDB.