Ideas, releases, practical guides, and perspectives from the people building with MySQL.
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.30. This is a Stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.0.30 Release Notes Changelog What is MariaDB 10.0? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!
The post MariaDB 10.0.30 now available appeared first on MariaDB.org.
In this blog post, we’ll look at how “operator error” can cause serious problems (like the one we saw last week with AWS), and how to avoid them in MySQL using
--i-am-a-dummy
.
Recently, AWS had some serious downtime in their East region, which they explained as the consequence of a bad deployment. It seems like most of the Internet was affected in one way or another. Some on Twitter dubbed it “S3 Dependency Awareness Day.”
Since the outage, many companies (especially Amazon!) are reviewing their production access and deployment procedures. It would be a lie if I claimed I’ve never made a mistake in production. In fact, I would be afraid of working with someone who claims to have never made a mistake in a production environment.
Making a mistake or two is how you learn to have a full sense …
[Read more]Recently, I had to go through crash recovery of a large MariaDB 10.1.21 instance. After starting MariaDB, I started tailing the error logs expecting to wait many minutes while InnoDB was scanning ibd files. I was surprised (and actually delighted) with this:
[...] [...]:34:36 [...] [Note] InnoDB: Reading tablespace information from the .ibd files... [...]:34:53 [...] [Note] InnoDB: Processed
The MariaDB subquery cache feature added in MariaDB 5.3 is not widely known. Let’s see what it is and how it works.
What is a subquery cache?
The MariaDB subquery cache optimizes the execution of correlated subqueries. Correlated subqueries refer to a value from the parent query. For example:
SELECT id FROM product WHERE price NOT IN (SELECT MAX(price) FROM product GROUP BY category);
MariaDB only uses this optimization if the parent query is a SELECT, not an UPDATE or a DELETE. The subquery results get cached only for the duration of the parent query.
MariaDB added the subquery cache in v5.3. It is controlled by …
[Read more]We’ll show you, how to secure LEMP stack. LEMP, it stands for Linux, (EngineX) NGINX, MariaDB (or MySQL) and PHP. Due to its flexibility and simplicity, NGINX slowly takes over the Internet. In this tutorial, we will attempt, through examples of bad and good practices, to go through the steps of properly securing your Linux web server. […]
The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.4 Release Candidate (RC). See the release notes and changelog for details. Download MariaDB 10.2.4 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!
The post MariaDB 10.2.4 RC now available appeared first on MariaDB.org.
Introduction As previously explained, you can run database integration tests 20 times faster! The trick is to map the data directory in memory, and my previous article showed you what changes you need to do when you have a PostgreSQL or MySQL instance on your machine. In this post, I’m going to expand the original … Continue reading How to run integration tests at warp speed using Docker and tmpfs →
I will be heading to Brussels on Friday for FOSDEM.
On Friday, February 3rd, I will attend the Pre-FOSDEM MySQL Day where I will give two talks:
How Booking.com avoids and deals with replication lag (at 12:05), Monitoring Booking.com without looking at MySQL (at 15:30).
(A summary of those talks can be found in Le Fred's blog.)
Then, on Saturday, February 4th, I have a talk in the MySQL
Last month, MariaDB officially released MariaDB ColumnStore, their column store engine for MySQL. This post discusses what it is (and isn’t), why it matters and how you can approach a test of it.
What is ColumnStore?
ColumnStore is a storage engine that turns traditional MySQL storage concepts on their head. Instead of storing the data by row, a column store stores the data by column (obviously). This provides advantages for certain types of data, and certain types of queries run against that data. See my previous post for more details on column-based storage systems.
ColumnStore is a fork of InfiniDB and carries forward many of the concepts behind that product. InfiniDB ceased operations in 2014. With the front end managed through MariaDB, you get access to …
[Read more]This post is part of the series "please do not ignore warnings in MySQL/MariaDB". The previous post of the series can be found here.
In this post, I will present why ignoring warnings made me lose time in upgrading MariaDB Server. I think this war story is entertaining to read and it is also worth presenting to people claiming that ignoring warnings is no big deal.
A few months ago, I was in
