Recently I posted a blog on my time attending a DevOps event in Toronto. In that blog I had intended to focus on the conference and highlight some of the topics that stood out for me. In this blog though, I wanted to share what others were doing with containers like Docker, and particularly and… Read More »
10 Older Entries »
I recently attended DevOpsDays Toronto 2017, my first proper DevOpsDaysTO event. I had the pleasure of attending and being able to immerse myself in this openly collaborative and supportive culture of IT professionals. The variety of considerations expressed for delivering software features in a rapidly, frequently and reliable release focused manner was really intriguing….but not without its own complexities.… Read More »
Once again, Pythian is organizing the traditional Open Source Database Community dinner in Santa Clara!
- When: Tuesday April 25, 7pm-10pm
- Where: David’s Restaurant, a short 5-minute walk from the Santa Clara Convention center.
- Tickets: Register here!
Among the attendees will be Pythian’s amazing lineup of speakers at the PerconaLive Conference.
This event is open to all open source database community members who will be in the area; many will be in town for the …[Read more]
In the MySQL team, one of our focuses over the last few releases has been improving the usability of the MySQL Server for operations teams. The results can be seen in a number of areas:
- Our continued investment in Performance Schema.
Last week I had the pleasant opportunity of introducing and discussing the operation of online schema migrations to MySQL's engineering managers, as part of their annual meeting, in London.
Together with Simon J. Mudd of Booking.com, we discussed our perception of what it takes to run online schema migrations on a live, busy system.
While the Oracle/MySQL engineers develop new features or optimize behavior in the MySQL, we of the industry have the operational expertise and understanding of the flow of working with MySQL. In all topics, and in schema migration in particular, there is a gap between what's perceived to be the use case and what the use case actually is. It is the community's task to provide feedback back to Oracle so as to align development to match operations need where possible.
Our meeting included the following:
Need for schema migrations
We presented, based on our …[Read more]
About one month ago, the MySQL team at Oracle released MySQL 8.0, with a large list of changes. One of the most interesting features in the new release is also one that does not show up much, also because the team has gone to great length to keep most of its implementation hidden: the data dictionary.
What makes the data dictionary so interesting, despite its scarce visibility, is the effect that it has on performance. Up to MySQL 5.7, searching the information_schema was an onerous operation, potentially crippling the system. In MySQL 8.0, the same operations are …[Read more]
MySQL operations in Docker is a three-hour tutorial, and it will be an expansion of the talk by the same title presented at OOW. Attendees who want to play along can do it, by coming prepared with Docker 1.11 or later and the following images already pulled (images with [+] are mandatory, while [-] are optional):
The freshly released MySQL 8.0 includes a data dictionary, which makes MySQL much more reliable. Thanks to this features, we don't have any '.frm' files, and querying the information_schema is 30x to 100x faster than previous versions.
One drawback of the implementation is that the data dictionary tables are hidden by design.
While the reason is fully understandable (they don't want to commit on an interface that may change in the future) many curious users are disappointed, because openness is the basis of good understanding and feedback.
The problem to access the dictionary tables can be split in three parts:
- Finding the list of tables; …
MySQL is a growing presence at Oracle Open World. While most of the headlines belong to the main products, where Oracle services are aiming at world domination, MySQL shared the spotlight, as it was announced to be part of Oracle database cloud. It seems a logical move for Oracle: after all the effort to make MySQL 5.7 the biggest release ever, it stands to reason that it is offered as a competitive feature in its own database as a service.
With this offer, Oracle is applying enterprise pricing and methodologies to a target of emerging companies. MySQL in the Oracle cloud differs from the competition by a few key points:
- It's only MySQL 5.7. While this is the most advanced MySQL server …
There was a bold announcement during the MySQL Keynote at Oracle Open World. A new product that will mix up with the existing GA server, called MySQL InnoDB Cluster. This is an evolution of MySQL group replication, which has been in the labs for long time, and the MySQL shell, which was introduced as a side feature last April. The boldness I mentioned before is on account of wanting to add to a GA server something that was defined as release candidate despite never having been out of the labs. The product is interesting as it promises to be a quick and painless cluster deployment, with built-in high availability and scalability.
10 Older Entries »