A few months ago I updated my profile on LinkedIN, and adjusted my position as CTO and
founder of Athoa Ltd, a British company currently active for
translation services and events that in the past hosted a couple
of interesting open source projects. I simply forgot to disable
the email notification to my connections, set by default, and in
2-3 hours I received tens of messages from friends and
ex-colleagues who were curious to hear about my new
adventure.
Today, I changed my profile on LinkedIN again and have left the
email notification set on purpose.
As of today, I join the team at ScaleDB. My role is to define the product and
the strategy for the company, working closely with CEO Tom Arthur, CTO …
MariaDB 10.0.19 was recently released, and is available for download here:
https://downloads.mariadb.org/mariadb/10.0.19/
This is the tenth GA release of MariaDB 10.0, and 20th overall release of MariaDB 10.0.
This was a quick release in order to get a fix for a mysql_upgrade bug (MDEV-8115) introduced in 10.0.18, so there is that, and only 9 other bug fixes.
Here are the main items of note:
Due to the mysql_upgrade bug fix as well as all of the fixes in MariaDB …
[Read more]MariaDB 10.0.18 was recently released, and is available for download here:
https://downloads.mariadb.org/mariadb/10.0.18/
This is the ninth GA release of MariaDB 10.0, and 19th overall release of MariaDB 10.0.
There were no major functionality changes, but there were some general improvements, several security fixes, plus a 10.0.18 mysql_upgrade caution, and quite a few bug fixes, so let me cover what I feel are the main items of note:
- Security Fixes: Fixes for the following security vulnerabilities:
MariaDB 5.5.43 was recently released (it is the latest MariaDB 5.5), and is available for download here:
https://downloads.mariadb.org/mariadb/5.5.43/
This is a maintenance release, and so there were not too many major changes, but definitely a few worth mentioning, as well as one *important* caution:
- Security Fixes: Fixes for the following security vulnerabilities:
This is a little quiz (could be a discussion). I know what we tend to prefer (and why), but we’re interested in hearing additional and other opinions!
Given the way MySQL/MariaDB is architected, what would you prefer to see in a new server, more cores or higher clock speed? (presuming other factors such as CPU caches and memory access speed are identical).
For example, you might have a choice between
- 2x 2.4GHz 6 core, or
- 2x 3.0GHz 4 core
which option would you pick for a (dedicated) MySQL/MariaDB server, and why?
And, do you regard the “total speed” (N cores * GHz) as relevant in the decision process? If so, when and to what degree?
MySQL 5.6.24 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.
For this release, there are 4 “Functionality Added or Changed” items:
- Functionality Added/Changed: CMake support was updated to handle CMake version 3.1.
- Functionality Added/Changed: The server now includes its version number when it writes the initial “starting” message to the error log, to make it easier to tell which server instance error log output applies to. This value is the same as that available from the version system variable. (Bug #74917)
- Functionality Added/Changed: ALTER TABLE did not take advantage of fast alterations that might otherwise apply to the operation to …
MySQL 5.5.43 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:
http://dev.mysql.com/downloads/mysql/5.5.html
This release, similar to the last 5.5 release, is mostly uneventful.
There were only 2 “Functionality Added or Changed” items this time, and 10 additional bugs fixed.
Out of the 10 bugs, there was 1 InnoDB bug, 1 replication bug, and 6 crashing bugs, all of which seemed rather minor or obscure. Here are the ones worth noting:
- Functionality Changed: CMake support was updated to handle CMake version 3.1.
- Functionality Added: The server now includes its version number when it writes the initial “starting” message to the error log, to make it easier to tell which server instance error log output applies to. This value is the …
MariaDB is looking to hire Support Engineers. If interested, email me your resume.
I look forward to hearing from you.
MySQL 5.7.7 was recently released (it is the latest MySQL 5.7, and is the first “RC” or “Release Candidate” release of 5.7), and is available for download here and here.
As for the fixes/changes, there are quite a few again, which is expected in an early RC release.
The main highlights for me were (though the enhancements, and potentially impactful changes, are definitely not limited to this list):
- Optimizer Note: It is now possible to provide hints to the optimizer within individual SQL statements, which enables finer control over statement execution plans than can be achieved using the optimizer_switch system variable. Optimizer hints are specified as /*+ … */ comments following the SELECT, INSERT, REPLACE, …
MySQL 5.7.6 was recently released (it is the latest MySQL 5.7, and is the “m16” or “Milestone 16” release), and is available for download here and here.
As for the fixes/changes, there are quite a few (the official release was again split into 3 separate emails), which is expected in a “milestone” release.
The main highlights for me were (though the enhancements, and potentially impactful changes, are definitely not limited to this list):
- Incompatible Change: The CREATE USER and ALTER USER statements have additional account-management capabilities. Together, they now can be used to fully establish or modify authentication, SSL, and resource-limit properties, as well as manage password expiration and account locking and …