Who are you? The history of MySQL and MariaDB authentication protocols from 1997 to 2017

MySQL 3.20 to 4.0

In the good old days, when 32MB of RAM justified the name my-huge.cnf, when nobody knew Google and Facebook didn’t even exist, security was… how do I put it… kind of cute. Computer viruses didn’t steal millions and didn’t disrupt elections — they played Yankee Doodle or told you not to play with the PC. People used telnet and ftp, although some security conscious admins already knew ssh.

Somewhere around this time, give or take a few years, MySQL was born. And it had users, who had to be kept away from seeing others’ data, but allowed to use their own. …

2017 Developers (Un)Conference, New York

The 2017 MariaDB Developers Conference is crossing the ocean this year, and will be taking place in New York, from 9 to 10 April.

The unconference will last for two days and you can join for the whole time, or as little time as you wish.

The schedule of this unconference will be drafted in a public spreadsheet. Initially, anyone attending can help set the schedule by adding sessions, as well as voting for sessions they’re interested in, by incrementing the vote counter. Based on this, the schedule will be drawn up.

BNY Mellon are kindly hosting this years event. …

2016 MariaDB Developers Meetup Presentations

I’ve collected slides and videos from several of the presentations given at the MariaDB Developers Meetup in Amsterdam, 6-8 October 2016. This meetup was kindly hosted by Booking.com. The presentations are listed here in roughly the order they were given. If I have both the slides and video for a given talk I link to both, otherwise I just link to what I have. The video is of poor quality as it was livestreamed to Periscope from a handheld mobile phone. Network issues also mean the streams sometimes dropped and had to be restarted. I will update this post as a receive slide decks from other speakers. …

Thoughts on MariaDB Server 10.3 from MariaDB Developers Meeting in Amsterdam, part 1

I had the honor of leading a session on Saturday, during the MariaDB Developers Meeting in Amsterdam, brainstorming around MariaDB Server 10.3. It’s definitely time to do that since MariaDB Server 10.2 has entered beta stage. In case you have missed that, I’ve wrapped up what’s included in 10.2 so far in a blog post on my employer’s site. In addition to the features mentioned in that blog post there are a couple of features still coming in 10.2 of which the most notable is that the MyRocks engine will be included. More about this later in another article. …

2016 MariaDB Developers Meetup

The 2016 MariaDB Developers Meetup will be taking place in Amsterdam, from 6 – 8 October.

The meetup will last for three days and you can join for the whole time, or as little time as you wish.

The schedule of this unconference will be drafted in a public spreadsheet. Initially, anyone attending can help set the schedule by adding sessions, as well as voting for session’s they’re interested in, by incrementing the vote counter. Based on this, the schedule will be drawn up.

The event venue and lunches are sponsored by Booking.com. …

MariaDB in Google Summer of Code 2016

And for the fourth year in a row, MariaDB Foundation participates in the Google Summer of Code! The MariaDB Organization in GSoC is an umbrella organization for all projects that belongs to the MariaDB ecosystem, be it MariaDB Server, MariaDB Connectors, or MariaDB MaxScale. The complete list of our suggested project ideas is in MariaDB Jira. This year we were granted 10 student slots (as compared to 8 last year, 5 in 2014, and 3 in 2013). And it was good, as applicants this year were exceptionally strong. Our students have chosen these projects:

For the server:

  • MDEV-7773 Aggregate Stored Functions
  • student: Varun Raiko, mentors: Sanja Byelkin and Vicențiu Ciorbaru

  • MDEV-8947 Cassandra connector support for 2.x
  • student: Charles Muurmu, mentor: Sergey Petrunia
    blog: https://cassandrastorageenginev2.wordpress.com/

  • MDEV-4989 Support for GTID in mysqlbinlog
  • student: Becca Tucker, mentors: Lixun Peng and Colin Charles

  • MDEV-9711 NO PAD collations
  • student: Daniil Medvedev, mentor: Alexander Barkov

  • MDEV-9197 Pushdown conditions into non-mergeable views/derived tables
  • student: Galina Shalygina, mentors: Igor Babaev and Sergey Petrunia
    blog: http://gsocmariadbshagalla.blogspot.ru/

  • MDEV-371 Unique indexes for blobs (server-side implementation) and adaptive hashing for generated hash
  • student: Sachin Setiya, mentor: Sergei Golubchik

  • MDEV-371 Unique indexes for blobs (in MyISAM, Aria, InnoDB, and XtraDB)
  • student: Shubham Barai, mentors: Jan Lindström and Sergei Golubchik

For the MariaDB Connector/C:

For the MariaDB MaxScale:

For the Master High Availability Manager for MySQL:

Many projects have two mentors to ensure that the student always gets a quick answer to his questions and someone is always available to help even if one of the mentors is, for example, on vacations. …

MariaDB meetup in Helsinki on March 17th

If you are in Helsinki on Thursday next week March 17th, join us for the MariaDB meetup at Solinor. MariaDB team members will present the latest on MariaDB 10.1, MaxScale and MariaDB’s future roadmap.

On stage Rasmus Johansson VP Engineering, MariaDB Corporation and Johan Wikman & Markus Mäkelä, developers of MaxScale.

See the meetup page for the agenda and registration:
http://www.meetup.com/Helsinki-MySQL-User-Group/events/229338790/

Eating our own dog food – Running JIRA on MariaDB

A couple of weeks ago we announced that we were moving from a hosted instance of JIRA to our self hosted instance. The main reason was that we hit 2000 active users in the hosted instance of JIRA and that is the upper limit that it  supports. We obviously wanted to allow more people to be active in reporting and commenting on bugs and features for MariaDB. That’s why we set up our own instance, which now is up and running at jira.mariadb.org.

Thank you Atlassian, the company behind JIRA, for providing the hosted instance of JIRA for the MariaDB project over the last three years! …