The MariaDB CONNECT storage engine offers access to JSON file and allows you to see a external JSON file as a MariaDB table. A nice feature of the CONNECT storage Engine is its capability to auto discover a table structure when the table correspond to external data. In our case the CONNECT storage engine will automatically [...]
MariaDB 10.1 shipped a few days ago, so it’s now a good time to focus on another important event. Last week we had a three day MariaDB developers meeting. It took place in Amsterdam (Oct 13-15). Meetings like this tend to have a great impact on the roadmap of the product. Booking.com was very kind […]
If you are in San Francisco on October 27, 2015, please come along to our MySQL team reception at Jillian's at Metreon. You do not require an Oracle OpenWorld pass to attend, all we ask is that you please register in advance.
We look forward to seeing you there!
I have released MySQL-Sandbox 3.1.01, which is the first release after the move to GitHub. While the changes are not so spectacular (it's a minor release, with mostly bug fixes), I am pleased to see that the move has started producing collaboration. Two of the changes were provided by Daniël van Eeden and Mark Leith, who have scratched some of their own itches by providing useful patches.
All in all, this period of working with GitHub has been liberating. Although Bazaar plays with the same principles of git, it lacks most of the tools and the know-how which characterizes git. Add to this that also my team has moved Tungsten Replicator …[Read more]
Registration for the Percona Live Amsterdam conference community dinner at Booking.com is ongoing. Please note the following:
- By Monday noon the kitchen will make the necessary purchasing. At this time we will have to give them a number, which we will not exceed.
- The number we will give them is $(number of registrants Monday 12:00) + X, X being a constant
- Those X tickets will be available until Tuesday 12:00
- After which the registration is closed. We wish to avoid throwing away food, on one hand, as well as respect those who have reserved place and avoid running out of food, on the other.
Entry to the Booking.com building will be made …[Read more]
By my count MySQL 5.7 added over 150 new features, and some of my favourite ones are based on community ideas and contributions:
- Statement Timeout (contributed by Davi Arnaut)
- Disabled Storage Engines (suggested by the community)
- MySQL Command Line client Ctrl+C support fixed (bug reported by the community)
- Barracuda + Dynamic row format enabled by default (change made to better support WordPress and …
The database was developed by MySQL employees, with substantial contributions form the community.
Recently, the database was updated to use some of the features in MySQL 5.7. As a result, we had two sets of samples, one to use with MySQL 5.0+, and one that only loads with MySQL 5.7.
I filed a feature request, offering a patch to use conditional schema and data changes, which was incorporated very quickly into the official release.
The current release, available within the …[Read more]
It's migration time. There was another project that I use often
and was still in Launchpad. The Sample Employees Database is now on
GitHub, under the same license it had before (CC
Figure 1 - Employees database
This database is interesting because it is not too small (like Sakila) and not too big. It has enough data to allow you to test in a non trivial way.
Installation and testInstalling the database is easy:
$ git clone https://github.com/datacharmer/test_db.git
$ cd test_db
$ mysql < employees.sql
CREATING DATABASE STRUCTURE
storage engine: InnoDB
I have three pieces of information to share about MySQL::Sandbox:
- Version 3.1.0 has migrated from Launchpad to GitHub
- This version is released under the Apache license. Both these changes are meant to improve and promote cooperation on the project.
- There is an important change related to usability. When using replication with MySQL::Sandbox and MySQL 5.6+, the server UUIDs become more readable (see below).
First, some words on the location changes. About two years ago, I started plans for a rewrite of MySQL::Sandbox. Then, I had some unexpected changes, which involved moving home to a different continent twice within twelve months. The project …[Read more]
Both raise very good points. Here is how we plan to address them:
- The permissions issue reported by Giuseppe will be fixed.
- When selecting from information_schema tables in show_compatibility_56=OFF mode, an error …