The devroom’s schedule is now published on Fosdem’s website.
As you can see, it will be a heavy day full of good content. You can also notice that there won’t be any lunch-time break.
We advise you to then bring your lunch (like a sandwich) with you in the room and eat it between talks or prepare in advance when you will take your break during a talk you don’t want to attend (is it even possible ?).
| Event | Speakers | Start | End |
|---|---|---|---|
| Sunday | |||
| Welcome to MySQL & Friends Devroom | … |
This blog explains how relay log recovery happens in a scenario
where an applier thread (SQL_Thread) is starting for the first
time and its starting position is not available for relay log
recovery operations. If you are using GTIDs with MASTER_AUTO_POSITION then the
following is more or less irrelevant since we then employ a more
resilient repositioning scheme. The potential issue described
here will also not occur if you have employed crash-safe replication settings,
including --sync_master_info=1. With those
disclaimers out of the way, let’s proceed.
Background
A crash-safe slave in MySQL …
[Read more]MySQL 5.6.22 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here.
For this release, there is 1 “Security Note”, 2 “Functionality Changed”, and 5 “Compilation Notes”, all benign, but let me address them:
MariaDB 5.5.41 was recently released (it is the latest MariaDB 5.5), and is available for download here:
https://downloads.mariadb.org/mariadb/5.5.41/
This is a maintenance release, and so there were not too many changes, *but* please take notice as there are 2 very important bug fixes:
I showed in an earlier post how to drop a whole database in a very safe way (no replication lag at all) and that technique is usable to drop a single table too, but cleaning up a table can take hours if not days to finish, so this is not the most comfortable way to do that. We also don’t want to have even a small spike of replication lag, so we need to find an another solution.
How to remove database in a safe way
When you have to drop a large database, you’ll encounter some
problems, mainly replication…
Read more
What happens when you issue a DROP TABLE command? The table has
to be removed from the table dictionary – which is a fast, atomic
operation – and has to be removed from file system too. If you
use older version than 5.5.10 you have to calculate with a huge
amount of time if your buffer pool is big, because the server
will scan through the pages there, checking if anything is in
memory from that …
MySQL 5.5.41 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
< Forgive me for the flurry of my latest release "Overview and Highlights" that will follow, as I had a serious-at-the-time health issue that delayed me for about a month. Back on track now though. :) >
This release, similar to the last 5.5 release, is mostly uneventful.
There was only 1 “Functionality Added or Changed” bugs this time, and 14 bugs overall fixed.
Out of the 14 bugs, there were 6 InnoDB bugs, and 2 replication bugs, all of which seemed rather minor or obscure. The one worth noting is the “Functionality Added or Changed” item, which was:
With the recent yaSSL issues, …
[Read more]MySQL 5.6 has an extensive list of new features and changes, so upgrading from a previous version can be risky if not tested extensively. For this reason, we recommend our users to read and understand the changes before doing the upgrade. If you are on older MySQL versions, it is probably time to think about upgrading. MySQL 5.6 was released in February 2013, that’s almost two years ago!
A major upgrade, e.g., from MySQL 5.5 to 5.6 or MariaDB 5.5 to 10, requires the former MySQL/MariaDB server related packages to be uninstalled. In Galera Cluster, there are two ways to upgrade; either by performing offline upgrade (safer, simpler, requires service downtime) or online upgrade (more complex, no downtime).
In this blog post, we are going to show you how to perform an offline upgrade on Galera-based …
[Read more]
There will be a MySQL & Friends Devroom at
the FOSDEM 2015 this year.And surprisingly
my talk - not sure you can call 15 min a talk - had been
accepted. (There are other accepted talks of course.)
It will be a dense talk about Docker/MySQL/Galera :)
We are (at least me) are going to have fun \o/ Erkan
I hope there will be an official announcement too.
Join 29,000 others and follow Sean Hull on twitter @hullsean. Oh RDS, you offer such promise, but damn it if the devil isn’t always buried in the details. Diving into a recent project, I’ve been looking at upgrading RDS MySQL. Major MySQL upgrades can be a bit messy. Since the entire engine is rebuilt, queries […]
"Should vegetarians open steakhouse restaurants?"
Though someone will probably give me several examples of why they
should, I'll argue that they absolutely should not. How can
someone who doesn't eat steak convince others to eat at their
"steak-only" restaurant?
But this is something a "professional technology benchmarker"
(PTB) struggles with on a regular basis. Hello, I'm Tim
Callaghan, and I'm a PTB.
professional technology benchmarker, or PTB (noun) : One
who compares two technologies as part of their job. One of these
technologies is usually the product of the PTB's employer, the
other is almost always not. In a past experience I was tasked
with comparing the performance of a fully in-memory database with
Oracle and MySQL on a "TPC-C like" workload. At the time I was an
Oracle expert and working for the in-memory database company, but
had never started a single MySQL server in my life. At …