MySQL Time Capsule

Inside MySQL: Sakila Speaks

In this episode, Fred & Scott share their history with MySQL - including when they first started using MySQL and discuss some of their favorite features.

---------------------------------------------------------

Episode Transcript:

00;00;08;15 - 00;00;30;23 Welcome to Inside MySQL Sakila speaks - a podcast dedicated to all things MySQL. We bring you the latest news from the MySQL team, MySQL product updates and insightful interviews with members of the MySQL community. Sit back and enjoy as your hosts bring you the latest updates on your favorite open-source database. Let's get started. 00;00;30;29 - 00;00;56;13 Welcome to Inside MySQL: Sakila Speaks, I am leFred and I'm Scott Stroz. Hi, Scott. So today we start the season two first episode. Am I right? Indeed. And unlike previous episodes, it's just you and me. We don't have a guest. We're going to talk about our experiences using MySQL That's awesome. So, Scott, tell me, how do you came to MySQL and when was it? 00;00;56;20 - 00;01;30;28 I know it was in either late 2001 or early 2002. I had just started a job as a web developer for the company I worked for as a paramedic, previously. So, I switched careers, but I was fortunate enough to stay at the same company and I had no budget. I was I literally had to create. I literally had to build a server out of spare parts in the back room, and I used a LAMP configuration. 00;01;30;28 - 00;01;56;07 So, Linux, Apache, MySQL and PHP, and if I remember correctly, the first version was 3.23 I think was the first version that I used, and I've been using it ever since. I've done most of the work I've done with MySQL has been on personal projects, so any time I've had a little personal project I've done, I've used that. 00;01;56;07 - 00;02;26;14 And there's been a couple of projects, you know, from jobs that I've done, you know, pretty big jobs for like big government agencies that have used it as well. How about you? For me, I was expecting you had started before me, so I would have looked younger, but so I started. But with MySQL the first time I really discovered MySQL without really knowing what it for. 00;02;26;17 - 00;02;57;00 I was already 1997 because I was a fan of Linux and still I am right there. I may be one of the only guys who, before 2000 went to a Linux desktop. Even so, a Linux desktop year was for me a long time ago. And so I remember it's a fun story because I went to a computer shop to buy some games. 00;02;57;03 - 00;03;23;17 I wanted to buy a game, in fact, and the game was just the small floppy disk and it costs and at that time I think it was around what we call thousand Belgium franc before Euro. So, and, and there was this box of five or six CDs called InfoMagic CDs where it was Linux on it. Right. 00;03;23;19 - 00;04;05;07 And and this is I say with the same money I would have more with than a floppy, I will have a full CDs there. And so this is how I started to install the first time Linux on my machine. And it was a bit before 1997, the first InfoMagic. I think it was around 1994 or five, but it was without MySQL at that tie and every year I was buying the new InfoMagic set and there was MySQL 3.20 in beta – in slackware - at the time and this is so I install it the first time and then I started to try to have a look at it. 00;04;05;09 - 00;04;33;03 and as I was doing computing at a computer science job and it was a time of CGI in Perl, I remember I started with something called Sprite and that allows you to write and to SQL on flat the text file. So we were using that to record the, the IP of people visiting to read, counters not to not incremental the day. 00;04;33;06 - 00;05;07;18 And then I switched to MySQL to do that, to have something even better than a flat file. But this was just during the study I would sit and after death, professionally, I met MySQL already around between 2002 to 2004, I guess, and the company I was working in Belgium, we started to work with MySQL AB at the time and I passed the training in 2005. 00;05;07;18 - 00;05;38;01 It was still in MySQL 4.1 exams at the time and we had the core and professional exam and this is how I really jumped in MySQL as a daily work, I would say taking the exam and then doing consulting in Belgium for MySQL. And after that I also worked with the make company, the one I was working for with MySQL AB to provide also training so for MySQL. 00;05;38;01 - 00;05;59;25 So the the usual training of MySQL AB or as some companies in Belgium were basically to be was not able to deliver because there were too many people they wanted in some time in French and Italian at the same time. So it was a bit and this is how I really started to learn and study MySQL. So I really enjoyed that. 00;05;59;27 - 00;06;36;21 But I never end up there. It was this fast, always move forward both. As you know, we also do a conference. You do? We do conferences. I do talks and I really jumped into MySQL community. Meaning then let's hear meeting all these stars of MySQL and stuff in 2010 when I gave my first talk at FOSDEM. 00;06;36;23 - 00;07;02;01 So this was about maintaining too big tables in MySQL. And because I was maintaining big budget business in companies in Belgium, all in MySQL, MySQL was everywhere. So that was very good. And so I go there and this is where I met a lot of people and the community manager at the time in MySQL and plenty of other people. 00;07;02;07 - 00;07;47;04 And this is all I really started jumping in the community of MySQL. For the longest time. I was kind of like a lurker in the community. I didn't really post a lot of questions or answer a lot of questions on the forums, but I spent a lot of time there learning stuff. So, I, like I said, I've been using MySQL for over 20 years now and one of the things I use it for and I've talked about this before in presentations that I've done and I may have even mentioned it on the past episodes, but I manage a golf league, and the golf League grew to the point where we couldn't really like we 00;07;47;04 - 00;08;07;26 used to track everything in an Excel spreadsheet and we couldn't do that anymore because we actually had - we we've grown to 80 golfers. There's 80 golfers in the league. We have 40 that play in one night, 40 that play in another night. And I wrote a web application to help me manage the golf league. I can do scheduling. 00;08;07;28 - 00;08;29;13 There are guys who are responsible for entering the scores, so it tracks people’s scores a calculates their handicaps. It figures out who is in the lead. Okay. And one of the things that used to drive me crazy was I have a stats page where you can look up your stats, you can look up you know, what you've shot in previous rounds. 00;08;29;16 - 00;08;49;28 Which holes do you shoot the better, better on as compared to others. And then it it counts the number of birdies, pars, whatever that you have it gives you a percentage. But it also compares it to everybody else in the league. So, you know, you can say, hey, I birdied 10% of the holes, but the league’s birdied 15%. 00;08;50;01 - 00;09;12;15 And some of those queries used to take a long time and I it wasn't like a ridiculously long wasn't like people were waiting for like minutes for the stats to come up, but it was longer than I thought it should have. And I realized that the solution to that problem was going to be setting up a query that uses common table expressions. 00;09;12;17 - 00;09;42;16 But unfortunately at the time MySQL did not support it and that when I forget what version it was that that CTEs were introduced. But I switched over like immediately, like I got my development environment, I created the queries the way I wanted them. They were actually orders of magnitude faster than what they were. And I was like, Wow, this is like the greatest thing since pockets like that were. 00;09;42;16 - 00;10;07;23 To me, that was like a huge, like change in, in my development attitude of, you know, we have, you know, basically, you know, common table expressions, are kind of pre aggregating data a little bit. And I was like, wow. I, I had them in just one particular place. And I've actually changed a bunch of queries since then to use them because I'm like, wait, I can speed this query up. 00;10;07;25 - 00;10;38;17 And again, it's not the website doesn't get so much traffic where people are going to notice these things. But I noticed that I like I'm like, no this could be faster. And I think for me, for this particular project, adding CTEs was probably the best feature we've added because for me in this particular instance, it added a lot of value to helping speed up queries that were otherwise not very efficient. 00;10;38;19 - 00;11;13;27 Is there something like that for you? So this was MySQL 8. It's what was very what we always say, a big giant leap for a SQL in the most critical system. Right? So MySQL at all this knew I would say new for MySQL features like a windows expression, common table expressions and so on. So just to so on the team, you are the developer guy, so the guy will use MySQL as a developer and the guy more in the sysadmin, DBA path. 00;11;14;02 - 00;11;49;19 So for me, yeah, it's cool to have CTE and Windows function but this is not what for me was a shining for me was an issue on the other side or lower side. Something that for me was like, this is so great. It's for example, the clone plug in, clone plug in. It's amazing when you have to deploy databases because I had to manage the database, not writing the code or sometimes when people were writing code into something better could say, look, we are doing full table scan, please fix this. 00;11;49;21 - 00;12;25;01 And if I knew, I would explain how to fix it. But so this is yeah, all I do. It's a clone. And after that, plenty of other stuff was really what we were looking for in, in MySQL for the operation part. So cloning data, not having to take a back restore through to do the point in time recovery, replay the binary locks and also and all that was really what we I was expecting. 00;12;25;05 - 00;13;00;27 So I will I love this and everything around to MySQL Shell and Admin API. So to create replication create clusters so easily with what we saw in Season One with Miguel, this is what really for me was the two most advanced stuff in MySQL8.0. Yeah, I've become a huge fan of MySQL shell. Like it's I, I for years I used to shy away from like command line interfaces mostly because I'm a very poor typist. 00;13;01;00 - 00;13;30;01 And so for a lot of stuff I would use Workbench and I would say over the last three or four years you could probably count on one hand the number of times I've opened Workbench because I just use Shell because like you said, there's there's so much stuff that you can do. It's like, I mean, you could spend weeks just exploring new features and how to use them and how to implement some of the stuff that we have in Shell and still have new stuff that you're like, I didn't know we could do that. 00;13;30;04 - 00;13;59;07 Yeah, MySQL Shell and the team is very dynamic out of it, so they do plenty stuff is also the MySQL Shell now included in Visual Studio Code. So but I am a terminal guy. So for me the most well, the MySQL Shell standard one terminal is the one I prefer, right? Like you, Workbench. I could use it only maybe two or three times in my entire career. 00;13;59;09 - 00;14;32;03 So I really like command lines. But yeah, it's really, really nice or what we can do. And we did. So it's very, very nice. And so yeah, is something we also we need to say because it will happen soon. Now and because we are using it for a long, long time. And don't forget that next year will be something a very nice milestone for for MySQL, right? 00;14;32;10 - 00;14;59;25 That's right. We'll be celebrating 30 years of MySQL which is pretty pretty impressive for open-source software I think. Yeah I it's wonderful and very happy and yeah, I've been part of, and you too, of that longer journey at 30 years we did. So I am very proud of that and I think it's very, very nice. 00;14;59;28 - 00;15;27;13 So yeah, I think we MySQL evolved a lot since the beginning of course, and we keep involving now with everything we see, but we will talk to that in future episode I guess, right? That's right. I will say that the, the recent news is the availability of HeatWave MySQL in Oracle cloud as part of the always free tier that's that's very nice. 00;15;27;17 - 00;16;03;11 I actually move the database from the golf league application to HeatWave MySQL on the day it was available. Like the day we found out, okay, it's out there. It's lot. It's live. I switched the database over because I was think I was waiting for like I had prepped. You know, I did the the dry run with Shell to say, you know, to do a dump and be like, you know, the OCIMDS set to true and it let me know all the problems I had which there was only if I remember if there's only four issues that were there HeatWave is so it's amazing plenty of feature and it's true 00;16;03;11 - 00;16;30;10 that some people who are a bit did you don't know what to expect about it just just see the the videos or they saw our presentation but now they can play with it for free and and all use it all always free. So this is amazing that with the always free compute instance you can put everything in OCI for free to start with to learn it. 00;16;30;12 - 00;17;07;01 This is a quite amazing too and there is plenty of stuff. There are also very, very interesting course, as we all know, a cloud is also part of the what people are doing now. So people like to move to the cloud and so mostly it's a very nice a contender too, if you want to have your most well, your your database in the cloud, the strength of MySQL HeatWave, if all they're running to MySQL, is that it's the most accredited support team and the MySQL team who makes it and this is amazing. 00;17;07;01 - 00;17;36;22 I see you we can see the difference if people see the difference by both. This is the MySQL guy managing my database. So that's this is cool, right? And the other thing that I like is with Heatwave MySQL, it's actually based on the enterprise version. So for in the always free tier you actually get enterprise features such as being able to create stored functions, stored procedures in JavaScript, the data masking and some of the other enhanced security and as well as some of the enhanced performance. 00;17;36;24 - 00;18;03;27 So those are things it's to me it's really cool that you can we can have those things, try them out for free, or if you have a just even a small application like the one that I work on, you know, I have I've been using Oracle for hosting for years and I haven't paid a penny for it. And now I have, you know, my my database running in Heatwave MySQLand again as part of the always free tier I'm not going to pay anything going forward either. 00;18;03;29 - 00;18;29;19 You know that's that's great. We have a very great news now we were expecting that always free you or MySQL heatwave so now it's there so I'm going to wait for all your nice MySQL short content about it and the so thing we reached the end of this episode so thank you very much Scott Thank you Fred Thank you for listening. 00;18;29;19 - 00;18;47;01 Bye bye. That's a wrap on this episode of Inside MySQL: Sakila Speaks. Thanks for hanging out with us. If you enjoyed listening, please click subscribe to get all the latest episodes. We would also love your reviews and ratings on your podcast app. Be sure to join us for the next episode of Inside MySQL: Sakila Speaks.