MySQL at Sunshine PHP

February 4, 2020

Sunshine PHP is the first US based PHP Conference of the year and it has been a favorite of mine for a long time. MySQL is proud to again sponsor this amazing event. This show brings in the best talent from around the world and covers all the aspects of PHP software development.SunshinePHP logo

I will be speaking on new features in MySQL such as dual passwords, hash joins, and JSON document validations. And this year Kathy Forte will present on Testing MySQL Group Replication with MySQL to Enhance Your High Availability Strategy.

There are a few tickets left but they are running out quickly. And be sure to drop by the MySQL booth to say hello.

2018 Events – February to April

January 12, 2018

2017 Was a very busy year for me (the two dozen events on the sidebar do not include a few user group and Meetups where I spoke) and 2018 is ramping up.

First up is FOSDEM.  FOSDEM is a free event in Brussels that i can best describe as organized chaos or chaotic organization.  The MySQL & Friends Dev Room is organized by the amazing LeFred.  This day will include some of the best technical talks on MySQL that from their short summaries given to us on the paper review committee (very honored to be on that committee) on MySQL related topics EVER!!  We had a dozen or so speaking slots and four dozen A-level talks out of sixty some submissions.  I could do a very successful conference with the talks not chosen. But look at the ones that where picked.  There is also a dinner and a free day with the MySQL Engineers.

Then it is off to SunshinePHP in Miami which attracts the top PHP folks to a warm Florida.  And the next weekend is PHP UK. MySQL is proud to sponsor these excellent events

Then I will head to San Diego to talk to the San Diego User Group, details to follow.

And once again the Southern California Linux Expo will feature a MySQL track where I will be speaking on MySQL Without the SQL — Oh My!

I will be teaching an Intro to Database course for ChickTech Austin (more later) and then back a month later for Longhorn PHP (a replacement for the departed Lonestar PHP).  So fellow Texans, watch out for me heading down I35.!

But between trips to Austin is a trip to YorkshirePHP where MySQL is proud to sponsor this second year event in the charming town of York.

April finishes, for me at least, with the Percona Live conference and then the amazing Linxufest Northwest.  Both are amazing shows.  The Santa Clara show has evolved from the Old MySQL User Conference to a multi database show.  LFNW is a few thousand folks at a small college in Bellignham Washington that is almost as bustling as FOSDEM, filled with great talks and a packed expo hall.

Nine events in three months is a lot of time in airplane seats for me but I hope to see you at these events.  All the above are worth your effort to attend if you can.  And if would like the MySQL Community Team to appear and/or sponsor your event, please contact me.


MySQL at Oracle Open World

September 7, 2017

Oracle Open World’s session catalog is online. Here are some of the MySQL centeric highlights!

MySQL Shell: The DevOps Tool for MySQL
Monday, Oct 02, 3:15 p.m. – 4:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

MySQL Document Store
Monday, Oct 02, 11:00 a.m. – 1:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL Performance Tuning 101
Tuesday, Oct 03, 11:30 a.m. – 12:30 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental Ballroom 7

Using MySQL Containers
Monday, Oct 02, 2:15 p.m. – 3:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

MySQL Enterprise Edition: Complete Guide
Monday, Oct 02, 1:15 p.m. – 2:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

MySQL for Analytics
Monday, Oct 02, 2:15 p.m. – 3:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

Why We’re Excited About MySQL 8
Monday, Oct 02, 3:15 p.m. – 4:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL 8.0 Overview
Wednesday, Oct 04, 11:00 a.m. – 11:45 a.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

Running Workloads with Oracle MySQL Cloud Service
Wednesday, Oct 04, 3:30 p.m. – 4:15 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL DBA Primer
Monday, Oct 02, 11:00 a.m. – 12:00 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental Ballroom 7

Oracle Enterprise Manager for MySQL
Monday, Oct 02, 11:00 a.m. – 1:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

MySQL 8.0: Performance, Scalability, and Benchmarks
Wednesday, Oct 04, 5:30 p.m. – 6:15 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

What’s New in MySQL NDB Cluster
Monday, Oct 02, 1:15 p.m. – 2:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL 8.0: What’s New in Security
Wednesday, Oct 04, 1:00 p.m. – 1:45 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

Solving Performance Problems with MySQL Enterprise Monitor
Wednesday, Oct 04, 4:45 p.m. – 5:45 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental Ballroom 7

MySQL 8.0: What’s New in InnoDB
Wednesday, Oct 04, 4:30 p.m. – 5:15 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL 8.0: What’s New in the Optimizer
Wednesday, Oct 04, 12:00 p.m. – 12:45 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

Split Your Database: Seamless Database Growth with MySQL
Tuesday, Oct 03, 11:30 a.m. – 12:15 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

StorageTapper: Real-Time MySQL Change Data Streaming at Uber
Tuesday, Oct 03, 12:45 p.m. – 1:30 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL 8.0: What’s New in Replication
Wednesday, Oct 04, 2:00 p.m. – 2:45 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL InnoDB Cluster in a Nutshell: Hands-on Lab
Monday, Oct 02, 4:15 p.m. – 5:15 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental Ballroom 7

How to Set Up Orchestrator to Manage Thousands of MySQL Servers
Tuesday, Oct 03, 12:45 p.m. – 1:30 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

General Session: MySQL – State of the Dolphin
Monday, Oct 02, 4:45 p.m. – 6:30 p.m. | Marriott Marquis (Golden Gate Level) – Golden Gate A

Core MySQL Kernel Development and Architecture in Tencent Games
Wednesday, Oct 04, 1:00 p.m. – 1:45 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

Triggerless, Painless, Trusted MySQL Online Schema Migrations at GitHub
Wednesday, Oct 04, 12:00 p.m. – 12:45 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

Using MySQL Flexible Schema (Document Store/JSON) for IoT
Tuesday, Oct 03, 11:30 a.m. – 12:15 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL Automatic Diagnostics: System, Mechanism, and Usage
Sunday, Oct 01, 3:45 p.m. – 4:30 p.m. | Moscone South – Room 160

Self-Service Database Monitoring for Gaming Needs
Wednesday, Oct 04, 11:00 a.m. – 11:45 a.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

DevOps and Cloud-Native Microservices Workshop with MySQL Database
Monday, Oct 02, 4:30 p.m. – 6:30 p.m. | Hilton San Francisco Union Square (Lobby Level) – Golden Gate 2/3

Rest Services with the Play Framework, MySQL, and a Security Level with JWT
Sunday, Oct 01, 5:00 p.m. – 5:45 p.m. | Moscone West – Room 2002: Java User Group Track

Cloud Foundry Service Broker: Bridging Your Cloud-Native Apps
Wednesday, Oct 04, 1:45 p.m. – 2:30 p.m. | Moscone West – Room 2005

DBA Types
Sunday, Oct 01, 1:45 p.m. – 2:30 p.m. | Marriott Marquis (Yerba Buena Level) – Nob Hill A/B

Oracle Cloud Performance Best Practices: Tuning, Diagnostics, Issue Resolution
Tuesday, Oct 03, 5:45 p.m. – 6:30 p.m. | Marriott Marquis (Golden Gate Level) – Golden Gate A

Innovation, Oracle Cloud, Big Data, and the Internet of Things
Monday, Oct 02, 11:00 a.m. – 11:45 a.m. | Moscone West – Room 2001

PNWPHP and Swanseacon

September 5, 2017

Busy month with PNWPHP at Washington University’s Kane Hall September 7th to the 9th. MySQL is sponsoring and I will be manning the booth. This is an exciting event on the PHP calendar and they have a great speaker lineup. Ticket are still available if you are in the area.

Swanseacon returns for a second year and I will be speaking on making MySQL Agile-ish. MySQL is proud to be sponsoring for a second year and I am looking forward to the wonderful Welsh audience again. Tickets are going quickly.

And do not forget that Oracle Open World is the first five days in October. MySQL will also have some post show events and I will provide more details when I get them.

The London MySQL Meetup

April 25, 2017

The various MySQL User Groups or MySQL Meetups around the world are made of up of various groups of individuals that all have a passion for MySQL. Some are large and intense like San Francisco or Boston. Others are fun loving like Chicago or obviously vary hard working like Oklahoma City. I recommend for those of you that travel to connect with these groups. But there is one group that is a little special. They meet in a pub, upstairs in the back. There is a bar and bartender. The food is very good and the attendees very sharp. If you get a chance, visit the London MySQL Meetup

I had been in York a few days before and was invited by Ivan Zoratti, a long time institution of the MySQL Community and Meetup organizer to present on MySQL 8. I made it to The Lamb, a pub on Conduit street and made my way to the meeting room. I was greeted by the bartender (a nice addition to your meeting if you can arrange it) and soon the room filled. I gave my presentation and we then started a fun question & answer period.

All too soon we realized it was getting very late and had to disband. But I had a wonderful time and decided that I need to make a return visit.

So if you find yourself in London, please take the effort to try to attend one of the London MySQL Meetup meetings.

Talks in April – Las Vegas, UK, TX, Santa Clara, and Oracle HQ!

March 28, 2017

April is going to be a busy month for yours truly. First up is the big Oracle Users Groups show in Las Vegas Collaborate 17 at Mandalay Bay April 2nd through 6th. This show features over 1,250 session, thousands of attendees and me (with Kathy Forte) at the MySQL Demo Pod.

From there I am off to Yorkshire PHP where I am proud to be speaking at this new event on MySQL 8. That is on Saturday the 8th in York but I will head down south on the 11th for the London MySQL Meetup to talk more about MySQL 8.

Then it is the closest show to home for me, the final LoneStar PHP. I will be giving a talk on the basics of database programming with PHP.

The month ends with Percona Live the 24th through the 27th and followed by Oracle Innovation Day on the 28th; the agenda for the FREE innovation day follows.

08:00 a.m. – 09:00 a.m.

Registration & Breakfast

09:00 a.m. – 09:15 a.m.

Welcome & Opening Remarks

09:15 a.m. – 10:00 a.m.

MySQL 8.0: What’s New

10:00 a.m. – 10:45 a.m.

MySQL 8.0: CTEs & Window Functions

10:45 a.m. – 11:00 a.m.

Morning Break

11:00 a.m. – 11:45 a.m.

MySQL in Oracle Public Cloud

11:45 a.m. – 12:30 p.m.

MySQL Enterprise Security

12:30 p.m. – 01:30 p.m.


01:30 p.m. – 02:15 p.m.

MySQL Group Replication

02:15 p.m. – 03:00 p.m.

MySQL InnoDB Cluster

03:00 p.m. – 03:15 p.m.

Afternoon Break

03:15 p.m. – 04:00 p.m.

Best of Both Worlds | MySQL as a Document, Relation, and Combined Store

04:00 p.m. – 04:45 p.m.

MySQL Performance Tuning

04:45 p.m. – 05:00 p.m.

Wrap up

Last Conference Trip of the Year

December 4, 2016

ConFoo has now a West Coast version which has its initial dates this week in Vancouver. This is in addition to their spring show in in Montreal. This will be my forth time in Canada this year. Northeast PHP moved from Cambridge to Charlotteville, LinuxCon NA was in Toronto, and now a new ConFoo. Canada seems to doing very well even before recent threats of many Americans to move North.

2016 saw a lot of old shows in new locations — Zendcon, SCaLE, PHPTek. But many have anchored to their venues — RMOUG Training Days, Collaborate, FOSDEM, Ohio Linuxfest, All Things Open — and have improved greatly. And many new shows –Swanseacon, Scotland PHP, ContainerConNYC — have appeared and run as a smoothly as if they were old, long established shows with veteran crew.

For sheer pandemonium, nothing beets FOSDEM. This show has dozens of small rooms, short session times, and what seems like 99% of all the computer folk in Europe rushing around a university campus. Ironically Linuxfest Northwest is also a great many bodies rushing around a slightly smaller college. The energies at both events is very high and you will feel exhausted when they finish just from the hub-bub and frenetic pace.

SCaLE moved from slightly seedy LAX to posh Pasadena. The new venue is very posh, the content still amazing, but the local eateries are bit more upscale and I miss the old Carl’s Junior.
Northeast PHP was in very beautiful Prince Edward Island. Red sand beaches, lobster, and a a large developer community that caught almost everyone by surprise.

Scotland PHP sort of cheated. They had Arthur’s Seat looming over their venue and were next to a castle, the Scottish Parliament, and a lot of great single malt. That would be enough for many conferences but the organizers went to school on other events and put together a very smooth show with great speakers. The audience was friendly, very inquisitive, and asked a lot of tough questions.

I liked the St Louis location for PHPTek but it seems nobody else did. Next year the show relocates to Atlanta. Speaking of the south, All Things Open has grown from a few hundred folks to well over two thousand in four years. Todd Lewis and crew run very smooth shows and treat vendors and speakers very nicely. It is always a pleasure to be at those shows.

I will be travelling less in 2017 (hopefully). My counterpart, LeFred, has been a great addition to the team and has taken some of the travel stress off me. Sadly there are only two of us travelling and many new shows appearing on the calendar.

A big thank you to the organizers of the shows MySQL sponsored this year. The first hurdle is getting these shows into the Oracle Purchase Order system which includes a tough bunch of paperwork. Then each event has it own set of documents to be completed. This can be arduous for smaller shows and a nuisance for the bigger shows. But they did it well and with style. BTW if you want MySQL to sponsor you event, drop me a note and I will contact you.

Four Conferences — All Things Open, Scotland PHP, & Buzzconf

October 31, 2016

Computer conferences each have their own personalities. Sure their are some common flavors — Utilikilts at Linux events for instance — but each have developed their own quirks. These character traits develop around the content of the show, the core beliefs of the organizers, and passion of the attendees who stride through the doors.

This past week All Things Open was held in Raleigh and Scotland PHP was held in Edinburgh. ATO has grown from four hundred attendees to twenty four hundred over four years. Scotland PHP was a first time event with about one hundred fifty or so present. Todd Lewis and the ATO crew have mastered providing great content at a very low cost at a show where offer a wide menu to many. Paul Dragoonis (to pick on one organizer) and his mainly Scots cohorts carefully studied other conferences to get just the right mix. Both had vibrant audiences who had direct and detailed questions about product, best practices, and implementation. Both made sure their attendees had exactly what information they needed on wifi, locations, supporting events, and schedule. And their venues were both amazing all though Scotland PHP was in the Dynamic Earth facility with a castle, Arthur’s seat, and a Parliament build very nearby that could have proven breathtaking distractions if the content of the show had not been so outstanding.

This week in New York is Container Days NYC where they have a mix of unconference, talks, workshops, and open spaces on putting software into containers. See you there!

Buzzconf is November 25th-27th in Australia (and sadly will be only show mentioned in this blog that I will not be able to attend) and has a wide content offering of virtual reality, Internet of Things (IoT), robots, machine learning, augmented reality, and space exploration (stuff out side the Earth’s atmosphere, not at all InnoDB related).

As a sponsor and/or speaker, you can tell a lot about the show by the quality and quantity of communications from the organizers. Those that sweat the details well beforehand tend to have a much more smoothly running event. MySQL has (or is) sponsoring all the above events and the forms to get into the Oracle purchase order system are very detailed. Then the purchase order itself must be accompanied with more documents. For small shows these bureaucratic tasks often chew up time and manpower, usually not on their PERT or GANTT charts. The above shows went throw this process with much more aplomb than I do. Hats off to all of them.

Final thought: If you attend a conference and had a good time, learned something, hated something else, or see something obviously wrong that nobody else has spotted– please tell the organizers and volunteers. They put on these events for you, the community. Believe me that they could easily go to bed early, make a few more kid’s sporting events, code a few more lines, or just have many more quiet minutes with the time they spend agonizing over details.

And the next time they have the urge to walk away they just might remember you and your saying ‘thank you’. Those two words have a lot of weight for only eight letters.

NomadPHP, Zendcon, All Things Open, & Scottish PHP

October 12, 2016

Busy couple of weeks coming up for yours truly! On Thursday October 13th I will be presenting a lightening talk on the MySQL JSON data type before Chuck Reeves presents How the 3rd Normal Form Destroyed a Family— Get your tickets here

Zendcon returns to Las Vegas October 18-21st. MySQL is a sponsor, we will have a booth, and best of all Ligaya Trumelle is presenting on MySQL Server Performance Tuning 101. I have presentations on the MySQL Document Store and a Replication Update. Stop by the booth and win a dolphin if you can pass the MySQL quiz!

Next is All Things Open in Raleigh October 26th & 27th. where MySQL is a very proud to be returning sponsor and I will be presenting on database programming basics. Stop by the booth and win a dolphin if you can pass the MySQL quiz!

The a dash to Scotland for Scotland PHP on the 29th!

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, 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.


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.