Past, Present and future of MySQL and variants Part 1: Ghosts of MySQL Past

You can watch the video of my 2014 talk here:

But let’s talk about things in blog form rather than video form :)

Back in 1979, there was UNIREG. A text UI to records (rows) in a database (err, table). The reason I mention UNIREG is that it had FoRMs which as you may have guessed by my capitalization there is where the FRM file comes from.

In 1986, UNIREG came to UNIX. That’s right kids, the 80×24 VT100 interface to ISAM (Index Sequential Access Method – basically rows are written in insert order and indexes point to them) came to UNIX. There was no generic query language, just FoRMs and reports. In fact, to this day, that 80×24 text interface is stored in the FRM file by MySQL and never ever used (I’ve written about this before).

Then there was this mSQL thing around the 1990s, which was a small SQL server (with source) but not FOSS. Originally, Monty W plugged in his ISAM engine but it wasn’t quite the right fit… so in 1995, we had MySQL 1.0 and MySQL AB was founded.

Fast forward a bit and in 1996 we had MySQL 3.19 and development continued. It managed to gain features, performance, ports to different operating systems and CPU architectures and, of course, stability.

It wasn’t until the year 2000 that MySQL adopted the GPL. This turned out to be a huge step in the right direction for increased adoption. At the time, this was a huge risk for the company, essentially risking all the revenue of the company on making the software more free.

This was the birth of the dual licensing business model. You see, the client library (libmysql) was also GPL, which meant it was easy to use if your application was also GPL, but if you were going to distribute your application and it wasn’t under a GPL compatible license (there was also a FOSS exception so that things like PHP could use it) then you needed a license.

Revenue from licensing was to be significant throughout the entire history of MySQL AB.

(We’ll continue this in part 2 tomorrow)

8 thoughts on “Past, Present and future of MySQL and variants Part 1: Ghosts of MySQL Past

  1. Pingback: Ghosts of MySQL Past: Part 2 | Ramblings

  2. Pingback: Ghosts of MySQL Past Part 5: The Era of Acquisitions | Ramblings

  3. Hello, I’m a @dblmkt working as a MySQL administrator.
    Personally I translated your posts into Japanese since your posts about MySQL history are interesting. See the website link.
    If you don’t like that, please let me know.
    Thank you for the great posts!

  4. Pingback: Ghosts of MySQL Past, Part 7: PBXT | Ramblings

  5. Pingback: Ghosts of MySQL Past, Part 8: The First Fork. | Ramblings

  6. Pingback: Ghosts of MySQL Past, part 11: Why are you happy about this? | Ramblings

  7. Pingback: Ghosts of MySQL Past, part 11: Why are you happy about this? | InsideMySQL

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.