August 4, 2016
Northeast PHP moved to Charlottetown on Price Edward Island this year to reach a new audience. Roughly one hundred developers are attending and only a handful have been to other conferences. And these developers have access to some of the best and brightest in the PHP world.
One of the amazingly great things about the PHP community is that sharing of information from all levels of developers seems to be a core component of the group. The attendees not only hear sessions on many hot topics from the experts in their subjects they are encouraged to interact — to ask questions and test their knowledge — and help each other. This is the old adage of a rising tide rising all boats. With 80% of the web based on PHP, the PHP community is doing this very, very well.
I will be presenting on the MySQL JSON Data Type and Common Database Problems. Sadly my box of swag has been delayed so those attending will have to wait for some goodies until after lunch.
July 13, 2016
I will be speaking at the Converge Security Conference on July 14th on MySQL 5.7 security. There were many changes in 5.7 and it has been very hard to get the majority of those changes in a forty minute presentation. And is with just scratching the surface with the new encryption for InnoDB. If you are are attending please say ‘hi’!
July 7, 2016
I hope to see y’all at the Texas Linxufest this weekend in Austin. If all you all are looking for some MySQL swag (push dolphins, squish dolphins, hats) you will need to answer some new MySQL quiz questions to win. And y’all all are welcome to be in room Three at 3:00PM to hear me talk on MySQL & JSON — I have had to update this presentation after several new features in MySQL 5.7.13.
June 28, 2016
The Release Notes for MySQL 5.7.13 has some interesting notices about account length, JSON short cuts, and more.
A Rose By Any Other Name
Way back in 5.7.8 the account username was increased from sixteen to thirty two characters. Yeah! For many years this has been heavily requested. Now this has been incorporated in the definer fields of event and proc tables plus the grantor field of procs_priv and tables_priv tables. To do this these columns where bumped up from CHAR(77)) to CHAR(93) to hold the longer username@hostname data.
JSON Inline Path
An unquoting extraction operator ->>, called an inline path operator, is for use with JSON documents stored in MySQL. The new operator is similar to the -> operator which is a shotcut for JSON_EXTRACT. But it goes a step further in that it performs JSON unquoting of the value as well. For a JSON column mycol and JSON path expression mypath, the following three expressions are equivalent:
JSON_UNQUOTE( JSON_EXTRACT(jsoncolumn, "$.jsondata") )
This new ->> operator can be used in SQL statements where JSON_UNQUOTE(JSON_EXTRACT()) would be allowed. This includes SELECT lists, WHERE and HAVING clauses, and ORDER BY and GROUP BY clauses.
Systemd and Multiple Severs
Those of you running Systemd equipped distros need to read Configuring Multiple MySQL Instances Using systemd if you desire to run multiple servers on a single host.
And there is more
The release notes for ’13 cover bugs fixed, audit log granularity, and more. Please take a few minutes to read this.
April 21, 2016
Percona Live 2016 was the most impressive show in a long line of shows that started with the old MySQL Users Conference. There were a lot of old familiar faces or familiar faces grown old. During my stint as MySQL Certification Manager I usually was at the other end of the conference center / hotel complex administering exams. But this year I would be able to attend sessions, network, and see the heart of the MySQL Community.
From the opening keynotes featuring TV personality Bill Nye to the final drawing where I won a Bill Nye autographed book, the show was filled with information on several data stores just not MySQL. This show was more about managing data with the proper tool and not just managing data with MySQL. All the session were recorded and will be posted — have patience as it takes time to get all 195 speakers’s material formatted.
Meet the MySQL Engineering Team Birds of a Feather Session
The highlight of the first day was having the available MySQL engineers reveal their plans and answer questions from an audience that was universally happy with the course Oracle has set the MySQL ship on for the next several years.
Tuesday started with Tomas Ulin reiterating the the release of MySQL 5.7 and then covering many of the new software features revealed last week like the ability to use MySQL as a document store.
2016 featured sessions on many facets of MySQL and a great many on MongoDB, Cassandra, RocksDB, and more. I am note if the show will encompass all the open source data stores but there was enough information on many of technologies to get any journeyman level DBA started on becoming a polyglot DBA. And the new 5.7.12 document store features are going to be a big game changer as MySQL become more of a universal storage tool rather than just a relational database.
And a big salute to the show organizers and the entire Percona staff for showing their commitment and love to the open source world by providing such an awesome event.
April 20, 2016
Been seeing references to the new document store features of MySQL 5.7 and want to try it on Windows? The new features of MySQL require a download of the new mysqlsh msi or zip.
Welcome to MySQL Shell 22.214.171.124
Installation is a snap.
You can also determine where to keep your new mysql
The installation msi quickly guides you through the choices and your best bet for now is to pick the defaults. If you have used the 5.7 msi server install before there are no surprises. But you are offered the opportunity to change the options for such things such as location of the binaries. Again the defaults worked well for me. In a very short time you can launch the new shell.
And then you are ready to use mysqlsh.
And then you have the new shell with the new protocol!