Chief Architect MariaDB, MariaDB
Sergei was a MySQL developer since 1998. From 1999 to 2009 in MySQL AB, Sun, then in Monty Program AB and SkySQL 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. Sergei is a primary architect of the plugin API and an author of the “MySQL 5.1 Plugin Development” book.
The storage engine family in MariaDB got new members. CONNECT engine allows you connect MariaDB to almost anything and read data in almost any format. Cassandra engine lets you access a Cassandra cluster conveniently and transparently from MariaDB. Sequence engine is small, fast, and completely virtual, but it can be very useful in joins. These and other storage engines will be covered in this... [read more]
It is a common knowledge that in the MySQL world you have to use indexes to optimize your queries. Indexes provide fast access to the data, indexes provide statistics. True, indexes can also be quite expensive to maintain, but what choice do we have? New MariaDB 10.0 optimizer supports storage engine independent statistics tables. Which means that you can have data statistics calculated for all... [read more]
If you're maintaining and old application, you may want or not want to upgrade your database server. But if you start developing something new, you should know what the recent releases are capable of. MariaDB 10.0 is the latest stable branch of MariaDB, with many new features in replication, optimizer, administration, and other areas. This talk will go over everything new that MariaDB 10.0... [read more]