While headlines likes this are really silly I thought it might be worth sharing some experience with 8.0.0 on a few servers I use. I tend to test new versions of MySQL first as a slave. That is easy as it requires little work: make a copy of a working 5.7 slave, upgrade the server … Continue reading MySQL 8.0.0 first impressions: been running for 60 days
10 Older Entries »
The first DMR of MySQL 8 was recently released. While a DMR (or Developer Milestone Release) is not yet a GA product, it does come with our commitment that each feature has been tested and qualified for inclusion.
In MySQL 8.0 we have made additional improvements to the MySQL test framework (MTR) and the test suite.…
This blog post will detail the results of Samsung storage in
benchmark using Percona Server.
I had an opportunity to test different Samsung storage devices under tpcc-mysql benchmark powered by Percona Server 5.7. You can find a summary with details here https://github.com/Percona-Lab-results/201607-tpcc-samsung-storage/blob/master/summary-tpcc-samsung.md
I have in my possession:
- Samsung 850 Pro, 2TB: This is a SATA device and is positioned as consumer-oriented, something that you would use in a high-end user desktop. As of this post, I estimate the price of this device as around $430/TB.
Using Docker for development is a great way of ensuring that what you develop will be the same that you deploy in production. This is true for almost everything. If you develop on Linux, the above statement holds. If you develop on a different operating system (OSX or Windows) there are several restrictions.
I showed one of those issues in a recent article (MySQL and Docker on a Mac: networking oddity.) When you want to export a port from a service running in the container, the exported port is not available in your mac, but in the virtual machine that runs Docker services. This happens with any application that listens to a port.
The second limitation I found affects only MySQL, and it is related to using volumes. The proper way of achieving data persistence with …[Read more]
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
MySQL-Sandbox is a great tool for testing a new
release, and in fact this is what I do when a new MySQL tarball
becomes available. I don't think many people are aware of the
full testing capabilities of the sandbox, though.
When you think about testing, you may just think of creating a sandbox with the new tarball, and then hammering it with your pet procedure. That works, of course, as the main purpose of MySQL-Sandbox is to allow you to do just that. There is, however, a full test suite that can tell you in a short while if your tarball is compatible with the past or not.
This procedure is quite strict. It has happened several times that I caught a bug in a new release of MySQL, or Percona Server, or MariaDB, just by running this suite.
How MySQL-Sandbox gets testedBefore describing how to test, I would like to show what I do. When a new version of MySQL-Sandbox is ready …
MySQL replication in action - Part 1: GTID &
CoMySQL replication in action - Part 2 - Fan-in
In the previous article, we saw the basics of establishing replication from multiple origins to the same destination. By extending that concept, we can deploy more complex topologies, such as the point-to-point (P2P) all-masters topology, a robust and …
Oracle recently published the MySQL 5.7.5 Development Milestone release, a pre-production release providing numerous improvements to the MySQL server. You can download the release here: http://dev.mysql.com/downloads/mysql/5.7.html
This release carries some incompatible changes, as explained in the release notes and in the blog post describing the release. During my work in the Server QA team I have experienced some of these changes first hand already, and we have had to modify some tests and tools to adapt to some of it.
One very big change (well, some may not notice at all, while others may need to adjust their tools and applications) is the new default value …[Read more]
10 Older Entries »