OOW16 talk – MySQL X protocol – Talking to MySQL directly over the Wire

Oracle Open World 2016 has just finished in San Francisco and we are now about to embark on Percona Live Europe in Amsterdam.

I offered a presentation in San Francisco on the MySQL X protocol, the new protocol that Oracle is using to make the DocumentStore work. This new protocol also allow you to send normal SQL queries to it, and it looks like Oracle has plans to use it in more scenarios.

If you’re interested in protocols and how things work you can find my presentation here: http://slideshare.net/sjmudd/mysql-x-protocol-talking-to-mysql-directly-over-the-wire.

Enjoy!

Also I didn’t see you in San Francisco hopefully we’ll get a chance to catch up in Amsterdam.

2016-10-02 I’ll also be doing the same talk in Percona Live Amsterdam on Wednesday 5th October. You can see the schedule here. Other colleagues also have presentations which may be of interest.

Published by

Simon J Mudd

Born in England, I now live in Spain, but spent a few years living in the Netherlands. I previously worked in banking (financial markets) both in IT and as a broker, but IT has always had a stronger influence. Now working at booking.com as a Senior Database Administrator. Other interests include photography, and travel. Simon is married, with two children and lives in Madrid.

2 thoughts on “OOW16 talk – MySQL X protocol – Talking to MySQL directly over the Wire”

  1. “Command pipelining”, “asynchronous” – it is not like the old protocol would force you to be synchronous . You could submit N multiple queries and then wait for N responses. This is actually one of the multiple ways of how MariaDB JDBC does “executeBatch”,since recently

    1. Hi Vladislav,

      I know that MariaDB has offered an asynchronous interface to MySQL for some time and in many ways that’s a very useful enhancement. It would be good to see that same interface exposed in a compatible way by Oracle. Compatibility is really important.

      To be honest I’ve not looked at how the old protocol works but was under the impression that for some things extending it was going to be more complicated than starting a new “more flexible” protocol. The issue doing this brings up however is that you have to “bring everyone over” and doing so with such a large embedded base of users (of whichever flavour/fork of MySQL, and there are many) is going to be pretty hard.

Leave a Reply