(Jean-Jérôme Schmidt) Helping users securely automate and manage their open source databases has been at the core of our efforts from the inception of Severalnines.

(Vadim Tkachenko) In this post, we’ll briefly look at window functions in MySQL 8.0.

(Shree Nair) Amazon Web Services (AWS) is a cloud platform that offers a wide variety of services including computing power, database storage, content delivery and other functionality that targets businesses of all sizes. One of their database solutions includes the Amazon Relational Database Servic

(Valeriy Kravchuk) I’d say that strace utility is even more useful for MySQL DBAs than lsof. Basically, it is a useful general purpose diagnostic and debugging tool for tracing system calls some process makes and signals it receives.

(Rathish Kumar) This is a short post about DELETE data from huge table in MySQL. Most of us experienced, deleting huge record from MySQL tables taking long time, sometimes hours to complete deleting millions of records.

(Bernt Marius Johnsen) In my blog MySQL 8.0 Collations: Migrating from older collations I showed a query that could identify the values that might break a unique constraint when migrate your data. That query was not very efficient due to the self join of the converted values.

Migrating a MySQL database usually requires only few simple steps, but can take quite some time, depending on the amount of data you would like to migrate.

(Jean-François Gagné) In a previous post, I talked about the existence of a CREATE TABLE that is crashing MySQL up to versions 5.5.58, 5.6.38 and 5.7.20, and MariaDB up to version 5.5.57, 10.0.32, 10.1.26 and 10.2.7.

(Jesper Krogh) Sometimes it can be useful to take a step back and look at the world from a bit larger distance than usual. So in this blog, I will take a look at the high level architecture of MySQL Server.

(Rob Gravelle) Have you heard the expression “there’s an app for that”? Well, it’s true. Every day on the bus you can observe riders immersed in their phones.