Growing the MySQL Community

January 28, 2016

I will the first speaker at the FOSDEM MySQL and Friends Devroom and unlike the other speakers I will not be presenting on new technical developments, better ways to run MySQL, or anything technical. But it may be the most important talk of the day. How can we grow the MySQL Community?

How do we attract new developers and database administrators and then guide them through the steps to a ‘journeyman’ level before showing them the way to becoming seniors in their fields? There is a shortage of talent and this cuts two ways. First hiring managers get frustrated in their searches for talent and then they reduce the scope of what they want out of their database. Second the same hiring manager later will assume there is still no talent for them to hire and alter their demand accordingly. I want to bring in as many people as possible into the MySQL ecosystem because there are jobs out there in an ever increasingly tough economy and because I think MySQL solves so many problems efficiently. Nobody starts as a fully fledged developer or DBA and the start of the career path needs exposition, easing, and encouragement. So how do we grow our numbers?

There is a very similar community to the MySQL Community and that is found in the PHP world. In the last few years they have really pulled together to bring in newbies, tighten relationship between subgroups (efforts like the Framework Interop group), provide mentoring at all personal development levels, establishing active career coaching for experienced developers, and even mental health support. This has all been done by the PHP Community and they are growing, cohesive, and frankly I am envious.

A strong user community brings value to a product. I am seeking your input on how can get we more of ‘us’? What can we do to improve certification to make it a truce touchstone of a job candidates value? How can we best leverage groups like the International Oracle User Group’s MySQL Council and other sources of customer feedback to guide the development of the MySQL Products. What information are you seeking that you are not getting and what is the best way to get it to you? Are their better ways to train novices in subjects like data normalization, replication, account management, security or what have you that we have missed. What can we do to help you network with you peers? Do need a mentor or want to mentor (and yes you can be both at the same time).

So how do we grow the MySQL Community and help grow MySQL?


The Most Popular MySQL 5.7 Features

January 27, 2016

Three events into the new year and I have been getting a lot of feedback from you all on MySQL 5.7. So far there are some changes in 5.7 that are very popular.

The change in username name length from sixteen to thirty two characters seems to be universally loved. Yea!!!

The new JSON data type has caught a lot of attention. A few of you think that data should be normalized as Codd intended and find that simple shoving a document into a column is an no-no. But the vast majority love this new feature. Many ISPs are going to have to upgrade to get to 5.7 to meet demand for this new data type.

Generated columns seem to be a hot spot for several of you. Usually you do not see a lot of business logic in MySQL databases compared to, say, an Oracle database. And if there is some sort of business logic then it is implemented with a trigger. I have had some intense discussions with some folks who are going to be doing very interesting things with generated columns.

The least popular? Not being able to run 5.7 in a half gig, low cost rented environment. (How did I ever get by with 384k words in a Dec-10 or 640k with DOS??) The secure by default is causing come problems with folks who have spent decades without a forced root password and automatic expiration of password is being tackled by MySQL Engineering as it is currently seen as too drastic by some customers.

So thank you folks who came out to SkiPHP, San Diego PHP, and SCaLE in the past few weeks. Please let me know you feelings on MySQL 5.7 at FOSDEM, SunshinePHP, and RMOUG training days!


San Diegans — learn about MySQL’s New JSON Data Type Tonight

January 19, 2016

I will be speaking at the San Diego PHP Meetup tonight January 19th at 7pm. The location is Business.com Media, 1900 Wright Place in Carlsbad (33.122360, -117.28909) and the topic will be MySQL’s JSON Data Type. I hope to see you there!


See you in Salt Lake City, San Diego, Pasadena, Brussels or Frisco!

January 8, 2016

The last half of January is going to be busy but here is where to catch me and some MySQL SWAG.

First I will be speaking at SkiPHP on the 14th and 15th. Then is it off to San Diego meet up with the San Diego PHP Meetup on the 19th. Next is the Southern California Linux Expo where MySQL is sponsoring a track from the 21st to the 24th. That is followed by a quick trip to the MySQL and Friend Room at FOSDEM to end the month. Finally back to DFW where there will be a meeting of the North Texas MySQL Users Group on the 15th of February.


MySQL Central @ Oracle Open World Wrap Up

October 30, 2015

MySQL Central @ Oracle Open World 2015 is over. For the MySQL Community Team the event feels like juggling running chainsaws while riding a unicycle on top of a surfboard that is plunging down the face of a monster North Shore typhoon driven wave. For those who have never attended Open World, it is an extra 50,000+ bodies in downtown San Franciso and Moscone Center, the site for the event, hums with people for a week. Add in an Elton John/Beck concert on Wednesday night for a full nights entertainment. Plus the week before this overwhelming event, MySQL 5.7 was made generally available which added yet another level of excitement this year.

So what did you miss?

Sadly Moscone Center was being remodeled during OOW this year and we lost about fifteen percent of the meeting space. For some of the bigger products in the Oracle portfolio, this was a major inconvenience. For MySQL, it meant that roughly a dozen or more sessions were off the slate. Ouch! The keynote was in the afternoon which was a bit anticlimactic as some of the ‘news’ was in earlier sessions. But the session we had were all amazing, most of them being packed, leaving many to stand at the back of the room.

There were many simply amazing sessions and you have probably already seen links to the talks on the Oracle Open World site or on Planet. Besides 5.7 and a new Enterprise Manager, there were sessions on MySQL Router and Group Replication plus deep dives into generated columns. Pinterest announced many of their MySQL tools are open source.

Best title for a session? Bill Karwin’s InnoDB Locking Explained with Stick Figures and the session grew an audience of old MySQL hands and novices, even if it was the last session of the last day.

For many the highlight was seeing old friends at the Community Reception. This event was open to the public (and will be again next year, mark your calendar!) and many familiar faces appeared. The highlight was former MySQL AB CEO Marin Mikos and Rich Mason, SVP and General Manager of the MySQL GBU, cutting a cake to celebrate MySQL’s 20th anniversary.

Cake Cutting

Richard Mason and Martin Mikos cut the MySQL 20th Anniversary cake at the 2015 MySQL Community Reception

Many attendees took the time to quiz MySQL Engineers on the finer points of their products. And MySQL staff had the chance to learn from customers like Booking.com, Live Nation, Pinterest, Yahoo, and others. Several attendees were especially impressed with how Ticketmaster gets tickets into the hands of their customers. Take a look at the nearby illustration of their servers to get a glimpse of what it takes to sell 20,000 tickets in under a minute.

Ticketmaster

So how do you sell 20,000 tickets to a fight in under a minute. Just follow this simple diagram (and work really, really hard)

In a few days I will post links to the various talks. Please check back after I have time to recover and find the links.

We will be back at Jillian’s on Tuesday next year so mark it on your calendar and help us celebrate MySQL turning 21.


MySQL Community Reception 2015

October 28, 2015

Cake Cutting

Richard Mason and Martin Mikos cut the MySQL 20th Anniversary cake at the 2015 MySQL Community Reception

The annual MySQL Community Reception brought over one hundred and seventy members of the MySQL Community Together for a night of friendship, nostalgia, and entertainment. As in 2014, the event was held at Jillian’s on the Tuesday Night of Oracle Open World. I was working the door making sure those attending got their wrists bands that ensured the free food and drink were available to the holders. The event was open to all and not just OOW attendees.

It was great to many old faces. Martin Mikos, MySQL’s first CEO, joined us in celebrating the twentieth anniversary of MySQL. He later cut a cake with Rich Mason who now heads MySQL. There were too many others to name all but look through the pics in this post and you will see many folks from the MySQL Community from past, present, and future.
IMG_4251

IMG_4269

IMG_4270

IMG_4309

Rick James

Rick James MySQL Forums Racontour

Lig

Ligaya Turmelle of MySQL Support


cake

The cake


Martin Mikos, Rich Mason, and Andrew Rist

Martin Mikos, Rich Mason, and Andrew Rist

Lots of food, discussion, and an an open bar

Lots of food, discussion, and an an open bar


IMG_4303IMG_4295

Next year we will be back at Jillian’s on Tuesday night and I hope to see you there.


MySQL Sessions @ Oracle OpenWorld

October 20, 2015

Oracle OpenWorld can be pretty intimidating. Besides the extra fifty thousand bodies in an around Moscone Center in San Francisco, there is an overload of amazing information that bombards you from all directions. And then comes the really hard decision of which sessions to attend. This year MySQL has three rooms being used for sessions.

The Catalog of sessions shows over 1800 session and MySQL is the subject of fifty three of those. The problem is that you can not be in three places at once!

For example on Monday morning there are two tutorials and a great session at the same time.

  • MySQL Essentials—Getting Started with MySQL [TUT2356]
    Ligaya Isler-turmelle, Principle Technical Support Engineer, Oracle
    Jeremy Smyth, Course/Curriculum Developer, Oracle
    Monday, Oct 26, 11:00 a.m. | Moscone South—254

  • MySQL Replication Tips and Tricks [TUT5467]
    Joao Gramacho, Software Developer, Oracle
    Monday, Oct 26, 11:00 a.m. | Moscone South—250

  • Architecture and Design for MySQL-Powered Applications [CON5041]
    Peter Zaitsev, CEO, Percona Inc
    Monday, Oct 26, 11:00 a.m. | Moscone South—262

Another example?

  • MySQL Server Performance Tuning 101 [CON2353]
    Ligaya Isler-turmelle, Principle Technical Support Engineer, Oracle
    Tuesday, Oct 27, 12:15 p.m. | Moscone South—262

  • Yahoo Case Study: MySQL GTIDs and Parallel or Multithreaded Replication [CON5409]
    Yashada Jadhav, MySQL DBA, Yahoo
    Stacy Yuan, Sr. MySQL DBA, Yahoo
    Tuesday, Oct 27, 12:15 p.m. | Moscone South—250

  • Feed Your Streams: Zendesk’s Maxwell Generates Kafka Event Stream from MySQL Binlogs [CON3340]
    Ben Osheroff, Principle Engineer, zendesk.com

If you are a first time attendee, make sure you arrive early for your desired sessions. Rooms fill very quickly and some talks will be standing room only. And there are some talks where you may not get in so have a secondary target. Take advantage of the Session Builder software and plan strategically.

And be sure to RSVP for the community reception Tuesday night and avoid the signup lines.


Follow

Get every new post delivered to your Inbox.

Join 882 other followers