I have a new blog post on blog.booking.com describing MariaDB 10.1 Optimistic Parallel Replication (with benchmark results):
Evaluating MySQL Parallel Replication Part 4: More Benchmarks in Productionhttp://blog.booking.com/evaluating_mysql_parallel_replication_4-more_benchmarks_in_production.html
If you want to know more about MySQL/MariaDB Parallel Replication and if you are attending
If there is something that I love about information technology is
the incredible amount of unpredictable ways that bugs can bite
you where and when you less expect it.
This one I'm about to describe is a serious one, yet there has
been a very quiet response from Percona bug team at Launchpad,
where I first submitted it (because we use Percona server here).
If you have read my other posts you know by now that I am a
laz... err, busy guy so bear with me if only today I have
verified that this is, in fact, an upstream bug and have raised a
bug to Oracle too.
It affects 5.6.33, latest version at the time of this
article.
Anyways, the bug started to manifest itself in the form of
complete stalls of our main cluster, which was happening at
different times and apparently in a way that was unrelated to the
amount of traffic hitting the master. When stalling, system
CPU time was topping 100% of total available …
With MySQL 8.0, we are bringing in an important change in the way user management DDLs are executed.
Background
User management DDLs cover following user management actions:
Each of these administrative action can handle multiple entities as a part of single command.…
With Oracle Open World behind us, we are now getting ready for the next big event, i.e. the European edition of PerconaLive. I am going to be a presenter three times:
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):
FRM-less, transactional data dictionary is arguably the most
significant feature change announced MySQL 8.0 development
release. The server still has two separate dictionaries (MySQL,
InnoDB) but the infamous FRM files are finally being replaced
with transactional, InnoDB-based storage.
While this is interesting for various reasons, this particular
post will focus on the impact this change has on data dictionary
performance.
Test configuration Server configuration:
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:
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:
BakaSQL: a bit of history When I joined this new company I was
already aware there was a lot of work to do. There was no DBA
Team to speak of; any MySQL related task was handled by the
sysadmins, and the company was growing as fast as you can
imagine, with 15-20 new employees arriving each month, most of
them in the IT department. For sure, there was much fun
ahead.
During my first week in the new job I immediately felt that
something was not right. I was receiving too much DMLs to execute
each day, spanning a wide set of servers, schemas an tables. This
is not something I had seen before, so I started asking around
what the reason behind it was. It turned out that there
were multiple reasons behind it:
Another day at the office...
"Whoa, the write workload on our statistical cluster has
suddendly increased by 20% and the filesystem that holds
the binary logs is no longer large enough".
Of course, I had warned the boss about this possibility when I
received those servers with that tiny 250G filesystem for
binlogs, but my red flag was just ignored as usual.
So here we are, presto I get this new shiny 600G LUN, but we need
to stop the damn MySQL server in order to repoint the log_bin
variable to the new storage area.
Dunno about you, but the idea of waking up at 2am to just perform
a variable change is not something that makes me particularly
happy. Not to mention the maintenance period that is needed
around it....
So, I decided to investigate a bit about the possibilities to do
such change without stopping the service.
As we all know, the log_bin …
The MySQL keynote at Oracle Open World 2016 announced the immediate availability of the MySQL Cloud Service, part of the larger Oracle Cloud offering. You can evaluate this now with a trial copy at cloud.oracle.com/mysql. MySQL server product manager Morgan Tocker gave two presentations at the event including a deep dive session.
This is the first release of the MySQL cloud service. As with all first releases there are some highlights and some pipeline features. All major cloud providers have MySQL offerings. AWS RDS (traditional, MAZ and Aurora) GCP Cloud SQL and Azure …
[Read more]