Tuesday, January 5, 2021

MySQL 5.6 End of Life in ONE MONTH!!!

 For the past year or so I have been reminding folks that MySQL 5.6 reaches End of Life Status in ONE MONTH!!  No more updates or security fixes!  Nostalgia is a fine things and I like antiques but not for my database!

So if you are on 5.6 please upgrade to 5.7 -- https://dev.mysql.com/doc/refman/5.7/en/upgrading.html and consider going to 8.0 - https://dev.mysql.com/doc/refman/8.0/en/upgrading.html  plus there is a5.7 to 8.0 upgrade checker in the new shell - https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-upgrade.html

Friday, December 18, 2020

Holidays Gifts For Your MySQL DBA - 2020 Edition

 Dear Family, Friend, Co-Worker, or Acutance of a MySQL DBA,

You MySQL DBA knows that shopping for them this time of year is very hard as all they really need is a new instance of MySQL to make them ecstatic.   However they have downloaded this list of gifts, have printed this out, and circled some gift ideas from this blog -- to make it easier for you. 


1. Singing Tesla Coil Music Kit Plasma Loudspeaker Wireless Transmission Experiment Desktop 


Link

Musical Tesla Coil (also known as "Singing Tesla Coil"), sometimes called a zeusaphone, thoramin or musical lightning, is a form of plasma speaker. The music Tesla coil, It is a variety of a solid state Tesla coil that has been modified to produce musical tones by modulating its spark output. The resulting pitch is a low fidelity square wave like sound reminiscent of an analog synthesizer. The high-frequency signal acts in effect as a carrier wave; its frequency is significantly above human-audible sound frequencies, so that digital modulation can reproduce a recognizable pitch. The musical tone results directly from the passage of the spark through the air.

2. A new Cup


Link

Yes, a new mug is needed as we approach 2021!




3. Alternative Cup


Link

Maybe two new mugs! This time with a possibly naughty message!





4. Star Wars Death Star Popcorn Maker - Hot Air Style with Removable Bowl


HEALTHIER CHOICE - Uses hot-air popping method so no oil required. It makes popcorn a perfect snack for the whole family.

EASY OPERATION - Add kernels into the main chamber using the provided measuring cup, turn on the unit and watch the magic happen through the transparent cover!

HIGH EFFICIENCY - Pops evenly and quickly, with up to a 98% popping rate. Unique channel ensures constant hot air to pop about as quickly as a microwave (2-3 minutes).


5. A New Light Switch Cover


Link 

Change up that boring switch plate with something a little quirky!





6. A new blanket or pillow


Link 


Yes, that MySQL DBA needs at least one of these too!




7. New shirt


Link 

With the closing of many in person conferences, your DBA may be lacking in t-shirts so get them this one!






Monday, November 30, 2020

Running MySQL 5.6? It reaches End Of Live Status in TWO MONTHS

  This is yet another reminder that MySQL 5.6 reaches End of Life status in February 2021.  I have been sending out such reminders since February of 2020. But in my presentations this year when I bring up the 5.6 EOL, there are a lot of users out there that are shocked to hear the news. In one of my November presentations (virtual) I had a very upset audience member who wondered why I was not making more of a big deal out of the EOL date.

    Wikipedia says ""End-of-life" ("EOL") is a term used with respect to a product supplied to customers, indicating that the product is in the end of its useful life (from the vendor's point of view), and a vendor stops marketing, selling, or rework sustaining it. (The vendor may simply intend to limit or end support for the product.)" 

What does this mean those of you running MySQL 5.6 will not be getting bug fixes, will find it much harder to get support, and will get social ostracized by all. Well, maybe not that last one.  But you life is going to be tougher.  As someone who loves old cars I can attest that even the simplest of spare parts or practical repair knowledge on unique features gets much harder to find over time.  And like my buddy who still supports dBase II, you will find your world curtailed.

So please upgrade to MySQL 5.7 or better yet 8.0.   Those of you running 5.7 can use the upgrade checker utility to help you upgrade to 8.0.

Utah Oracle Users Group December 3rd presentation on New MySQL 8.0 Features

 Want to learn more about new features in MySQL 8.0? The folks at the Utah Oracle Users Group are opening their December 03, 2020 meeting to all.  It will run from 6:30 PM - 8:00 PM Mountain Time. 

Please RSVP https://us02web.zoom.us/j/89659298608?pwd=QVhIRDcvV0EwNnF




Wednesday, November 11, 2020

Live Events This Week and More Basic Videos

    The Granite State Code Camp is this Saturday November 14th and I will be speaking on new Features in MySQL 8.

    Sadly Babbletech is going to be canceled but you can catch my talk on MySQL Indexes and Histograms that was recorded at the All Things Open Conference. 

  And I am slowly adding more videos to my Dave's MySQL Basics series for beginners.  Please see them on Youtube or Github. If you have a subject you want to see sooner than I have planned, please let me know!

Monday, November 2, 2020

MySQL 5.6 End of Life Reminder

 This is a reminder that MySQL 5.6 reaches End of Life status in February 2021.  I have been sending out such reminders since February of this year. But in my presentations this year when I bring up the 5.6 EOL, there are a lot of users out there that are surprised to hear the news.

    Wikipedia says ""End-of-life" ("EOL") is a term used with respect to a product supplied to customers, indicating that the product is in the end of its useful life (from the vendor's point of view), and a vendor stops marketing, selling, or rework sustaining it. (The vendor may simply intend to limit or end support for the product.)" 

So those of you running MySQL 5.6 will not be getting bug fixes, will find it much harder to get support, and will get social ostracized by all. Well, maybe not that last one.  But you life is going to be tougher.  As someone who loves old cars I can attest that even the simplest of spare parts or practical repair knowledge on unique features gets much harder over time.  And like my buddy who still supports dBase II, you will find your world curtailed.

So please upgrade to MySQL 5.7 or better yet 8.0.   Those of you running 5.7 can use the upgrade checker utility to help you upgrade to 8.0.

Friday, October 23, 2020

Data Con LA 2020 and New Introductory Video Series on MySQL

 Data Con LA starts October 23rd and I will be speaking on Sunday and I will be speaking on Sunday the 25th on MySQL's NoSQL JSON Store in a talk titled MySQL Without the SQL -- Oh My!

The talk is pre-recorded but I will be live for the question and answer segment. So this is your chance to ask me your question.

Dave's MySQL Basics is a new video based series I am starting to teach the basics of MySQL.  I have been talking with book publishers, hiring managers, DBAs of all levels, and many others.  They have all said they would like to see a simple, modular way to learn MySQL.  So rather than take a few years to produce a book, I am creating a series of videos that will be short (the goal is five minutes or less), not too pedantic (still have to teach the very low level basics), and that can be updated quickly when/if the material changes.  The videos will be on Youtube and course materials I create will be at https://github.com/davidmstokes/MySQLBasics, where you can also find the video links.