The MySQL Development team is proud to announce a new version of the MySQL Shell which in addition to the usual bug fixes and enhancements to the existing components, offers new features we expect are quite useful in your day to day work.…
Uber is committed to delivering safer and more reliable transportation across our global markets. To accomplish this, Uber relies heavily on making data-driven decisions at every level, from forecasting rider demand during high traffic events to identifying and addressing bottlenecks…
The post Uber’s Big Data Platform: 100+ Petabytes with Minute Latency appeared first on Uber Engineering Blog.
Someone once told me you can tell how healthy a software project
is by the number of new books each year. For
the past few years the MySQL community has been blessed with one
or two books each year. Part of that was the major shift with
MySQL 8 changes but part of it was that the vast majority of the
changes were fairly minor and did not need detailed explanations.
But this year we have been blessed with four new
books. Four very good books on new facets of MySQL.
Introducing the MySQL 8 Document Store is the latest book from Dr. Charles Bell on MySQL. If you have read any other of Dr. Chuck's book you know they are well written with lots of examples. This is more than a simple introduction with many intermediate and advanced concepts covered in detail.
I wrote MySQL and JSON: A Practical Programming Guide
to help developers find their way around the MySQL JSON data type
and the supporting functions. The MySQL Documentation on the
subject is very good but I had to puzzle through the examples to
see how things worked. I might be a bit 'thick' but good
examples always make things easier. Others seem to have
|MySQL and JSON a Practical Programming Guide should be on your desk as a handy reference to MySQL's JSON data type.|
There was a recent post on …
This year again, the MySQL Team is eager to participate in the Oracle Open World conference. This is a great opportunity for our engineers and the entire MySQL Team to highlight what we’ve done, and also what we are working on. Another reason to be excited this year is our new participation to Code One, the Oracle developer focused conference. Oracle Code One will include a full track dedicated to MySQL.
This is very good news for everybody attending, from DBAs to developers, as we will offer even more great content ! This year, in both events, we will highlight how NoSQL+SQL=MySQL.
Our MySQL Engineers will deliver fantastic sessions about …[Read more]
One of the humbling things about working at Oracle with the
various MySQL personnel is that you are often blown away by
something one of them says or does. And that is on a
regular basis. In this case it is Dr. Charles Bell who gave
a great series of presentations last June at the Southeast
In particular he presented in a full formed state some ideas that had been rattling around in my skull (but no way near as coherent) on how to take advantage of the MySQL JSON data type. Below are his points from his slide deck. I was reviewing my notes from his presentation when I realized that this information really needs to be more widely disseminated. And I would like your feedback on these ideas?
1.. We can use a JSON field to eliminate one of the issues of traditional database solutions: many-to-many-joins
- This allows more freedom to store unstructured data (data with pieces …
Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell.
This is the last component in the cluster and I love it. Oracle have created this tool to centralize cluster management, providing a friendly, command-line based user interface.
The tool can be defined as an advanced MySQL shell, which is much more powerful than the well known MySQL client. With the capacity to work …[Read more]
In the old days, when we wanted to strengthen our skills the only option was to buy a good book. Nowadays one can find a lot of resources on the Internet, however quality is often poor. Fortunately there are still some great people who are brave enough to write new books that will help a new generation of women and men to build modern applications with MySQL the world's most popular open source database. Let me introduce you 3 MySQL books : Introducing the MySQL 8 Document Store / MySQL and JSON: A Practical Programming Guide / Pro MySQL NDB Cluster
There was an interesting but hard to read post on StackOverflow about how 'insert select delete'
data from a MySQL JSON data type column. The first line of
the writer's problem is a little confusing '
In order to record user mac_address and count mac_address to restrict user login's pc or notebook to control user available max for example (it's work)' but the examples reveled more about what was desired. The idea was to track MAC address used by various users and the author of the question was wondering how to up data a JSON Array of values with JSON_INSERT. INSERT is for inserting and the better choice would be JSON_ARRAY_APPEND or JSON_ARRAY_INSERT. But what caught my eye was the second question: Select sql command for json column ? could be …